Re: ERROR: tablespace "archive2" is not empty

From: Andres Freund <andres(at)anarazel(dot)de>
To: Josip Rodin <joy+pgsql(at)entuzijast(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: ERROR: tablespace "archive2" is not empty
Date: 2015-10-19 09:06:59
Message-ID: 20151019090659.GA3485@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andres Freund 2015-10-19 09:09:04 Re: postgresql 9.4 streaming replication
Previous Message Thom Brown 2015-10-19 09:00:58 Re: postgresql 9.4 streaming replication