create and drop tablespace - Mailing list 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

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 sent

WARNING: canceling waiting for synchronous replication due to user request

DETAIL: The transaction has already committed locally, but might not have been replicated to the stanby

CREATE 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?