| 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 09:14:33 |
| Message-ID: | 20151019091433.GA32412@entuzijast.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim Nasby | 2015-10-19 09:20:37 | Re: Recommendations for migrating PG 9.3 RDS across regions |
| Previous Message | Andres Freund | 2015-10-19 09:09:04 | Re: postgresql 9.4 streaming replication |