PostgreSQL
August 29, 2022
Удалить базу из кластера PG
Удалить базу которая уже не нужна очень просто.
yc postgresql database list --cluster-id $POSTGRES +------+----------------------+--------+------------+---------+--------------------------------+-------------------+ | NAME | CLUSTER ID | OWNER | LC COLLATE | LC TYPE | EXTENSIONS | TEMPLATE DATABASE | +------+----------------------+--------+------------+---------+--------------------------------+-------------------+ | db1 | c9qis2soj05q5fal9ue0 | cameda | C | C | pg_buffercache:, | | | | | | | | pg_repack:, pg_stat_kcache:, | | | | | | | | pg_stat_statements: | | | demo | c9qis2soj05q5fal9ue0 | cameda | C | C | pg_buffercache:, | | | | | | | | pg_repack:, pg_stat_kcache:, | | | | | | | | pg_stat_statements: | | | test | c9qis2soj05q5fal9ue0 | cameda | C | C | pg_buffercache:, | | | | | | | | pg_repack:, pg_stat_kcache:, | | | | | | | | pg_stat_statements: | | +------+----------------------+--------+------------+---------+--------------------------------+-------------------+
export POSTGRES=$(yc postgresql cluster get cam-postgres --format=json | jq -r ".id") yc postgresql database delete test --cluster-id $POSTGRES
Полезные ссылки.
Создали кластер здесь: https://teletype.in/@cameda/Lheee0sIIqV
Добавили базу test по аналогии: https://teletype.in/@cameda/tMfCh9jdzK-
August 29, 2022, 10:18
0 views
0 reposts