Re: Redo the filenode link in tablespace

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(dot)klaver(at)aklaver(dot)com
> <mailto: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 <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com