Re: ERROR: tablespace "archive2" is not empty

On 19. listopada 2015. 17:46:19 CEST, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> wrote:
>On 10/19/2015 08:28 AM, Josip Rodin wrote:
>> On Mon, Oct 19, 2015 at 08:23:24AM -0700, Adrian Klaver wrote:
>>> 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?
>>
>> Ah, I forgot to mention. 7849107 is symlinked to
>/media/archive2/postgresql,
>
>Except what you showed in you first post was:
>
>/media/ssd/archive2/postgresql
>
>Note the /media/ssd/*

Sorry, that's another typo. It's the latter. The symlink is indeed pointing to the 5 GB of leftovers.

>> so the symlink is referencing a real directory, and spclocation is
>broken
>> because that doesn't exist. But that sounds like an -ENOENT and not
>> -ENOPERM, no?
>>