Search Postgresql Archives

Re: Redo the filenode link in tablespace

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

 



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

2017-06-06 10:37 GMT-03:00 Adrian Klaver <adrian.klaver@xxxxxxxxxxx>:
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.klaver@xxxxxxxxxxx


[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