Re: Christopher Browne
So sorry to hear the news. May his soul rest in peace. Regards Pavan On Wed, Nov 4, 2020, 6:46 PM Jan Wieck wrote: > Christopher Browne was my colleague and friend at Afilias and past for > more than a decade. I have countless memories that connect us. He will be > missed. > > > Jan > > On Wed, Nov 4, 2020, 18:29 Steve Singer wrote: > >> >> It is with much sadness that I am letting the community know that Chris >> Browne passed away recently. >> >> Chris had been a long time community member and was active on various >> Postgresql mailing lists. He was a member of the funds committee, the >> PgCon >> program committee and served on the board of the PostgreSQL Community >> Association of Canada. Chris was a maintainer of the Slony >> replication system and worked on various PG related tools. >> >> I worked with Chris for over 10 years and anytime someone had a problem >> he >> would jump at the chance to help and propose solutions. He >> always had time to listen to your problem and offer ideas or explain how >> something worked. >> >> I will miss Chris >> >> Steve >> >> >> >>
Unable To Drop Tablespace
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? Regards Pavan
Re: Unable To Drop Tablespace
Thank you very much Ian. Will check it out. Regards On Thu, Feb 4, 2021, 5:43 PM Ian Lawrence Barwick wrote: > 2021年2月5日(金) 3:52 Pavan Pusuluri : > >> 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 > >
