2021年2月5日(金) 3:52 Pavan Pusuluri <pavan.pusul...@gmail.com>: > Hi there > > We 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 databases might still have objects in a database. There are a couple of useful queries demonstrating usage here: https://pgpedia.info/p/pg_tablespace_databases.html Regards Ian Barwick -- EnterpriseDB: https://www.enterprisedb.com
