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@aklaver.com
