Re: Redo the filenode link in tablespace

I will not be able to recover my information any more, right?

2017-06-06 10:37 GMT-03:00 Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>:

> On 06/06/2017 04:40 AM, tel medola wrote:
>
>> Lets go:
>> In my plsql:
>> rai=# select oid, * from pg_class where relfilenode = 5214489;
>>
>
> I was looking for:
>
> select oid, * from pg_class where oid = 5214493;
>
>
>> Result:
>> oid | relname | relnamespace | reltype | reloftype | relowner |
>> relam | relfilenode | reltablespace | relpages | reltuples |
>> relallvisible | reltoastrelid | reltoastidxid | relhasindex | relisshared |
>> relpersistence | relkind | relnatts | relchecks | relhasoids | relhaspkey |
>> relhasrules | relhastriggers | relhassubclass | relispopulated |
>> relfrozenxid | relminmxid | relacl | reloptions
>> ---------+-------------+--------------+---------+-----------
>> +----------+-------+-------------+---------------+----------
>> +--------------+---------------+---------------+------------
>> ---+-------------+-------------+----------------+---------+-
>> ---------+-----------+------------+------------+------------
>> -+----------------+----------------+----------------+-------
>> -------+------------+--------+------------
>> 5214489 | repositorio | 5205962 | 5214491 | 0 | 10
>> | 0 | 5214489 | 5205910 | 79303 | 1.31566e+006 |
>> 79303 | 5214493 | 0 | t | f | p
>> | r | 7 | 0 | f | t | f
>> | f | f | t | 9360288
>> | 1 | |
>> (1 registro)
>>
>> Ok?
>>
>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>