Re: ERROR: tablespace "archive2" is not empty

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)

% sudo -H -u postgres psql mydb -c "SELECT pg_relation_filenode(7877056);"
 pg_relation_filenode
----------------------

(1 row)

--
     2. That which causes joy or happiness.