Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lPX5W-0000sR-TR for pgsql-admin@arkaria.postgresql.org; Thu, 25 Mar 2021 21:00:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lPX5U-0003br-AF for pgsql-admin@arkaria.postgresql.org; Thu, 25 Mar 2021 21:00:16 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lPX5T-0003bk-Ml for pgsql-admin@lists.postgresql.org; Thu, 25 Mar 2021 21:00:16 +0000 Received: from sonic317-27.consmr.mail.bf2.yahoo.com ([74.6.129.82]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lPX5Q-0002Om-7H for pgsql-admin@postgresql.org; Thu, 25 Mar 2021 21:00:15 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1616706008; bh=ndPNU/9Bsids300U8L3wbvJRmmvluBhA1Fo30y2J5+0=; h=Date:From:Reply-To:To:Subject:References:From:Subject:Reply-To; b=OoHQraieG7q/VscUMqh8Krspe1XC+AjU65pAON7kwJYO1X+HbbFFfSWyJu8KZQM25MRYYUV+aQM8OdFOUfSAHC54uZ8BOG2BpKC+IEDbs867BLd7AvRt8wOBydhmde+ehFvqAfYegG1gR4iI9nfxnh+PfhNOHzT5qYeypCk18adnOEuhAwbfdbvgKy6XWZ3pPDTfHXcWyatdq5qD4O1vtYqMDbcymfQFTxZrH7Cr31ZF5UzyRw9wjNBmDmjogPdpey+4X6jv1v00XOFQsyXSX1zu1d0CfOl6urj/BAX0fIPtA87S5fGRSkL7u5ZIQ8fQwno6SSlb5ZnjtPRja+tidA== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1616706008; bh=UYJQvfqn4GnyF71O+XjewAQUo3gLf6L5o7I6xgNhe0E=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=jTeNs1+Nt5YiqD80pE0fOk5HhtIDbMObyFrlC/zVh78Da4u3vC/ZmgrJyNW5V3vIOPC9O8cCrhlnd9mtB7O6xqbeYQfR1Pn3pB9beEKriBa58NfIsUJ69jgzw/+GL/zknuz/kyZKfC3CJuxzDiEwhMJeDFOmkV6sD/mLQB9+4Pa34NOiFXJyOknCiI/4uh7kDq8RpzTXBLBPkpgeYX/hO09PrkqKwXYUNoqI8Ip3l/+IbHgLOKca6rme/CdJO94Lw2ky2yMNj/6EIKoplrXOQuib0cq7b9TbBe8OOG87yVk0yJFUusYcZo0d6XMWSPH+XrI3/v5AdF9emjKCL0EBRg== X-YMail-OSG: OQq8C3AVM1kQ1bqPm4iN3_5hwMouYP1Nn49BEhUYc.ON_SxgaKQfZ6.0CqloOZy tpBZ.fHNZlpqDJNIMJBKtZYwQG77ZI7k5HEiPFBeyJO7PdcHvO.mO2OPgYgTkXqQLcsy1oOR8RRT S_yU6f9DR3Hw3KUlfiGwWm27X05J9e6Tc3IHDrC0Q32aAOWrqIEuSMErSq0lqo8nkDOvY4veXUnI koh_7UMzArhSYV2PA8OZ56eEQpvLGzRA5aLS608BI7uL1k.fNsQ_BI3JQdHMJTrVkMKupjo1P1Fj H.xG_fnyvhcOY9tiGV09JG8exar1Z.f1b0fhizqn9NkMxoWUEEaYX59iFIqeXeFw7YW8RVvgX8xg ertQKKWSCnKqc8DvT4SYs1j.X2brQ4NYlXVsnFgrpADj0P3eX75yiUyyyAfFqBT59Oh_Rj.FfIt4 tgPRybaB2Xj8BspKXRYHH452TXN7GqMkLpqL7z7qHBng0RcAgwOw3MmvJB6yBPf_rjYWPwvq8zgm NO6mpLgOOnMHV7ILCzJm3MEicrScTPIj.YOqbxV_mdSPP4_gTyNjz82VeBBH6sKiA9gieDET6YBk gXN51NqFWuY1pDfnvj0RfuWxNPCX9vDVeSqNvfFOPKS1KADHNNOOfyiZOemWkLgYJUE1SQ4NFFpQ E4evelY23pPEkyCWuWuvCCXjSbfwgrRo6VF1qg2gjfdYRgBgnQZ.wmrlduSWbjtCY4inYS2LI6cy P0olG85bazECPnFTEk_A3Udfyl0AP2iuzE9AK0L6yiA_C719DzQjsGhQcIMb2m9tCXFKa6wgqE.D ItBWO8yFeQy4Tl_0tAWC7zcswS3M_mw7N2mJVUTw69IfhCvfdnSm._UySx1sb7lAKrZxMnuvJkkL aOYlAL5cHq0LpXAKdtN7Cs2R5K609X73BmKHuI2CyDXG3jlCrYYfkezJyCiO_sn1Kl3M4GnRhJMu 3xsymxwEY0SnxNpDMvT3JyFBOwwcgU5Ewg5QA2XT0cTe5CDs5SCOitHlM_de.4nQXWjsvS9gjyzU .01zOmPcCRVsv9tXjqBouAhTVPmcEHZ1hGPZGOzDBGZFcFh4DAliUNLmqFFbjfWHXJWQCLbsaG1j qC3fwTQtkeGjw7d9tAIkLuJ60fVCQ2HwQ4aXyVFIv1aB6TwrW1rNQtXyCxEFVlEEg2HrYQYxUy4L n4IeurVcFgbsYUyvhrjImEs5s3p16wLELPNe6jGJ95PsKEzDSbyuYIF3RbydFPW_2GD0tD0svjDL fsTmA_HaJXV0ji50W05lSTIwUnYTt62eYlM7S1Ofb2DmtbbHXE70FVgFbrLXrlFlJyJZ_zhRfK5I t9.NDKO3gCBDx1eC5W7UAEBaIljvHva8XuTPsbpgaVhgpSdTpQnCP4lFwwl4GWCS8FXI7oigMChd 0T570Lc5kdA3oX75gFAXHMwRF.eXlhOqnPad_tOiMjiuZ0jT1BOvOGLHHQLSUEjuNYSmCB7GAyHD bOP5Muy64H2wZVotyU.kFCp7z7ENVAjWG8HGXHtI0mSsiLeRQlvzMVEGReDSd2qnDAxMWJqiEAZH DDoQ.mRq.s1P37Asp_IbdiQ1fMMFuqJlJ5olw8TRYYjsxGlQoms0miz9moiallT2OF9hgGmWj82k TsS26ucrZp54MOlBH.JVmVZVsVdYWKePoXW5eYohONDQBOm7Vnf.rybDCLXc_JIeeLEciinXmNBm DLN5bxtxh5QLmaM5_TDDHCso4yHH_jTz4PsR0O8pOAesz1ltNHzx9Xd4hG_IjEZO9zsEeiAxKgN8 aywVQ_D1d0hPUtW.X8RWZpSfJgfykmqBHGOwXoJdlpnVo8IW7AH1od9TP.IARWXXBdI1eJdsHrfg qakmPg_fTOiKspvKsf4DmX_L..DIUhsSb_gVtHXNnJ.jUzpf1zWWzXn.SQO0FCe5xAu1If6eNsNh qPJXLO0kcGBztVDmjToby04L1E2RYHotGgDtHtey.GeIcPt9ajHfq8QAzuiGutTkGaIJQQscuTAI 8Y8QPO2qIJL4x1FV2tIrsrSS9yf8QjsIWQH9M679wnTluMibtLecubxO3pR2DfjTAlavJZW8lu7k S.FztipNR.8vEjLl1kWn5NNk3TgTr.x.xrCvUHNo1gC9Xl36nzzoxItU_YMJDxIKhNQ5wWR.tsAd Vdo8U_RIdTG5uNu.89uh46pt7_H_FuoMRDYzpe5IWnhfpUjgimJORadS5jBwdN21vxT0moWZOq92 AZxsgz14N5vx4NAc4ZfDQs0cHpSwROLCcuP53B.bYhL_OeqO6UAof0Ldxro1fC0NtPzuJS7__AR2 gyTzNv6rSrXZq1NUc1OgkphuyKNKumct0QY0ji1m1NnF_7gepobtLIt9FnR_HPZdSFGPncA9JGfS ZpQk3APinJxQDi84Vg3hm3X3hfOPQWUj2q6hvre9VRo9jlBc2UFbOhDncQ0.hRHurC8hQUXVh02D pEAFVgzDkBg-- X-Sonic-MF: Received: from sonic.gate.mail.ne1.yahoo.com by sonic317.consmr.mail.bf2.yahoo.com with HTTP; Thu, 25 Mar 2021 21:00:08 +0000 Date: Thu, 25 Mar 2021 21:00:08 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: Pgsql-admin Message-ID: <1597159861.228397.1616706008419@mail.yahoo.com> Subject: create and drop tablespace MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_228396_155862029.1616706008416" References: <1597159861.228397.1616706008419.ref@mail.yahoo.com> X-Mailer: WebService/1.1.17936 YMailNorrin Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36 Content-Length: 8123 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_228396_155862029.1616706008416 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi experts. I=C2=A0 created a tablspace successful on master=C2=A0=C2=A0postgres# creat= e tablespace portal_tbspc owner xxx location '/portaldata/postdata/portal_t= bspc';CREATE TABLESPACE but didn't see datafile exist in slave.=C2=A0 Tried to drop the tablespace (and recreate it)=C2=A0#DROP TABLESPACE portal= _tbspc;=C2=A0 =C2=A0and it hung for so long. I tried to recreate the same tablspace name again and it error already exis= ts... (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 cance= lled 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 transac= tion has already committed locally, but might not have been replicated to t= he stanbyCREATE TABLESPACE what cause the problem? Why the 1st creation is fine but can't drop? Second= one is pausing for so long?=C2=A0 How can I resolve this issue? Bach-Nga No one in this world is pure and perfect.=C2=A0 If you avoid people for the= ir mistakes you will be alone. So judge less, love, and forgive more.To cal= l 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 ------=_Part_228396_155862029.1616706008416 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi experts.

I&nbs= p; 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.
<= div dir=3D"ltr" data-setdir=3D"false">
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 locati= on '/portaldata/postdata/portal_data';
^CCancel request sent
W= ARNING: canceling waiting for synchronous replication due to user request
DETAIL: The transaction has alre= ady 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? Seco= nd one is pausing for so long?  How can I resolve this issue?


= Bach-Nga

No one in this worl= d is pure and perfect.  If you avoid people for their mistakes you wil= l be alone. So judge less, love, and forgive more.=3D"Emoji"3D"Emoji"3D"Emoji"
To call him a dog= hardly seems to do him justice though in as much as he had four legs, a ta= il, and barked, I admit he was, to all outward appearances. But to those wh= o knew him well, he was a perfect gentleman (Hermione Gingold)

**Live simply **Love g= enerously **Care deeply **Speak kindly.
**= * Genuinely rich *** Faithful talent *** Sharing success
=

------=_Part_228396_155862029.1616706008416--