From: | Josip Rodin <joy+pgsql(at)entuzijast(dot)net> |
---|---|
To: | Andres Freund <andres(at)anarazel(dot)de> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: ERROR: tablespace "archive2" is not empty |
Date: | 2015-10-19 10:18:13 |
Message-ID: | 20151019101813.GB11758@entuzijast.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, Oct 19, 2015 at 11:42:38AM +0200, Andres Freund wrote:
> On 2015-10-19 11:14:33 +0200, Josip Rodin wrote:
> > On Mon, Oct 19, 2015 at 11:06:59AM +0200, Andres Freund wrote:
> > > Hi,
> > >
> > > On 2015-10-19 10:49:11 +0200, Josip Rodin wrote:
> > > > % sudo -H -u postgres psql mydb -c "SELECT oid, relname, relkind FROM pg_catalog.pg_class where oid IN (7877054, 7877056);"
> > > > oid | relname | relkind
> > > > -----+---------+---------
> > > > (0 rows)
> > >
> > > That's the wrong query. The files on disk are relefilenodes not
> > > oids. Try WHERE pg_relation_filenode(oid) IN ...
> >
> > Oh, okay, but still:
> >
> > % sudo -H -u postgres psql mydb -c "SELECT pg_relation_filenode(7877054);"
> > pg_relation_filenode
> > ----------------------
> >
> > (1 row)
>
> Please actually run the query I suggested
> above. pg_relation_filenode(oid) returns the relfilenode of the table
> with the passed in oid - which you then compare with the relfilenode you
> saw on disk.
Oh, sorry, but yet again, there's just nothing there:
% sudo -H -u postgres psql mydb -c "SELECT oid, relname, relkind FROM pg_catalog.pg_class WHERE pg_relation_filenode(oid) IN (7877054, 7877056);"
oid | relname | relkind
-----+---------+---------
(0 rows)
--
2. That which causes joy or happiness.
From | Date | Subject | |
---|---|---|---|
Next Message | Yves Dorfsman | 2015-10-19 12:49:57 | Re: PSQL Tools |
Previous Message | Josip Rodin | 2015-10-19 10:15:07 | Re: ERROR: tablespace "archive2" is not empty |