Личный кабинет
Укажите e-mail, на который будет выслан код восстановления пароля.
На указанный вами адрес e-mail был выслан код подтверждения аккаунта. Введите полученный код для продолжения:
Введите новый пароль два раза:
2021年2月5日(金) 3:52 Pavan Pusuluri <pavan.pusuluri@gmail.com>:Hi thereWe are trying to drop a table space on RDS Postgres . We have removed the objects etc, but it still won't drop.I have checked and there's no reference anywhere to this tablespace but it complains it's not empty.I checked if it is a default for a database, revoked all privileges on the tablespace.We dropped the database but underpinning tablespace remained but when I query to see if any reference i get no hits."Select c.relname,t.spcname from pg_class c JOIN pg_tablespace t ON c.reltablespace=t.oid where t.spcname='mytablespace'I dont find any objects referencing. Kindly let me know if anything else needs to be checked?There's a handy function "pg_tablespace_databases()" to check which databasesmight still have objects in a database. There are a couple of useful queries demonstratingusage here: https://pgpedia.info/p/pg_tablespace_databases.htmlRegardsIan Barwick-- EnterpriseDB: https://www.enterprisedb.com
Hi thereWe are trying to drop a table space on RDS Postgres . We have removed the objects etc, but it still won't drop.I have checked and there's no reference anywhere to this tablespace but it complains it's not empty.I checked if it is a default for a database, revoked all privileges on the tablespace.We dropped the database but underpinning tablespace remained but when I query to see if any reference i get no hits."Select c.relname,t.spcname from pg_class c JOIN pg_tablespace t ON c.reltablespace=t.oid where t.spcname='mytablespace'I dont find any objects referencing. Kindly let me know if anything else needs to be checked?
В списке pgsql-general по дате отправления: