create and drop tablespace

From: Pepe TD Vo <pepevo(at)yahoo(dot)com>
To: Pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: create and drop tablespace
Date: 2021-03-25 21:00:08
Message-ID: 1597159861.228397.1616706008419@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi experts.
I  created a tablspace successful on master  postgres# create tablespace portal_tbspc owner xxx location '/portaldata/postdata/portal_tbspc';CREATE TABLESPACE
but didn't see datafile exist in slave. 

Tried to drop the tablespace (and recreate it) #DROP TABLESPACE portal_tbspc;   and it hung for so long.
I tried to recreate the same tablspace name again and it error already exists... (I know that but don't know why it hung for so long when I dropped it)
create another tablespacce and still pause for more than 5 minutes, I cancelled the request and received:#create tablespace portal_tablespace location '/portaldata/postdata/portal_data';^CCancel request sentWARNING: canceling waiting for synchronous replication due to user requestDETAIL: The transaction has already committed locally, but might not have been replicated to the stanbyCREATE TABLESPACE
what cause the problem? Why the 1st creation is fine but can't drop? Second one is pausing for so long?  How can I resolve this issue?

Bach-Nga

No one in this world is pure and perfect.  If you avoid people for their mistakes you will be alone. So judge less, love, and forgive more.To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)
**Live simply **Love generously **Care deeply **Speak kindly.*** Genuinely rich *** Faithful talent *** Sharing success

Browse pgsql-admin by date

  From Date Subject
Next Message Paul Smith 2021-03-26 09:16:00 Re: Creating redwood datestyle in Postgres 12
Previous Message Laurenz Albe 2021-03-25 17:02:03 Re: Creating redwood datestyle in Postgres 12