Search Postgresql Archives

Re: ERROR: tablespace "archive2" is not empty

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 10/19/2015 07:56 AM, Josip Rodin wrote:
On Mon, Oct 19, 2015 at 07:38:32AM -0700, Adrian Klaver wrote:
What happens if you do?:

select oid, * from pg_tablespace ;

mydb=> select oid, * from pg_tablespace where spcname = 'archive2';
    oid   | spcname  | spcowner |     spclocation      | spcacl | spcoptions
---------+----------+----------+----------------------+--------+------------
  7849107 | archive2 |       10 | /media/archive2/psql |        |
(1 row)

select * from pg_class where reltablespace = <archive2 oid>;

mydb=> select * from pg_class where reltablespace = 7849107;
  relname | relnamespace | reltype | reloftype | relowner | relam | relfilenode | reltablespace | relpages | reltuples | reltoastrelid | reltoastidxid | relhasindex | relisshared | relpersistence | relkind | relnatts | relchecks | relhasoids | relhaspkey | relhasrules | relhastriggers | relhassubclass | relfrozenxid | relacl | reloptions
---------+--------------+---------+-----------+----------+-------+-------------+---------------+----------+-----------+---------------+---------------+-------------+-------------+----------------+---------+----------+-----------+------------+------------+-------------+----------------+----------------+--------------+--------+------------
(0 rows)

It's there, but it's not there-there :)


Should have added.

What does a listing of pg_tblspc/ in your $PGDATA directory show?

--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux