Re: cannot drop a tablespace which never exists in pg_tablespace - Mailing list pgsql-general

From Bharani SV-forum
Subject Re: cannot drop a tablespace which never exists in pg_tablespace
Date
Msg-id 783439164.5695290.1734713539262@mail.yahoo.com
Whole thread Raw
In response to Re: cannot drop a tablespace which never exists in pg_tablespace  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses any tips to have restricted inbound and getting connected with postgresql dB
List pgsql-general
I found the culprit 
env variable was defined as PG_DATA inlieu of PGDATA

cleared and dropped it
and restarted db
and created once again tablespace in the desired location and it worked

Thank You
Regards

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


On 12/20/24 08:09, Bharani SV-forum wrote:
> Adrian
> Inline image
>
> 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
>
> the tablespace was created under  /XXX/YYYY/ABC/15/tblspace/<<tbl_spcname>>/
> assume tablespace name is abc_data
>
> *cd /XXX/YYYY/ABC/15/tblspace/abc_data/*
> ls -atl
> drwxr-x---. 2 postgres postgres  6 Dec 19 22:08 PG_15_202209061
>
> ls -altR
> drwxr-x---. 2 postgres postgres  6 Dec 19 22:08 PG_15_202209061
>
> i reconfirmed
> SELECT * FROM pg_tablespace ;
>   oid  |  spcname   | spcowner | spcacl | spcoptions
> ------+------------+----------+--------+------------
>   1663 | pg_default |       10 |        |
>   1664 | pg_global  |       10 |        |
>
> not having any entry about tablespace abc_data
>
> Can you guide
>

--
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: cannot drop a tablespace which never exists in pg_tablespace
Next
From: Y_Bharani_mbsv
Date:
Subject: any tips to have restricted inbound and getting connected with postgresql dB