Re: ERROR: tablespace "archive2" is not empty - Mailing list pgsql-general

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 ...

Greetings,

Andres Freund