From: | Josip Rodin <joy+pgsql(at)entuzijast(dot)net> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: ERROR: tablespace "archive2" is not empty |
Date: | 2015-10-19 15:28:40 |
Message-ID: | 20151019152840.GA6199@entuzijast.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, Oct 19, 2015 at 08:23:24AM -0700, Adrian Klaver wrote:
> On 10/19/2015 07:56 AM, Josip Rodin wrote:
> >On Mon, Oct 19, 2015 at 07:38:32AM -0700, Adrian Klaver wrote:
> >>What happens if you do?:
> >>
> >>select oid, * from pg_tablespace ;
> >
> >mydb=> select oid, * from pg_tablespace where spcname = 'archive2';
> > oid | spcname | spcowner | spclocation | spcacl | spcoptions
> >---------+----------+----------+----------------------+--------+------------
> > 7849107 | archive2 | 10 | /media/archive2/psql | |
> >(1 row)
> >
> >>select * from pg_class where reltablespace = <archive2 oid>;
> >
> >mydb=> select * from pg_class where reltablespace = 7849107;
> > relname | relnamespace | reltype | reloftype | relowner | relam | relfilenode | reltablespace | relpages | reltuples | reltoastrelid | reltoastidxid | relhasindex | relisshared | relpersistence | relkind | relnatts | relchecks | relhasoids | relhaspkey | relhasrules | relhastriggers | relhassubclass | relfrozenxid | relacl | reloptions
> >---------+--------------+---------+-----------+----------+-------+-------------+---------------+----------+-----------+---------------+---------------+-------------+-------------+----------------+---------+----------+-----------+------------+------------+-------------+----------------+----------------+--------------+--------+------------
> >(0 rows)
> >
> >It's there, but it's not there-there :)
> >
>
> Should have added.
>
> What does a listing of pg_tblspc/ in your $PGDATA directory show?
Ah, I forgot to mention. 7849107 is symlinked to /media/archive2/postgresql,
so the symlink is referencing a real directory, and spclocation is broken
because that doesn't exist. But that sounds like an -ENOENT and not
-ENOPERM, no?
--
2. That which causes joy or happiness.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2015-10-19 15:35:22 | Re: ERROR: tablespace "archive2" is not empty |
Previous Message | Tom Lane | 2015-10-19 15:24:10 | Re: ERROR: tablespace "archive2" is not empty |