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@xxxxxxxxxxx
<mailto: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 <mailto:adrian.klaver@xxxxxxxxxxx>
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
