Re: [GENERAL] Redo the filenode link in tablespace - Mailing list pgsql-general

On 06/06/2017 11:09 AM, tel medola wrote:
> I will not be able to recover my information any more, right?

That is what I am trying to figure out.

The last error you got was:

"
Returns the error below:
Missing chunk number 0 for toast value 10259186 in pg_toast_9277966
"

This is related to the TOAST table that should be associated with your
primary table:

https://www.postgresql.org/docs/9.6/static/storage-toast.html

When you did:

select * from pg_class where relfilenode = 5214489

where 5214489 is the relfilenode for the table repositorio you got among
other things:

reltoastrelid
5214493

https://www.postgresql.org/docs/9.6/static/catalog-pg-class.html

where 5214493 is the OID for the TOAST table that is supposed to be
associated with the repositorio table. That is why I wanted to see:

select oid, * from pg_class where oid = 5214493

to find out what relfilenode is for the TOAST table and then have you
look for it or maybe change it.




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


--
Adrian Klaver
adrian.klaver@aklaver.com