Postgres Pro
Downloads
Home   >   mailing lists

Re: Unable To Drop Tablespace - Mailing list pgsql-general

From Ian Lawrence Barwick
Subject Re: Unable To Drop Tablespace
Date
Msg-id CAB8KJ=j6gZ5DXWY2pTEkyBdBm1C=be-MHesOaqCjtLKKpNoiZQ@mail.gmail.com
Whole thread Raw
In response to Unable To Drop Tablespace  (Pavan Pusuluri <pavan.pusuluri@gmail.com>)
Responses Re: Unable To Drop Tablespace
Re: Unable To Drop Tablespace
List pgsql-general
Tree view
2021年2月5日(金) 3:52 Pavan Pusuluri <pavan.pusuluri@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:


Regards

Ian Barwick


--

pgsql-general by date:

Previous
From: Samuel Nelson
Date:
Subject: Re: Partition Creation Permissions
Next
From: Pavan Pusuluri
Date:
Subject: Re: Unable To Drop Tablespace