Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tOgEl-0080ho-Pw for pgsql-general@arkaria.postgresql.org; Fri, 20 Dec 2024 16:52:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tOgEl-00DwpF-6J for pgsql-general@arkaria.postgresql.org; Fri, 20 Dec 2024 16:52:26 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tOgEk-00Dwoc-Nd for pgsql-general@lists.postgresql.org; Fri, 20 Dec 2024 16:52:26 +0000 Received: from sonic305-21.consmr.mail.ne1.yahoo.com ([66.163.185.147]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tOgEh-000a8N-6a for pgsql-general@postgresql.org; Fri, 20 Dec 2024 16:52:25 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1734713541; bh=7Jpm6aKj2dDfixbgWqrKzdaI86OatcmNYUJQkLzVqjQ=; h=Date:From:To:In-Reply-To:References:Subject:From:Subject:Reply-To; b=oJuF20GtTue8w+v46M6lPKwdM4UVu4TM9lfstoT91sTaqW8+ZJaubv+YjCep9xggyP2ksjT27bRMvlllHRuygj8Bx7do9AKYuWg0oYMHi5newwhZY5iVDRdhkdvY6lJvNL1VwhqR6/1hpEJjTtvkD3cuKVUiEcoktm/SozL57rQCtWiZr+ntHTpunW//uMyJEjNaWhr+j8MhfL+5EHuVx6JG8ikORnbSCoggldcM3rSJl+EAWuiiwS4lcqdEXhdNqdWJbY0iqwrCcAXxgA3qTLyqs6NlfOw/YodzX7nRRdzokO0UHYEL3FudIWYvcjGFXGkVSLvbcqjl5NBILEuKxg== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1734713541; bh=9wbvCYqFiCPKiJ0vktwZ48CFzji2+k4uSE8zrZi+iC9=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=SgG04Wr8clNhpgwNxveZoiRlLWpzfN0eNlNeCu9YI9PBHdEXzYJfeYC1OtQeQnGxcwfMcnJFsC9JnCr7tyQ05X7zxg2unckm/dQj58l3O2HR/0i4MNlkORkV0k0EpvQwoA7iPVeb/Ky49Uyi+7hoGv+WB8DzD1pdNOvGYgkKuTWbwxRflU7vlxTW5n3Ea6AOM06a0vHWtR+JOtbR7GYJ4WayvU5Y0OiQmFQmBZQgr4DyWbNekHws4wLPsYsvRMxSK2gcR/cwCJbVatPYEWM/Lr4BLWvX0naHrS9e+1QERKO1xbE2bXrfg++tUMNMWiQBo2qDrNvjbiFIZAg8QQL/9A== X-YMail-OSG: Sru8M2UVM1l2_m5oWsyEPt6pV0VOEpWdDpqRX4R1fQgNOt81_q8H0xM9An8cNfN hppYyLI1UQIGGSZRn_3pHTIM1DWA60AmnsswzbNOJYz780HhhyCmFfS9gt6zAwNh8Rv.gNT_Fl8p EQtJDrRGZjbrjxey7YPdigxOtGW9gSgfe.FZoq5Ax7gEmrwOKN.EO4jXdPUakEweLUbmt4uG2u2C 5b2PQnX9opPPTJh223vKP4XVt8zcRyr4w1SmmE1HPoXfTnr59Utq9aukszv6ZxTxnw0dGeujjKNq 0kuoRc4oPvSvjvhVlNtWHLQwcvPzwSGEX4TMCWQwU8KNK4cRVKWLXtUY1t9nOs8r_kIKeKdKdUO1 YlxmNtttHe20faZhmgxNv4qSz3Je70p7k7UEwcHjSi0uin3Ox5Pd9wxF_ilzDMD8DofIWsqHfMyV hi1X_p4xTwtj.s1FpUHYuHKUOgEyLupNRk20ngBIIvm0nxbyWwYcRMu.1bdUFLIgrU46vn6aGonX 3rrXVfoRbFDs0BT8gbVb0BZ3075SD_Qqn_NPpSsHZNwfmGZF1hBEZMkLhYVXb0EOHskgqtUZ6UO_ zfqKSj4nI11rRetlfufgVeGpzEgFdFOTiuZGt7LXvhGSYUXffs6eT1ZK2DHEt7SGjOx77kSNBxmg KY5fSZi.0kCa.s_tTasAtmAW5OCz6jx2g14V8yMI1YimA40c7ZlXCS8JWM4hTwfqruFoMIDtCFtX BXf1qkvJtH_LxaECldsJgY3HqCQO0QmsN3tEMuYfdE7s7935RXxn0eVUhzaaIYVf_Vj4bT8v2v_v F2es0Ckn2OUePD_3MSz1S6u1ePTTSqqD6bwSqe.6S4tG64W.FdnAq34_UAOWzny.0orG_7cFwE.d 4vPs86xYHYPYyhJuZ3fdz9gCpR1bIFIDzVrNE6iMaQcJvqOC7y5R4gfvxticHoiM2vcTt4E5pTLS JlwRCdNZZj4pvuwlWSdNyoK0PXsc5nFTUxSO43k5U.bjHa99628VcubP01BE7v34dzkXZTzNmE.6 5Qeorg6yhKpdXtEB_VyohUQoKbILz5q5ZlA77VWIXC.RbxDt2480rFXsc0XOS66AofHcQ4Xl8dpR CZo5t55n6MBaPPFMcRRjcJ4ccn3BKtmAXMIHU0jSsyhhe1uGJnAEgKdNYB_RJx1CHgbc3Ahp8EI6 iifyqaGRQKh8gM4QWTmBAZ03Ss4MtJmQZJ6FdNVlKOS0ZG0RcvFjd7NpTH6lpTk1B2pLFvg9C7_s LV0nF17qCFbzKwWJxrVQFoNAhdeFndXgBNX0lR_WTtQfRwnw17KOqKMHOLhszE.BlgnD6r8h.u75 B_L1zKFANKQ3V3E8RjjXksX47IzpQGj3qXW6.FlE6QmHoE2k2C6HHPCagAYLrA0jjl5bmLqwX3h. HN7Tp1lDt7mKcYkyefxdEafctyW_gQwyZ1L0WHkCnetZoHjcBPAXJnhk9bTRQ0KXyOb7_oqAr9_9 P9iaLl3.P1ghXYcLYiDSEGzJ2TwjumkEM.XJpv2iMiBc1UIxWm7r1FRhaQRN723yqpSBr7tuZ5wq Be3ZyCqth_zXZKQqYRAU6moqo7VhJpC3y3gGSKiqaG4Hc5o2Wb_x1qSleJxmM.bepBJjwyeK_71i ksJ3condJv049bjuTGgNrQHcvjRVWDoycyEd3D0qnu6PsFDsv_TE4TYigbl4k57QDK5.YcA1N3wg W6tyQAcbygXxd8WAXZGJzXN5fTWb83wEbUMAKO4RhQi8cpdZG2LRzMAc_uFTTutxlxPEqzqEmR3g Rux0wWhuCTDBbRcGOiDrYosW7yDbPEcqvAj9ZjgQOBdjkfaJV_lfs5AtSYT6_eUwPxT2s2igLizq qKyT2O4f.TzcFiaDBIU9ET9qKHJuoWDiixf1rDWj453N1aYhG3S7E2l8Qg59jeBgKZYXq4BxMKEF LSZB2b8U7Il6fAHegx1ZteiXbL1Oi97cWogNai_wIJfM.nMc7_fBfau3Wd17FdW4MATIqD2xSYnt VtOQZib2.JUWjNSQd4gSEZUPFwAUXlT7km.92bYIxgSM5KWZJn_jcCUZXp9KV9WnozCxL.4NwvH_ 2LeWz.F5vgsCRoZYU1Worpa7clQ2QJYoNyW96F.6DBxZ6Y.SUk.ezhIvBuxEyrJ8eV2EXGpnm7gM uH580F9LQIWm.XaX4LwXjBL31LIhfLKn.7RqtjGAslu0ANdAbStRwjpGhx..hmJVZk3oWYQA0CYX xVsqEPL3hrgqNsUBw4XvWTK0.ptqPTofX0KpHCidpQceJqwZLyz9P912dP050bsh9Dypj_0x.60_ lCTaYElxA6Fbz0Mzy_dvc9JalcQ-- X-Sonic-MF: X-Sonic-ID: ef049dd3-5fe3-45ef-b9c5-159afd8b988f Received: from sonic.gate.mail.ne1.yahoo.com by sonic305.consmr.mail.ne1.yahoo.com with HTTP; Fri, 20 Dec 2024 16:52:21 +0000 Date: Fri, 20 Dec 2024 16:52:19 +0000 (UTC) From: Bharani SV-forum To: pgsql-general , Adrian Klaver Message-ID: <783439164.5695290.1734713539262@mail.yahoo.com> In-Reply-To: References: <0558ddd4d71641bdb41fa49b2425f73c@safrangroup.com> <07ab2d83-ffe5-4bec-9626-22a68f732579@aklaver.com> <273a88dc-4134-47d5-bc19-30ff5f97926c@aklaver.com> <498dfb34-4dd7-4f48-8188-355e1488d7e6@aklaver.com> <1061066336.5835157.1733316137292@mail.yahoo.com> <1918413683.2239751.1733944364448@mail.yahoo.com> <037a8338-3434-47d4-aaad-ef186d4d3250@aklaver.com> <101139100.4053671.1734383960480@mail.yahoo.com> <1875422740.4095620.1734388259706@mail.yahoo.com> <1528119631.4096246.1734390318281@mail.yahoo.com> <2033286177.1733661.1734651404850@mail.yahoo.com> <8833d8c7-3713-4d6f-9eab-35270e769564@aklaver.com> <1392047062.5689697.1734710997053@mail.yahoo.com> Subject: Re: cannot drop a tablespace which never exists in pg_tablespace MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_5695289_1149402187.1734713539260" X-Mailer: WebService/1.1.23040 YMailNorrin Content-Length: 5715 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_5695289_1149402187.1734713539260 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable I found the culprit=C2=A0env variable was defined as PG_DATA inlieu of PGD= ATA cleared and dropped itand restarted dband created once again tablespace in = the desired location and it worked Thank YouRegards On Friday, December 20, 2024 at 11:50:20 AM EST, Adrian Klaver wrote: =20 =20 On 12/20/24 08:09, Bharani SV-forum wrote: > Adrian > Inline image >=20 > initially i had created tblspace outside pg_data env variable Did you run CREATE TABLESPACE as shown below?: https://www.postgresql.org/docs/current/sql-createtablespace.html Did you ever use the tablespace? > e.g PG_DATA env variable is defined to /XXX/YYYY/ABC/15/data >=20 > the tablespace was created under =C2=A0/XXX/YYYY/ABC/15/tblspace/<>/ > assume tablespace name is abc_data >=20 > *cd /XXX/YYYY/ABC/15/tblspace/abc_data/* > ls -atl > drwxr-x---. 2 postgres postgres=C2=A0 6 Dec 19 22:08 PG_15_202209061 >=20 > ls -altR > drwxr-x---. 2 postgres postgres=C2=A0 6 Dec 19 22:08 PG_15_202209061 >=20 > i reconfirmed > SELECT * FROM pg_tablespace ; >=C2=A0 =C2=A0oid=C2=A0 |=C2=A0 spcname=C2=A0 =C2=A0| spcowner | spcacl | s= pcoptions > ------+------------+----------+--------+------------ >=C2=A0 =C2=A01663 | pg_default |=C2=A0 =C2=A0 =C2=A0 =C2=A010 |=C2=A0 =C2= =A0 =C2=A0 =C2=A0 | >=C2=A0 =C2=A01664 | pg_global=C2=A0 |=C2=A0 =C2=A0 =C2=A0 =C2=A010 |=C2=A0= =C2=A0 =C2=A0 =C2=A0 | >=20 > not having any entry about tablespace abc_data >=20 > Can you guide >=20 --=20 Adrian Klaver adrian.klaver@aklaver.com =20 ------=_Part_5695289_1149402187.1734713539260 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
I found the culprit 
env variable was defined as PG_DA= TA inlieu of PGDATA

cleared and dropped it
and = restarted db
and created once a= gain tablespace in the desired location and it worked

Tha= nk You
Regards

=20
=20
On Friday, December 20, 2024 at 11:50:20 AM EST, Ad= rian Klaver <adrian.klaver@aklaver.com> wrote:


=20 =20
On 12/20/24 08:09, Bharani SV-forum w= rote:
> Adrian
> Inline image
>
> initially i had created tblspac= e outside pg_data env variable

Did you= run CREATE TABLESPACE as shown below?:

https://www.postgres= ql.org/docs/current/sql-createtablespace.html

Did you ever use the tablespace?


> e.g PG_DATA env variable is defined to /XXX/YYYY/ABC/15/data
>
> the tablespace was created under &nb= sp;/XXX/YYYY/ABC/15/tblspace/<<tbl_spcname>>/
> assume tablespace name is abc_data
>
> *cd /XXX/YYYY/ABC/15/tblspace/abc_data/*
&= gt; ls -atl
> drwxr-x---. 2 postgres postgres  6 = Dec 19 22:08 PG_15_202209061
>
>= ls -altR
> drwxr-x---. 2 postgres postgres  6 De= c 19 22:08 PG_15_202209061
>
> i= reconfirmed
> SELECT * FROM pg_tablespace ;
>   oid  |  spcname   | spcowner= | spcacl | spcoptions
> ------+------------+---------= -+--------+------------
>   1663 | pg_defaul= t |       10 |        |
>   1664 | pg_global  |       = 10 |        |
>
> not having any entry about tablespace abc_data
>=
> Can you guide
>

--
Adrian Klaver
adrian.klaver@aklaver.com


------=_Part_5695289_1149402187.1734713539260--