public inbox for [email protected]
help / color / mirror / Atom feedFrom: Bharani SV-forum <[email protected]>
To: pgsql-general <[email protected]>
To: Adrian Klaver <[email protected]>
Subject: Re: cannot drop a tablespace which never exists in pg_tablespace
Date: Fri, 20 Dec 2024 16:09:56 +0000 (UTC)
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
<[email protected]>
<[email protected]>
<CANzqJaAda4nZbkG=c+72ry5GdaxrJ6Jzr6fz1quhq8tTfaX1Pg@mail.gmail.com>
<[email protected]>
<[email protected]>
<CANzqJaC1Uk4H=55vV_jbFYMuD1f9Bb_4Y9WKvkZA3bt92bEUnw@mail.gmail.com>
<[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
Adrian
initially i had created tblspace outside pg_data env variablee.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 -atldrwxr-x---. 2 postgres postgres 6 Dec 19 22:08 PG_15_202209061
ls -altRdrwxr-x---. 2 postgres postgres 6 Dec 19 22:08 PG_15_202209061
i reconfirmedSELECT * 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
On Thursday, December 19, 2024 at 06:46:33 PM EST, Adrian Klaver <[email protected]> wrote:
On 12/19/24 15:36, Bharani SV-forum wrote:
>
> cannot drop a tablespace which never exists in pg_tablespace
>
> I remember i had create previously an tablespace named " mq_data" , but
> cannot find in pg_tablespace listing.
>
> if i try to create the same tablespace name, it is giving error as "
> already in use as a tablespace"
> how to force drop the pointer entry and the tablespace from postgres
From:
https://www.postgresql.org/docs/current/manage-ag-tablespaces.html
"The directory $PGDATA/pg_tblspc contains symbolic links that point to
each of the non-built-in tablespaces defined in the cluster."
Is there a symlink at the above location?
Does the directory in the image have files?
>
> Inline image
>
--
Adrian Klaver
[email protected]
Attachments:
[image/png] 1734710671685blob.jpg (67.3K, 3-1734710671685blob.jpg)
download | view image
view thread (61+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: cannot drop a tablespace which never exists in pg_tablespace
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox