Redo the filenode link in tablespace

On 05/31/2017 06:05 AM, tel medola wrote:

Hi.
I have a rather serious problem in my database. I'll try to summarize
what happened and how far I've gotten with the help of friends from the
pgsql-sql list.

When I returned the copy of the drives, the records were no longer
found. For example, if I make a "select count (*) from" 01052016
".repository", the record amount will result to 0. But all the binaries
are there, intact.

As I said above, with the help of friends from the pgsql-sql list, I
managed to find the problem. When I did the truncate, the data was
erased and the filenode was recreated and pointed to a zero file. Doing
this query:
select pg_relation_filenode ('01052016.repository' :: regclass), it
returns me: 13741352, when the correct link (before truncate) was 5214489.

Now, doing this other query:
select c. *
From pg_class c
Where c.relfilenode = 13741352
He returns me:

relnamerelnamespacereltypereloftyperelownerrelam*relfilenode*reltablespacerelpagesreltuplesrelallvisiblereltoastrelidreltoastidxidrelhasindexrelissharedrelpersistencerelkindrelnattsrelchecksrelhasoidsrelhaspkeyrelhasrulesrelhastriggersrelhassubclassrelispopulatedrelfrozenxidrelminmxidrelaclreloptions
repositorio520596252144910100*13741352*520591000052144930TrueFalsepr70FalseTrueFalseFalseFalseTrue93602881

Now the question I need the help of friends ...

Is it possible to re-link to the item before truncate?

Did you get any help with this?

I noticed that it is not only a change of the field relfilenode, because
there are more fields to be informed, such as (relpages, reltuples).

Well the relpages, reltuples are estimated values that can be updated
with an ANALYZE.

Has anyone ever had to do this and succeeded?

Every help is welcome. I have a part of the production stopped and some
jobs are at risk.

Thanks
Roberto.

--
Adrian Klaver
adrian.klaver@aklaver.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Did you get any help with this?
*I formatted correctly before sending the email. Maybe you should ask
yourself if the mail server did not remove the formatting.*

Well the relpages, reltuples are estimated values that can be updated with
an ANALYZE.

*I can not make analyze on a table whose filenode is pointing to another
reference. The table is empty, just because the filenode does not point to
the correct ID.*

2017-05-31 20:22 GMT-03:00 Adrian Klaver <adrian.klaver@aklaver.com>:

On 06/01/2017 03:47 AM, tel medola wrote:

Did you get any help with this?
/I formatted correctly before sending the email. Maybe you should ask
yourself if the mail server did not remove the formatting./

I was talking about help with your relfilenode issue, I learned to deal
with the formatting awhile ago.

/
/
Well the relpages, reltuples are estimated values that can be updated
with an ANALYZE./
/

/I can not make analyze on a table whose filenode is pointing to another
reference. The table is empty, just because the filenode does not point
to the correct ID./

Understood, I was just saying that if you could get the table pointing
at the right relfilenode the other values would be synced up with an
ANALYZE.

At this point it is time to just try something. You have file level
backups of the various backups, so you can restore that if something
goes wrong, correct?

For 01052016.repositorio with current pg_class entry of relfilenode of
13741352, change that back to the old entry of 5214489.

--
Adrian Klaver
adrian.klaver@aklaver.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Sorry. I got sick these days and could not read my emails.

Thanks for your help.
I'll try to point to the direct node and see what happens.

2017-06-01 10:29 GMT-03:00 Adrian Klaver <adrian.klaver@aklaver.com>:

Done.
I followed the steps below after reconnecting the filenode:

Select * from "05122016".repositorio
Count -> 0

Then, I execute the commands:
Analyze "05122016".repositorio;
Count -> 0
Reindex "05122016".repositorio;
Count -> 1509046
Yes!

But...

select * from "05122016".repository where id_documento =
'{A647885D-9738-4617-ACE6-6351F6ADD341}'

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

I tried to do the commands below, but the error persists:
REINDEX table pg_toast.pg_toast_9277966;
VACUUM ANALYZE pg_toast_9277966
VACUUM ANALYZE "05122016".repositorio;

REINDEX TABLE pg_statistic;

I read in the forum to run the command:
Delete from pg_statistic;
Reindex table pg_statistic;
Vacuum analyze;

Is it okay to delete the pg_statistic table?

2017-06-05 9:24 GMT-03:00 tel medola <tel.medola@gmail.com>:

On 06/05/2017 07:17 AM, tel medola wrote:

Done.
I followed the steps below after reconnecting the filenode:

Select * from "05122016".repositorio
Count -> 0

Then, I execute the commands:
Analyze "05122016".repositorio;
Count -> 0
Reindex "05122016".repositorio;
Count -> 1509046
Yes!

But...

select * from "05122016".repository where id_documento =
'{A647885D-9738-4617-ACE6-6351F6ADD341}'

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

What does:

select * from pg_class where relfilenode = 5214489;

show?

I read in the forum to run the command:
Delete from pg_statistic;
Reindex table pg_statistic;
Vacuum analyze;

Is it okay to delete the pg_statistic table?

Do not delete the pg_statistic table. I would not even delete from it.

--
Adrian Klaver
adrian.klaver@aklaver.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

show?
*Yes*

Do not delete the pg_statistic table. I would not even delete from it.
*Sorry, I already deleted it. I looked for something official and found in
the site in postgres the reference that the delete could be done
(https://www.postgresql.org/docs/9.1/static/release-7-4-2.html
<https://www.postgresql.org/docs/9.1/static/release-7-4-2.html&gt;) and I
ended up doing it. Now I'm running a vacuum analyze across the base.*

2017-06-05 15:41 GMT-03:00 Adrian Klaver <adrian.klaver@aklaver.com>:

On 06/05/2017 11:55 AM, tel medola wrote:

show?
/Yes/

Yes, what?

Please run the command as shown:

select * from pg_class where relfilenode = 5214489;

and show the result.

Do not delete the pg_statistic table. I would not even delete from it.
/Sorry, I already deleted it. I looked for something official and found
in the site in postgres the reference that the delete could be done
(https://www.postgresql.org/docs/9.1/static/release-7-4-2.html) and I
ended up doing it. Now I'm running a vacuum analyze across the base./

2017-06-05 15:41 GMT-03:00 Adrian Klaver <adrian.klaver@aklaver.com
<mailto:adrian.klaver@aklaver.com>>:

On 06/05/2017 07:17 AM, tel medola wrote:

Done.
I followed the steps below after reconnecting the filenode:

Select * from "05122016".repositorio
Count -> 0

Then, I execute the commands:
Analyze "05122016".repositorio;
Count -> 0
Reindex "05122016".repositorio;
Count -> 1509046
Yes!

But...

select * from "05122016".repository where id_documento =
'{A647885D-9738-4617-ACE6-6351F6ADD341}'

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

What does:

select * from pg_class where relfilenode = 5214489;

show?

I read in the forum to run the command:
Delete from pg_statistic;
Reindex table pg_statistic;
Vacuum analyze;

Is it okay to delete the pg_statistic table?

Do not delete the pg_statistic table. I would not even delete from it.

--
Adrian Klaver
adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>

--
Adrian Klaver
adrian.klaver@aklaver.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

I will send as soon as possible. He's running the vacuum yet.

2017-06-05 16:02 GMT-03:00 Adrian Klaver <adrian.klaver@aklaver.com>:

Hi,
attachment.

select:
select * from pg_class where relfilenode = 5214489

Thanks

2017-06-05 16:02 GMT-03:00 Adrian Klaver <adrian.klaver@aklaver.com>:

On 06/05/2017 04:07 PM, tel medola wrote:

Hi,
attachment.

select:
select * from pg_class where relfilenode = 5214489

Next, what do you get from:

In psql
=> \x
Expanded display is on.

select oid, * from pg_class where oid = 5214493;

No need to create an attachment, just cut and paste into message.

Thanks

2017-06-05 16:02 GMT-03:00 Adrian Klaver <adrian.klaver@aklaver.com
<mailto:adrian.klaver@aklaver.com>>:

On 06/05/2017 11:55 AM, tel medola wrote:

show?
/Yes/

Yes, what?

Please run the command as shown:

select * from pg_class where relfilenode = 5214489;

and show the result.

Do not delete the pg_statistic table. I would not even delete
from it.
/Sorry, I already deleted it. I looked for something official
and found in the site in postgres the reference that the delete
could be done
(https://www.postgresql.org/docs/9.1/static/release-7-4-2.html
<https://www.postgresql.org/docs/9.1/static/release-7-4-2.html&gt;)
and I ended up doing it. Now I'm running a vacuum analyze across
the base./

2017-06-05 15:41 GMT-03:00 Adrian Klaver
<adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
<mailto:adrian.klaver@aklaver.com
<mailto:adrian.klaver@aklaver.com>>>:

On 06/05/2017 07:17 AM, tel medola wrote:

Done.
I followed the steps below after reconnecting the filenode:

Select * from "05122016".repositorio
Count -> 0

Then, I execute the commands:
Analyze "05122016".repositorio;
Count -> 0
Reindex "05122016".repositorio;
Count -> 1509046
Yes!

But...

select * from "05122016".repository where id_documento =
'{A647885D-9738-4617-ACE6-6351F6ADD341}'

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

What does:

select * from pg_class where relfilenode = 5214489;

show?

I read in the forum to run the command:
Delete from pg_statistic;
Reindex table pg_statistic;
Vacuum analyze;

Is it okay to delete the pg_statistic table?

Do not delete the pg_statistic table. I would not even
delete from it.

-- Adrian Klaver
adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
<mailto:adrian.klaver@aklaver.com
<mailto:adrian.klaver@aklaver.com>>

--
Adrian Klaver
adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>

--
Adrian Klaver
adrian.klaver@aklaver.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Lets go:
In my plsql:
rai=# select oid, * from pg_class where relfilenode = 5214489;

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?

2017-06-05 20:13 GMT-03:00 Adrian Klaver <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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

2017-06-06 10:37 GMT-03:00 Adrian Klaver <adrian.klaver@aklaver.com>:

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

rai=# 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
---------+------------------+--------------+---------+-----------+----------+-------+-------------+---------------+----------+-----------+---------------+---------------+---------------+-------------+-------------+----------------+---------+----------+-----------+------------+------------+-------------+----------------+----------------+----------------+--------------+------------+--------+------------
5214493 | pg_toast_5214489 | 99 | 5214494 | 0 | 10
| 0 | 13741353 | 5205910 | 0 | 0 |
0 | 0 | 5214495 | t | f | p
| t | 3 | 0 | f | t | f
| f | f | t | 9360288 |
1 | |
(1 registro)

rai=# select count(*) from pg_toast.pg_toast_5214489;

result:

count
------
0

If I do the select below (which is toast it returns me in error):
Select oid, * from pg_class where relname = 'pg_toast_9277966'
He will return me:

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
---------+------------------+--------------+---------+-----------+----------+-------+-------------+---------------+----------+-----------+---------------+---------------+---------------+-------------+-------------+----------------+---------+----------+-----------+------------+------------+-------------+----------------+----------------+----------------+--------------+------------+--------+------------
9277970 | pg_toast_9277966 | 99 | 9277971 | 0 | 10
| 0 | 13741363 | 9277962 | 0 | 0 |
0 | 0 | 9277972 | t | f | p
| t | 3 | 0 | f | t | f
| f | f | t | 9360288 |
1 | |
(1 registro)

filenode-> 13741363

That is, it is looking at a toast that is empty because it was done so
after I run the truncate.
The old filenode of the table "05122016".repositorio it's the: 13741352
(before my change)

rai=# select count(*) from pg_toast.pg_toast_9277966;

result:

count
------
0

I do not know if it helps, but the folder structure looks like this:

Volume in drive G is Gravacoes-III
Volume Serial Number is 8CF9-EDFA

Directory of g:\PG_9.3_201306121\32768

06/06/2017 13:18 <DIR> .
06/06/2017 13:18 <DIR> ..
23/05/2017 08:25 0 13741352
23/05/2017 08:25 0 13741353
06/06/2017 12:04 8.192 13789591
20/05/2016 09:10 649.650.176 5214489
20/05/2016 09:10 180.224 5214489_fsm
19/05/2016 23:47 16.384 5214489_vm
25/04/2016 09:00 1.073.741.824 5214493
25/04/2016 09:00 1.073.741.824 5214493.1
25/04/2016 09:00 1.073.741.824 5214493.10
25/04/2016 09:00 1.073.741.824 5214493.100
25/04/2016 09:00 1.073.741.824 5214493.101
25/04/2016 09:00 1.073.741.824 5214493.102
25/04/2016 09:00 1.073.741.824 5214493.103
25/04/2016 09:00 1.073.741.824 5214493.104
25/04/2016 09:00 1.073.741.824 5214493.105
25/04/2016 09:00 1.073.741.824 5214493.106
25/04/2016 09:00 1.073.741.824 5214493.107
25/04/2016 09:00 1.073.741.824 5214493.108
25/04/2016 09:00 1.073.741.824 5214493.109
25/04/2016 09:00 1.073.741.824 5214493.11
25/04/2016 09:00 1.073.741.824 5214493.110
25/04/2016 09:00 1.073.741.824 5214493.111
25/04/2016 09:00 1.073.741.824 5214493.112
25/04/2016 09:00 1.073.741.824 5214493.113
25/04/2016 09:00 1.073.741.824 5214493.114
25/04/2016 09:00 1.073.741.824 5214493.115
25/04/2016 09:00 1.073.741.824 5214493.116
25/04/2016 09:00 1.073.741.824 5214493.117
25/04/2016 09:00 1.073.741.824 5214493.118
25/04/2016 09:00 1.073.741.824 5214493.119
25/04/2016 09:00 1.073.741.824 5214493.12
25/04/2016 09:00 1.073.741.824 5214493.120
25/04/2016 09:00 1.073.741.824 5214493.121
25/04/2016 09:00 1.073.741.824 5214493.122
25/04/2016 09:00 1.073.741.824 5214493.123
25/04/2016 09:00 1.073.741.824 5214493.124
25/04/2016 09:00 1.073.741.824 5214493.125
25/04/2016 09:00 1.073.741.824 5214493.126
25/04/2016 09:00 1.073.741.824 5214493.127
25/04/2016 09:00 1.073.741.824 5214493.128
25/04/2016 09:00 1.073.741.824 5214493.129
25/04/2016 09:00 1.073.741.824 5214493.13
25/04/2016 09:00 1.073.741.824 5214493.130
25/04/2016 09:00 1.073.741.824 5214493.131
25/04/2016 09:00 1.073.741.824 5214493.132
25/04/2016 09:00 1.073.741.824 5214493.133
25/04/2016 09:00 1.073.741.824 5214493.134
25/04/2016 09:00 1.073.741.824 5214493.135
25/04/2016 09:00 1.073.741.824 5214493.136
25/04/2016 09:00 1.073.741.824 5214493.137
25/04/2016 09:00 1.073.741.824 5214493.138
25/04/2016 09:00 1.073.741.824 5214493.139
25/04/2016 09:00 1.073.741.824 5214493.14
25/04/2016 09:00 1.073.741.824 5214493.140
25/04/2016 09:00 1.073.741.824 5214493.141
25/04/2016 09:00 1.073.741.824 5214493.142
25/04/2016 09:00 1.073.741.824 5214493.143
25/04/2016 09:00 1.073.741.824 5214493.144
25/04/2016 09:00 1.073.741.824 5214493.145
25/04/2016 09:00 1.073.741.824 5214493.146
25/04/2016 09:00 1.073.741.824 5214493.147
25/04/2016 09:00 1.073.741.824 5214493.148
25/04/2016 09:00 1.073.741.824 5214493.149
25/04/2016 09:00 1.073.741.824 5214493.15
25/04/2016 09:00 1.073.741.824 5214493.150
25/04/2016 09:00 1.073.741.824 5214493.151
25/04/2016 09:00 1.073.741.824 5214493.152
25/04/2016 09:00 1.073.741.824 5214493.153
25/04/2016 09:00 1.073.741.824 5214493.154
25/04/2016 09:00 1.073.741.824 5214493.155
25/04/2016 09:00 1.073.741.824 5214493.156
25/04/2016 09:00 1.073.741.824 5214493.157
25/04/2016 09:00 1.073.741.824 5214493.158
25/04/2016 09:00 1.073.741.824 5214493.159
25/04/2016 09:00 1.073.741.824 5214493.16
25/04/2016 09:00 1.073.741.824 5214493.160
25/04/2016 09:00 1.073.741.824 5214493.161
25/04/2016 09:00 1.073.741.824 5214493.162
25/04/2016 09:00 1.073.741.824 5214493.163
25/04/2016 09:00 1.073.741.824 5214493.164
25/04/2016 09:00 1.073.741.824 5214493.165
25/04/2016 09:00 1.073.741.824 5214493.166
25/04/2016 09:00 1.073.741.824 5214493.167
25/04/2016 09:00 1.073.741.824 5214493.168
25/04/2016 09:00 1.073.741.824 5214493.169
25/04/2016 09:00 1.073.741.824 5214493.17
25/04/2016 09:00 1.073.741.824 5214493.170
25/04/2016 09:00 1.073.741.824 5214493.171
25/04/2016 09:00 1.073.741.824 5214493.172
25/04/2016 09:00 1.073.741.824 5214493.173
25/04/2016 09:00 1.073.741.824 5214493.174
25/04/2016 09:00 1.073.741.824 5214493.175
25/04/2016 09:00 1.073.741.824 5214493.176
25/04/2016 09:00 1.073.741.824 5214493.177
25/04/2016 09:00 1.073.741.824 5214493.178
25/04/2016 09:00 1.073.741.824 5214493.179
25/04/2016 09:00 1.073.741.824 5214493.18
25/04/2016 09:00 1.073.741.824 5214493.180
25/04/2016 09:00 1.073.741.824 5214493.181
25/04/2016 09:00 1.073.741.824 5214493.182
25/04/2016 09:00 1.073.741.824 5214493.183
25/04/2016 09:00 1.073.741.824 5214493.184
25/04/2016 09:00 1.073.741.824 5214493.185
25/04/2016 09:00 1.073.741.824 5214493.186
25/04/2016 09:00 1.073.741.824 5214493.187
25/04/2016 09:00 1.073.741.824 5214493.188
25/04/2016 09:00 1.073.741.824 5214493.189
25/04/2016 09:00 1.073.741.824 5214493.19
25/04/2016 09:00 1.073.741.824 5214493.190
25/04/2016 09:00 1.073.741.824 5214493.191
25/04/2016 09:00 1.073.741.824 5214493.192
25/04/2016 09:00 1.073.741.824 5214493.193
25/04/2016 09:00 1.073.741.824 5214493.194
25/04/2016 09:00 1.073.741.824 5214493.195
25/04/2016 09:00 1.073.741.824 5214493.196
25/04/2016 09:00 1.073.741.824 5214493.197
25/04/2016 09:00 1.073.741.824 5214493.198
25/04/2016 09:00 1.073.741.824 5214493.199
25/04/2016 09:00 1.073.741.824 5214493.2
25/04/2016 09:00 1.073.741.824 5214493.20
25/04/2016 09:00 1.073.741.824 5214493.200
25/04/2016 09:00 1.073.741.824 5214493.201
25/04/2016 09:00 1.073.741.824 5214493.202
25/04/2016 09:00 1.073.741.824 5214493.203
25/04/2016 09:00 1.073.741.824 5214493.204
25/04/2016 09:00 1.073.741.824 5214493.205
25/04/2016 09:00 1.073.741.824 5214493.206
25/04/2016 09:00 1.073.741.824 5214493.207
25/04/2016 09:00 1.073.741.824 5214493.208
25/04/2016 09:00 1.073.741.824 5214493.209
25/04/2016 09:00 1.073.741.824 5214493.21
25/04/2016 09:00 1.073.741.824 5214493.210
25/04/2016 09:00 1.073.741.824 5214493.211
25/04/2016 09:00 1.073.741.824 5214493.212
25/04/2016 09:00 1.073.741.824 5214493.213
25/04/2016 09:00 1.073.741.824 5214493.214
25/04/2016 09:00 1.073.741.824 5214493.215
25/04/2016 09:00 1.073.741.824 5214493.216
25/04/2016 09:00 1.073.741.824 5214493.217
25/04/2016 09:00 1.073.741.824 5214493.218
25/04/2016 09:00 1.073.741.824 5214493.219
25/04/2016 09:00 1.073.741.824 5214493.22
25/04/2016 09:00 1.073.741.824 5214493.220
25/04/2016 09:00 1.073.741.824 5214493.221
25/04/2016 09:00 1.073.741.824 5214493.222
25/04/2016 09:00 1.073.741.824 5214493.223
25/04/2016 09:00 1.073.741.824 5214493.224
25/04/2016 09:00 1.073.741.824 5214493.225
25/04/2016 09:00 1.073.741.824 5214493.226
25/04/2016 09:00 1.073.741.824 5214493.227
25/04/2016 09:00 1.073.741.824 5214493.228
25/04/2016 09:00 1.073.741.824 5214493.229
25/04/2016 09:00 1.073.741.824 5214493.23
25/04/2016 09:00 1.073.741.824 5214493.230
25/04/2016 09:00 1.073.741.824 5214493.231
25/04/2016 09:00 1.073.741.824 5214493.232
25/04/2016 09:00 1.073.741.824 5214493.233
25/04/2016 09:00 1.073.741.824 5214493.234
25/04/2016 09:00 1.073.741.824 5214493.235
25/04/2016 09:00 1.073.741.824 5214493.236
25/04/2016 09:00 1.073.741.824 5214493.237
25/04/2016 09:00 1.073.741.824 5214493.238
25/04/2016 09:00 1.073.741.824 5214493.239
25/04/2016 09:00 1.073.741.824 5214493.24
25/04/2016 09:00 1.073.741.824 5214493.240
25/04/2016 09:00 1.073.741.824 5214493.241
25/04/2016 09:00 1.073.741.824 5214493.242
25/04/2016 09:00 1.073.741.824 5214493.243
25/04/2016 09:00 1.073.741.824 5214493.244
25/04/2016 09:00 1.073.741.824 5214493.245
25/04/2016 09:00 1.073.741.824 5214493.246
25/04/2016 09:00 1.073.741.824 5214493.247
25/04/2016 09:00 1.073.741.824 5214493.248
25/04/2016 09:00 1.073.741.824 5214493.249
25/04/2016 09:00 1.073.741.824 5214493.25
25/04/2016 09:00 1.073.741.824 5214493.250
25/04/2016 09:00 1.073.741.824 5214493.251
25/04/2016 09:00 1.073.741.824 5214493.252
25/04/2016 09:00 1.073.741.824 5214493.253
25/04/2016 09:00 1.073.741.824 5214493.254
25/04/2016 09:00 1.073.741.824 5214493.255
25/04/2016 09:00 1.073.741.824 5214493.256
25/04/2016 09:00 1.073.741.824 5214493.257
25/04/2016 09:00 1.073.741.824 5214493.258
25/04/2016 09:00 1.073.741.824 5214493.259
25/04/2016 09:00 1.073.741.824 5214493.26
25/04/2016 09:00 1.073.741.824 5214493.260
25/04/2016 09:00 1.073.741.824 5214493.261
25/04/2016 09:00 1.073.741.824 5214493.262
25/04/2016 09:00 1.073.741.824 5214493.263
25/04/2016 09:00 1.073.741.824 5214493.264
25/04/2016 09:00 1.073.741.824 5214493.265
25/04/2016 09:00 1.073.741.824 5214493.266
25/04/2016 09:00 1.073.741.824 5214493.267
25/04/2016 09:00 1.073.741.824 5214493.268
25/04/2016 09:00 1.073.741.824 5214493.269
25/04/2016 09:00 1.073.741.824 5214493.27
25/04/2016 09:00 1.073.741.824 5214493.270
25/04/2016 09:00 1.073.741.824 5214493.271
25/04/2016 09:00 1.073.741.824 5214493.272
25/04/2016 09:00 1.073.741.824 5214493.273
25/04/2016 09:00 1.073.741.824 5214493.274
25/04/2016 09:00 1.073.741.824 5214493.275
25/04/2016 09:00 1.073.741.824 5214493.276
25/04/2016 09:00 1.073.741.824 5214493.277
25/04/2016 09:00 1.073.741.824 5214493.278
25/04/2016 09:00 1.073.741.824 5214493.279
25/04/2016 09:00 1.073.741.824 5214493.28
25/04/2016 09:00 1.073.741.824 5214493.280
25/04/2016 09:00 1.073.741.824 5214493.281
25/04/2016 09:00 1.073.741.824 5214493.282
25/04/2016 09:00 1.073.741.824 5214493.283
25/04/2016 09:00 1.073.741.824 5214493.284
25/04/2016 09:00 1.073.741.824 5214493.285
25/04/2016 09:00 1.073.741.824 5214493.286
25/04/2016 09:00 1.073.741.824 5214493.287
25/04/2016 09:00 1.073.741.824 5214493.288
25/04/2016 09:00 1.073.741.824 5214493.289
25/04/2016 09:00 1.073.741.824 5214493.29
25/04/2016 09:00 1.073.741.824 5214493.290
25/04/2016 09:00 1.073.741.824 5214493.291
25/04/2016 09:00 1.073.741.824 5214493.292
25/04/2016 09:00 1.073.741.824 5214493.293
25/04/2016 09:00 1.073.741.824 5214493.294
25/04/2016 09:00 1.073.741.824 5214493.295
25/04/2016 09:00 1.073.741.824 5214493.296
25/04/2016 09:00 1.073.741.824 5214493.297
25/04/2016 09:00 1.073.741.824 5214493.298
25/04/2016 09:00 1.073.741.824 5214493.299
25/04/2016 09:00 1.073.741.824 5214493.3
25/04/2016 09:00 1.073.741.824 5214493.30
25/04/2016 09:00 1.073.741.824 5214493.300
25/04/2016 09:00 1.073.741.824 5214493.301
25/04/2016 09:00 1.073.741.824 5214493.302
25/04/2016 09:00 1.073.741.824 5214493.303
25/04/2016 09:00 1.073.741.824 5214493.304
25/04/2016 09:00 1.073.741.824 5214493.305
25/04/2016 09:00 1.073.741.824 5214493.306
25/04/2016 09:00 1.073.741.824 5214493.307
25/04/2016 09:00 1.073.741.824 5214493.308
25/04/2016 09:00 1.073.741.824 5214493.309
25/04/2016 09:00 1.073.741.824 5214493.31
25/04/2016 09:00 1.073.741.824 5214493.310
25/04/2016 09:00 1.073.741.824 5214493.311
25/04/2016 09:00 1.073.741.824 5214493.312
25/04/2016 09:00 1.073.741.824 5214493.313
25/04/2016 09:00 1.073.741.824 5214493.314
25/04/2016 09:00 1.073.741.824 5214493.315
25/04/2016 09:00 1.073.741.824 5214493.316
25/04/2016 09:00 1.073.741.824 5214493.317
25/04/2016 09:00 1.073.741.824 5214493.318
25/04/2016 09:00 1.073.741.824 5214493.319
25/04/2016 09:00 1.073.741.824 5214493.32
25/04/2016 09:00 1.073.741.824 5214493.320
25/04/2016 09:00 1.073.741.824 5214493.321
25/04/2016 09:00 1.073.741.824 5214493.322
25/04/2016 09:00 1.073.741.824 5214493.323
25/04/2016 09:00 1.073.741.824 5214493.324
25/04/2016 09:00 1.073.741.824 5214493.325
25/04/2016 09:00 1.073.741.824 5214493.326
25/04/2016 09:00 1.073.741.824 5214493.327
25/04/2016 09:00 1.073.741.824 5214493.328
25/04/2016 09:00 1.073.741.824 5214493.329
25/04/2016 09:00 1.073.741.824 5214493.33
25/04/2016 09:00 1.073.741.824 5214493.330
25/04/2016 09:00 1.073.741.824 5214493.331
25/04/2016 09:00 1.073.741.824 5214493.332
25/04/2016 09:00 1.073.741.824 5214493.333
25/04/2016 09:00 1.073.741.824 5214493.334
25/04/2016 09:00 1.073.741.824 5214493.335
25/04/2016 09:00 1.073.741.824 5214493.336
25/04/2016 09:00 1.073.741.824 5214493.337
25/04/2016 09:00 1.073.741.824 5214493.338
25/04/2016 09:00 1.073.741.824 5214493.339
25/04/2016 09:00 1.073.741.824 5214493.34
25/04/2016 09:00 1.073.741.824 5214493.340
25/04/2016 09:00 1.073.741.824 5214493.341
25/04/2016 09:00 1.073.741.824 5214493.342
25/04/2016 09:00 1.073.741.824 5214493.343
25/04/2016 09:00 1.073.741.824 5214493.344
25/04/2016 09:00 1.073.741.824 5214493.345
25/04/2016 09:00 1.073.741.824 5214493.346
25/04/2016 09:00 1.073.741.824 5214493.347
25/04/2016 09:00 1.073.741.824 5214493.348
25/04/2016 09:00 1.073.741.824 5214493.349
25/04/2016 09:00 1.073.741.824 5214493.35
25/04/2016 09:00 1.073.741.824 5214493.350
25/04/2016 09:00 1.073.741.824 5214493.351
25/04/2016 09:00 1.073.741.824 5214493.352
25/04/2016 09:00 1.073.741.824 5214493.353
25/04/2016 09:00 1.073.741.824 5214493.354
25/04/2016 09:00 1.073.741.824 5214493.355
25/04/2016 09:00 1.073.741.824 5214493.356
25/04/2016 09:00 1.073.741.824 5214493.357
25/04/2016 09:00 1.073.741.824 5214493.358
25/04/2016 09:00 1.073.741.824 5214493.359
25/04/2016 09:00 1.073.741.824 5214493.36
25/04/2016 09:00 1.073.741.824 5214493.360
25/04/2016 09:00 1.073.741.824 5214493.361
25/04/2016 09:00 1.073.741.824 5214493.362
25/04/2016 09:00 1.073.741.824 5214493.363
25/04/2016 09:00 1.073.741.824 5214493.364
25/04/2016 09:00 1.073.741.824 5214493.365
25/04/2016 09:00 1.073.741.824 5214493.366
25/04/2016 09:00 1.073.741.824 5214493.367
25/04/2016 09:00 1.073.741.824 5214493.368
25/04/2016 09:00 1.073.741.824 5214493.369
25/04/2016 09:00 1.073.741.824 5214493.37
25/04/2016 09:00 1.073.741.824 5214493.370
25/04/2016 09:00 1.073.741.824 5214493.371
25/04/2016 09:00 1.073.741.824 5214493.372
25/04/2016 09:00 1.073.741.824 5214493.373
25/04/2016 09:00 1.073.741.824 5214493.374
25/04/2016 09:00 1.073.741.824 5214493.375
25/04/2016 09:00 1.073.741.824 5214493.376
25/04/2016 09:00 1.073.741.824 5214493.377
25/04/2016 09:00 1.073.741.824 5214493.378
25/04/2016 09:00 1.073.741.824 5214493.379
25/04/2016 09:00 1.073.741.824 5214493.38
25/04/2016 09:00 1.073.741.824 5214493.380
25/04/2016 09:00 1.073.741.824 5214493.381
25/04/2016 09:00 1.073.741.824 5214493.382
25/04/2016 09:00 1.073.741.824 5214493.383
25/04/2016 09:00 1.073.741.824 5214493.384
25/04/2016 09:00 1.073.741.824 5214493.385
25/04/2016 09:00 1.073.741.824 5214493.386
25/04/2016 09:00 1.073.741.824 5214493.387
25/04/2016 09:00 1.073.741.824 5214493.388
25/04/2016 09:00 1.073.741.824 5214493.389
25/04/2016 09:00 1.073.741.824 5214493.39
25/04/2016 09:00 1.073.741.824 5214493.390
25/04/2016 09:00 1.073.741.824 5214493.391
25/04/2016 09:00 1.073.741.824 5214493.392
25/04/2016 09:00 1.073.741.824 5214493.393
25/04/2016 09:00 1.073.741.824 5214493.394
25/04/2016 09:00 1.073.741.824 5214493.395
25/04/2016 09:00 1.073.741.824 5214493.396
25/04/2016 09:00 1.073.741.824 5214493.397
25/04/2016 09:00 1.073.741.824 5214493.398
25/04/2016 09:00 1.073.741.824 5214493.399
25/04/2016 09:00 1.073.741.824 5214493.4
25/04/2016 09:00 1.073.741.824 5214493.40
25/04/2016 09:00 1.073.741.824 5214493.400
25/04/2016 09:00 1.073.741.824 5214493.401
25/04/2016 09:00 1.073.741.824 5214493.402
25/04/2016 09:00 1.073.741.824 5214493.403
25/04/2016 09:00 1.073.741.824 5214493.404
25/04/2016 09:00 1.073.741.824 5214493.405
25/04/2016 09:00 1.073.741.824 5214493.406
25/04/2016 09:00 1.073.741.824 5214493.407
25/04/2016 09:00 1.073.741.824 5214493.408
19/05/2016 23:21 851.738.624 5214493.409
25/04/2016 09:00 1.073.741.824 5214493.41
25/04/2016 09:00 1.073.741.824 5214493.42
25/04/2016 09:00 1.073.741.824 5214493.43
25/04/2016 09:00 1.073.741.824 5214493.44
25/04/2016 09:00 1.073.741.824 5214493.45
25/04/2016 09:00 1.073.741.824 5214493.46
25/04/2016 09:00 1.073.741.824 5214493.47
25/04/2016 09:00 1.073.741.824 5214493.48
25/04/2016 09:00 1.073.741.824 5214493.49
25/04/2016 09:00 1.073.741.824 5214493.5
25/04/2016 09:00 1.073.741.824 5214493.50
25/04/2016 09:00 1.073.741.824 5214493.51
25/04/2016 09:00 1.073.741.824 5214493.52
25/04/2016 09:00 1.073.741.824 5214493.53
25/04/2016 09:00 1.073.741.824 5214493.54
25/04/2016 09:00 1.073.741.824 5214493.55
25/04/2016 09:00 1.073.741.824 5214493.56
25/04/2016 09:00 1.073.741.824 5214493.57
25/04/2016 09:00 1.073.741.824 5214493.58
25/04/2016 09:00 1.073.741.824 5214493.59
25/04/2016 09:00 1.073.741.824 5214493.6
25/04/2016 09:00 1.073.741.824 5214493.60
25/04/2016 09:00 1.073.741.824 5214493.61
25/04/2016 09:00 1.073.741.824 5214493.62
25/04/2016 09:00 1.073.741.824 5214493.63
25/04/2016 09:00 1.073.741.824 5214493.64
25/04/2016 09:00 1.073.741.824 5214493.65
25/04/2016 09:00 1.073.741.824 5214493.66
25/04/2016 09:00 1.073.741.824 5214493.67
25/04/2016 09:00 1.073.741.824 5214493.68
25/04/2016 09:00 1.073.741.824 5214493.69
25/04/2016 09:00 1.073.741.824 5214493.7
25/04/2016 09:00 1.073.741.824 5214493.70
25/04/2016 09:00 1.073.741.824 5214493.71
25/04/2016 09:00 1.073.741.824 5214493.72
25/04/2016 09:00 1.073.741.824 5214493.73
25/04/2016 09:00 1.073.741.824 5214493.74
25/04/2016 09:00 1.073.741.824 5214493.75
25/04/2016 09:00 1.073.741.824 5214493.76
25/04/2016 09:00 1.073.741.824 5214493.77
25/04/2016 09:00 1.073.741.824 5214493.78
25/04/2016 09:00 1.073.741.824 5214493.79
25/04/2016 09:00 1.073.741.824 5214493.8
25/04/2016 09:00 1.073.741.824 5214493.80
25/04/2016 09:00 1.073.741.824 5214493.81
25/04/2016 09:00 1.073.741.824 5214493.82
25/04/2016 09:00 1.073.741.824 5214493.83
25/04/2016 09:00 1.073.741.824 5214493.84
25/04/2016 09:00 1.073.741.824 5214493.85
25/04/2016 09:00 1.073.741.824 5214493.86
25/04/2016 09:00 1.073.741.824 5214493.87
25/04/2016 09:00 1.073.741.824 5214493.88
25/04/2016 09:00 1.073.741.824 5214493.89
25/04/2016 09:00 1.073.741.824 5214493.9
25/04/2016 09:00 1.073.741.824 5214493.90
25/04/2016 09:00 1.073.741.824 5214493.91
25/04/2016 09:00 1.073.741.824 5214493.92
25/04/2016 09:00 1.073.741.824 5214493.93
25/04/2016 09:00 1.073.741.824 5214493.94
25/04/2016 09:00 1.073.741.824 5214493.95
25/04/2016 09:00 1.073.741.824 5214493.96
25/04/2016 09:00 1.073.741.824 5214493.97
25/04/2016 09:00 1.073.741.824 5214493.98
25/04/2016 09:00 1.073.741.824 5214493.99
20/05/2016 09:15 108.183.552 5214493_fsm
25/04/2016 09:00 1.073.741.824 5214495
25/04/2016 09:00 1.073.741.824 5214495.1
25/04/2016 09:00 1.073.741.824 5214495.2
25/04/2016 09:00 1.073.741.824 5214495.3
20/05/2016 09:15 535.183.360 5214495.4
422 File(s) 445.600.333.824 bytes
2 Dir(s) 198.487.891.968 bytes free

2017-06-06 16:37 GMT-03:00 Adrian Klaver <adrian.klaver@aklaver.com>:

On 06/06/2017 02:07 PM, tel medola wrote:

rai=# 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
---------+------------------+--------------+---------+-----------+----------+-------+-------------+---------------+----------+-----------+---------------+---------------+---------------+-------------+-------------+----------------+---------+----------+-----------+------------+------------+-------------+----------------+----------------+----------------+--------------+------------+--------+------------
5214493 | pg_toast_5214489 | 99 | 5214494 | 0 |
10 | 0 | 13741353 | 5205910 | 0 | 0 |
0 | 0 | 5214495 | t | f |
p | t | 3 | 0 | f | t
| f | f | f | t |
9360288 | 1 | |
(1 registro)

Change the relfilenode in above from 13741353 to 5214493

If I do the select below (which is toast it returns me in error):
Select oid, * from pg_class where relname = 'pg_toast_9277966'
He will return me:

Not sure here. I would try:

select * from pg_classs where reltoastrelid = 9277970;

to see what table is claiming it.

I do not know if it helps, but the folder structure looks like this:

The file names = the relfilenode + additional info

5214489 is your repositorio table
5214489_fsm is the Free Space Map for that table.

5214493 and 5214493.x is your TOAST table broken down into 1 GB chunks.

What is not clear is what 5214495 is?

select * from pg_class where relfilenode = 5214495;

might help, unless it was also TRUNCATEd. In that case it depends on you
knowing what other table then repositorio you had in the tablespace.

Volume in drive G is Gravacoes-III
Volume Serial Number is 8CF9-EDFA

Directory of g:\PG_9.3_201306121\32768

06/06/2017 13:18 <DIR> .
06/06/2017 13:18 <DIR> ..
23/05/2017 08:25 0 13741352
23/05/2017 08:25 0 13741353
06/06/2017 12:04 8.192 13789591
20/05/2016 09:10 649.650.176 5214489
20/05/2016 09:10 180.224 5214489_fsm
19/05/2016 23:47 16.384 5214489_vm
25/04/2016 09:00 1.073.741.824 5214493
25/04/2016 09:00 1.073.741.824 5214493.1
25/04/2016 09:00 1.073.741.824 5214493.10
25/04/2016 09:00 1.073.741.824 5214493.100
25/04/2016 09:00 1.073.741.824 5214493.101
25/04/2016 09:00 1.073.741.824 5214493.102
25/04/2016 09:00 1.073.741.824 5214493.103
25/04/2016 09:00 1.073.741.824 5214493.104
25/04/2016 09:00 1.073.741.824 5214493.105
25/04/2016 09:00 1.073.741.824 5214493.106
25/04/2016 09:00 1.073.741.824 5214493.107
25/04/2016 09:00 1.073.741.824 5214493.108
25/04/2016 09:00 1.073.741.824 5214493.109
25/04/2016 09:00 1.073.741.824 5214493.11
25/04/2016 09:00 1.073.741.824 5214493.110
25/04/2016 09:00 1.073.741.824 5214493.111
25/04/2016 09:00 1.073.741.824 5214493.112
25/04/2016 09:00 1.073.741.824 5214493.113
25/04/2016 09:00 1.073.741.824 5214493.114
25/04/2016 09:00 1.073.741.824 5214493.115
25/04/2016 09:00 1.073.741.824 5214493.116
25/04/2016 09:00 1.073.741.824 5214493.117
25/04/2016 09:00 1.073.741.824 5214493.118
25/04/2016 09:00 1.073.741.824 5214493.119
25/04/2016 09:00 1.073.741.824 5214493.12
25/04/2016 09:00 1.073.741.824 5214493.120
25/04/2016 09:00 1.073.741.824 5214493.121
25/04/2016 09:00 1.073.741.824 5214493.122
25/04/2016 09:00 1.073.741.824 5214493.123
25/04/2016 09:00 1.073.741.824 5214493.124
25/04/2016 09:00 1.073.741.824 5214493.125
25/04/2016 09:00 1.073.741.824 5214493.126
25/04/2016 09:00 1.073.741.824 5214493.127
25/04/2016 09:00 1.073.741.824 5214493.128
25/04/2016 09:00 1.073.741.824 5214493.129
25/04/2016 09:00 1.073.741.824 5214493.13
25/04/2016 09:00 1.073.741.824 5214493.130
25/04/2016 09:00 1.073.741.824 5214493.131
25/04/2016 09:00 1.073.741.824 5214493.132
25/04/2016 09:00 1.073.741.824 5214493.133
25/04/2016 09:00 1.073.741.824 5214493.134
25/04/2016 09:00 1.073.741.824 5214493.135
25/04/2016 09:00 1.073.741.824 5214493.136
25/04/2016 09:00 1.073.741.824 5214493.137
25/04/2016 09:00 1.073.741.824 5214493.138
25/04/2016 09:00 1.073.741.824 5214493.139
25/04/2016 09:00 1.073.741.824 5214493.14
25/04/2016 09:00 1.073.741.824 5214493.140
25/04/2016 09:00 1.073.741.824 5214493.141
25/04/2016 09:00 1.073.741.824 5214493.142
25/04/2016 09:00 1.073.741.824 5214493.143
25/04/2016 09:00 1.073.741.824 5214493.144
25/04/2016 09:00 1.073.741.824 5214493.145
25/04/2016 09:00 1.073.741.824 5214493.146
25/04/2016 09:00 1.073.741.824 5214493.147
25/04/2016 09:00 1.073.741.824 5214493.148
25/04/2016 09:00 1.073.741.824 5214493.149
25/04/2016 09:00 1.073.741.824 5214493.15
25/04/2016 09:00 1.073.741.824 5214493.150
25/04/2016 09:00 1.073.741.824 5214493.151
25/04/2016 09:00 1.073.741.824 5214493.152
25/04/2016 09:00 1.073.741.824 5214493.153
25/04/2016 09:00 1.073.741.824 5214493.154
25/04/2016 09:00 1.073.741.824 5214493.155
25/04/2016 09:00 1.073.741.824 5214493.156
25/04/2016 09:00 1.073.741.824 5214493.157
25/04/2016 09:00 1.073.741.824 5214493.158
25/04/2016 09:00 1.073.741.824 5214493.159
25/04/2016 09:00 1.073.741.824 5214493.16
25/04/2016 09:00 1.073.741.824 5214493.160
25/04/2016 09:00 1.073.741.824 5214493.161
25/04/2016 09:00 1.073.741.824 5214493.162
25/04/2016 09:00 1.073.741.824 5214493.163
25/04/2016 09:00 1.073.741.824 5214493.164
25/04/2016 09:00 1.073.741.824 5214493.165
25/04/2016 09:00 1.073.741.824 5214493.166
25/04/2016 09:00 1.073.741.824 5214493.167
25/04/2016 09:00 1.073.741.824 5214493.168
25/04/2016 09:00 1.073.741.824 5214493.169
25/04/2016 09:00 1.073.741.824 5214493.17
25/04/2016 09:00 1.073.741.824 5214493.170
25/04/2016 09:00 1.073.741.824 5214493.171
25/04/2016 09:00 1.073.741.824 5214493.172
25/04/2016 09:00 1.073.741.824 5214493.173
25/04/2016 09:00 1.073.741.824 5214493.174
25/04/2016 09:00 1.073.741.824 5214493.175
25/04/2016 09:00 1.073.741.824 5214493.176
25/04/2016 09:00 1.073.741.824 5214493.177
25/04/2016 09:00 1.073.741.824 5214493.178
25/04/2016 09:00 1.073.741.824 5214493.179
25/04/2016 09:00 1.073.741.824 5214493.18
25/04/2016 09:00 1.073.741.824 5214493.180
25/04/2016 09:00 1.073.741.824 5214493.181
25/04/2016 09:00 1.073.741.824 5214493.182
25/04/2016 09:00 1.073.741.824 5214493.183
25/04/2016 09:00 1.073.741.824 5214493.184
25/04/2016 09:00 1.073.741.824 5214493.185
25/04/2016 09:00 1.073.741.824 5214493.186
25/04/2016 09:00 1.073.741.824 5214493.187
25/04/2016 09:00 1.073.741.824 5214493.188
25/04/2016 09:00 1.073.741.824 5214493.189
25/04/2016 09:00 1.073.741.824 5214493.19
25/04/2016 09:00 1.073.741.824 5214493.190
25/04/2016 09:00 1.073.741.824 5214493.191
25/04/2016 09:00 1.073.741.824 5214493.192
25/04/2016 09:00 1.073.741.824 5214493.193
25/04/2016 09:00 1.073.741.824 5214493.194
25/04/2016 09:00 1.073.741.824 5214493.195
25/04/2016 09:00 1.073.741.824 5214493.196
25/04/2016 09:00 1.073.741.824 5214493.197
25/04/2016 09:00 1.073.741.824 5214493.198
25/04/2016 09:00 1.073.741.824 5214493.199
25/04/2016 09:00 1.073.741.824 5214493.2
25/04/2016 09:00 1.073.741.824 5214493.20
25/04/2016 09:00 1.073.741.824 5214493.200
25/04/2016 09:00 1.073.741.824 5214493.201
25/04/2016 09:00 1.073.741.824 5214493.202
25/04/2016 09:00 1.073.741.824 5214493.203
25/04/2016 09:00 1.073.741.824 5214493.204
25/04/2016 09:00 1.073.741.824 5214493.205
25/04/2016 09:00 1.073.741.824 5214493.206
25/04/2016 09:00 1.073.741.824 5214493.207
25/04/2016 09:00 1.073.741.824 5214493.208
25/04/2016 09:00 1.073.741.824 5214493.209
25/04/2016 09:00 1.073.741.824 5214493.21
25/04/2016 09:00 1.073.741.824 5214493.210
25/04/2016 09:00 1.073.741.824 5214493.211
25/04/2016 09:00 1.073.741.824 5214493.212
25/04/2016 09:00 1.073.741.824 5214493.213
25/04/2016 09:00 1.073.741.824 5214493.214
25/04/2016 09:00 1.073.741.824 5214493.215
25/04/2016 09:00 1.073.741.824 5214493.216
25/04/2016 09:00 1.073.741.824 5214493.217
25/04/2016 09:00 1.073.741.824 5214493.218
25/04/2016 09:00 1.073.741.824 5214493.219
25/04/2016 09:00 1.073.741.824 5214493.22
25/04/2016 09:00 1.073.741.824 5214493.220
25/04/2016 09:00 1.073.741.824 5214493.221
25/04/2016 09:00 1.073.741.824 5214493.222
25/04/2016 09:00 1.073.741.824 5214493.223
25/04/2016 09:00 1.073.741.824 5214493.224
25/04/2016 09:00 1.073.741.824 5214493.225
25/04/2016 09:00 1.073.741.824 5214493.226
25/04/2016 09:00 1.073.741.824 5214493.227
25/04/2016 09:00 1.073.741.824 5214493.228
25/04/2016 09:00 1.073.741.824 5214493.229
25/04/2016 09:00 1.073.741.824 5214493.23
25/04/2016 09:00 1.073.741.824 5214493.230
25/04/2016 09:00 1.073.741.824 5214493.231
25/04/2016 09:00 1.073.741.824 5214493.232
25/04/2016 09:00 1.073.741.824 5214493.233
25/04/2016 09:00 1.073.741.824 5214493.234
25/04/2016 09:00 1.073.741.824 5214493.235
25/04/2016 09:00 1.073.741.824 5214493.236
25/04/2016 09:00 1.073.741.824 5214493.237
25/04/2016 09:00 1.073.741.824 5214493.238
25/04/2016 09:00 1.073.741.824 5214493.239
25/04/2016 09:00 1.073.741.824 5214493.24
25/04/2016 09:00 1.073.741.824 5214493.240
25/04/2016 09:00 1.073.741.824 5214493.241
25/04/2016 09:00 1.073.741.824 5214493.242
25/04/2016 09:00 1.073.741.824 5214493.243
25/04/2016 09:00 1.073.741.824 5214493.244
25/04/2016 09:00 1.073.741.824 5214493.245
25/04/2016 09:00 1.073.741.824 5214493.246
25/04/2016 09:00 1.073.741.824 5214493.247
25/04/2016 09:00 1.073.741.824 5214493.248
25/04/2016 09:00 1.073.741.824 5214493.249
25/04/2016 09:00 1.073.741.824 5214493.25
25/04/2016 09:00 1.073.741.824 5214493.250
25/04/2016 09:00 1.073.741.824 5214493.251
25/04/2016 09:00 1.073.741.824 5214493.252
25/04/2016 09:00 1.073.741.824 5214493.253
25/04/2016 09:00 1.073.741.824 5214493.254
25/04/2016 09:00 1.073.741.824 5214493.255
25/04/2016 09:00 1.073.741.824 5214493.256
25/04/2016 09:00 1.073.741.824 5214493.257
25/04/2016 09:00 1.073.741.824 5214493.258
25/04/2016 09:00 1.073.741.824 5214493.259
25/04/2016 09:00 1.073.741.824 5214493.26
25/04/2016 09:00 1.073.741.824 5214493.260
25/04/2016 09:00 1.073.741.824 5214493.261
25/04/2016 09:00 1.073.741.824 5214493.262
25/04/2016 09:00 1.073.741.824 5214493.263
25/04/2016 09:00 1.073.741.824 5214493.264
25/04/2016 09:00 1.073.741.824 5214493.265
25/04/2016 09:00 1.073.741.824 5214493.266
25/04/2016 09:00 1.073.741.824 5214493.267
25/04/2016 09:00 1.073.741.824 5214493.268
25/04/2016 09:00 1.073.741.824 5214493.269
25/04/2016 09:00 1.073.741.824 5214493.27
25/04/2016 09:00 1.073.741.824 5214493.270
25/04/2016 09:00 1.073.741.824 5214493.271
25/04/2016 09:00 1.073.741.824 5214493.272
25/04/2016 09:00 1.073.741.824 5214493.273
25/04/2016 09:00 1.073.741.824 5214493.274
25/04/2016 09:00 1.073.741.824 5214493.275
25/04/2016 09:00 1.073.741.824 5214493.276
25/04/2016 09:00 1.073.741.824 5214493.277
25/04/2016 09:00 1.073.741.824 5214493.278
25/04/2016 09:00 1.073.741.824 5214493.279
25/04/2016 09:00 1.073.741.824 5214493.28
25/04/2016 09:00 1.073.741.824 5214493.280
25/04/2016 09:00 1.073.741.824 5214493.281
25/04/2016 09:00 1.073.741.824 5214493.282
25/04/2016 09:00 1.073.741.824 5214493.283
25/04/2016 09:00 1.073.741.824 5214493.284
25/04/2016 09:00 1.073.741.824 5214493.285
25/04/2016 09:00 1.073.741.824 5214493.286
25/04/2016 09:00 1.073.741.824 5214493.287
25/04/2016 09:00 1.073.741.824 5214493.288
25/04/2016 09:00 1.073.741.824 5214493.289
25/04/2016 09:00 1.073.741.824 5214493.29
25/04/2016 09:00 1.073.741.824 5214493.290
25/04/2016 09:00 1.073.741.824 5214493.291
25/04/2016 09:00 1.073.741.824 5214493.292
25/04/2016 09:00 1.073.741.824 5214493.293
25/04/2016 09:00 1.073.741.824 5214493.294
25/04/2016 09:00 1.073.741.824 5214493.295
25/04/2016 09:00 1.073.741.824 5214493.296
25/04/2016 09:00 1.073.741.824 5214493.297
25/04/2016 09:00 1.073.741.824 5214493.298
25/04/2016 09:00 1.073.741.824 5214493.299
25/04/2016 09:00 1.073.741.824 5214493.3
25/04/2016 09:00 1.073.741.824 5214493.30
25/04/2016 09:00 1.073.741.824 5214493.300
25/04/2016 09:00 1.073.741.824 5214493.301
25/04/2016 09:00 1.073.741.824 5214493.302
25/04/2016 09:00 1.073.741.824 5214493.303
25/04/2016 09:00 1.073.741.824 5214493.304
25/04/2016 09:00 1.073.741.824 5214493.305
25/04/2016 09:00 1.073.741.824 5214493.306
25/04/2016 09:00 1.073.741.824 5214493.307
25/04/2016 09:00 1.073.741.824 5214493.308
25/04/2016 09:00 1.073.741.824 5214493.309
25/04/2016 09:00 1.073.741.824 5214493.31
25/04/2016 09:00 1.073.741.824 5214493.310
25/04/2016 09:00 1.073.741.824 5214493.311
25/04/2016 09:00 1.073.741.824 5214493.312
25/04/2016 09:00 1.073.741.824 5214493.313
25/04/2016 09:00 1.073.741.824 5214493.314
25/04/2016 09:00 1.073.741.824 5214493.315
25/04/2016 09:00 1.073.741.824 5214493.316
25/04/2016 09:00 1.073.741.824 5214493.317
25/04/2016 09:00 1.073.741.824 5214493.318
25/04/2016 09:00 1.073.741.824 5214493.319
25/04/2016 09:00 1.073.741.824 5214493.32
25/04/2016 09:00 1.073.741.824 5214493.320
25/04/2016 09:00 1.073.741.824 5214493.321
25/04/2016 09:00 1.073.741.824 5214493.322
25/04/2016 09:00 1.073.741.824 5214493.323
25/04/2016 09:00 1.073.741.824 5214493.324
25/04/2016 09:00 1.073.741.824 5214493.325
25/04/2016 09:00 1.073.741.824 5214493.326
25/04/2016 09:00 1.073.741.824 5214493.327
25/04/2016 09:00 1.073.741.824 5214493.328
25/04/2016 09:00 1.073.741.824 5214493.329
25/04/2016 09:00 1.073.741.824 5214493.33
25/04/2016 09:00 1.073.741.824 5214493.330
25/04/2016 09:00 1.073.741.824 5214493.331
25/04/2016 09:00 1.073.741.824 5214493.332
25/04/2016 09:00 1.073.741.824 5214493.333
25/04/2016 09:00 1.073.741.824 5214493.334
25/04/2016 09:00 1.073.741.824 5214493.335
25/04/2016 09:00 1.073.741.824 5214493.336
25/04/2016 09:00 1.073.741.824 5214493.337
25/04/2016 09:00 1.073.741.824 5214493.338
25/04/2016 09:00 1.073.741.824 5214493.339
25/04/2016 09:00 1.073.741.824 5214493.34
25/04/2016 09:00 1.073.741.824 5214493.340
25/04/2016 09:00 1.073.741.824 5214493.341
25/04/2016 09:00 1.073.741.824 5214493.342
25/04/2016 09:00 1.073.741.824 5214493.343
25/04/2016 09:00 1.073.741.824 5214493.344
25/04/2016 09:00 1.073.741.824 5214493.345
25/04/2016 09:00 1.073.741.824 5214493.346
25/04/2016 09:00 1.073.741.824 5214493.347
25/04/2016 09:00 1.073.741.824 5214493.348
25/04/2016 09:00 1.073.741.824 5214493.349
25/04/2016 09:00 1.073.741.824 5214493.35
25/04/2016 09:00 1.073.741.824 5214493.350
25/04/2016 09:00 1.073.741.824 5214493.351
25/04/2016 09:00 1.073.741.824 5214493.352
25/04/2016 09:00 1.073.741.824 5214493.353
25/04/2016 09:00 1.073.741.824 5214493.354
25/04/2016 09:00 1.073.741.824 5214493.355
25/04/2016 09:00 1.073.741.824 5214493.356
25/04/2016 09:00 1.073.741.824 5214493.357
25/04/2016 09:00 1.073.741.824 5214493.358
25/04/2016 09:00 1.073.741.824 5214493.359
25/04/2016 09:00 1.073.741.824 5214493.36
25/04/2016 09:00 1.073.741.824 5214493.360
25/04/2016 09:00 1.073.741.824 5214493.361
25/04/2016 09:00 1.073.741.824 5214493.362
25/04/2016 09:00 1.073.741.824 5214493.363
25/04/2016 09:00 1.073.741.824 5214493.364
25/04/2016 09:00 1.073.741.824 5214493.365
25/04/2016 09:00 1.073.741.824 5214493.366
25/04/2016 09:00 1.073.741.824 5214493.367
25/04/2016 09:00 1.073.741.824 5214493.368
25/04/2016 09:00 1.073.741.824 5214493.369
25/04/2016 09:00 1.073.741.824 5214493.37
25/04/2016 09:00 1.073.741.824 5214493.370
25/04/2016 09:00 1.073.741.824 5214493.371
25/04/2016 09:00 1.073.741.824 5214493.372
25/04/2016 09:00 1.073.741.824 5214493.373
25/04/2016 09:00 1.073.741.824 5214493.374
25/04/2016 09:00 1.073.741.824 5214493.375
25/04/2016 09:00 1.073.741.824 5214493.376
25/04/2016 09:00 1.073.741.824 5214493.377
25/04/2016 09:00 1.073.741.824 5214493.378
25/04/2016 09:00 1.073.741.824 5214493.379
25/04/2016 09:00 1.073.741.824 5214493.38
25/04/2016 09:00 1.073.741.824 5214493.380
25/04/2016 09:00 1.073.741.824 5214493.381
25/04/2016 09:00 1.073.741.824 5214493.382
25/04/2016 09:00 1.073.741.824 5214493.383
25/04/2016 09:00 1.073.741.824 5214493.384
25/04/2016 09:00 1.073.741.824 5214493.385
25/04/2016 09:00 1.073.741.824 5214493.386
25/04/2016 09:00 1.073.741.824 5214493.387
25/04/2016 09:00 1.073.741.824 5214493.388
25/04/2016 09:00 1.073.741.824 5214493.389
25/04/2016 09:00 1.073.741.824 5214493.39
25/04/2016 09:00 1.073.741.824 5214493.390
25/04/2016 09:00 1.073.741.824 5214493.391
25/04/2016 09:00 1.073.741.824 5214493.392
25/04/2016 09:00 1.073.741.824 5214493.393
25/04/2016 09:00 1.073.741.824 5214493.394
25/04/2016 09:00 1.073.741.824 5214493.395
25/04/2016 09:00 1.073.741.824 5214493.396
25/04/2016 09:00 1.073.741.824 5214493.397
25/04/2016 09:00 1.073.741.824 5214493.398
25/04/2016 09:00 1.073.741.824 5214493.399
25/04/2016 09:00 1.073.741.824 5214493.4
25/04/2016 09:00 1.073.741.824 5214493.40
25/04/2016 09:00 1.073.741.824 5214493.400
25/04/2016 09:00 1.073.741.824 5214493.401
25/04/2016 09:00 1.073.741.824 5214493.402
25/04/2016 09:00 1.073.741.824 5214493.403
25/04/2016 09:00 1.073.741.824 5214493.404
25/04/2016 09:00 1.073.741.824 5214493.405
25/04/2016 09:00 1.073.741.824 5214493.406
25/04/2016 09:00 1.073.741.824 5214493.407
25/04/2016 09:00 1.073.741.824 5214493.408
19/05/2016 23:21 851.738.624 5214493.409
25/04/2016 09:00 1.073.741.824 5214493.41
25/04/2016 09:00 1.073.741.824 5214493.42
25/04/2016 09:00 1.073.741.824 5214493.43
25/04/2016 09:00 1.073.741.824 5214493.44
25/04/2016 09:00 1.073.741.824 5214493.45
25/04/2016 09:00 1.073.741.824 5214493.46
25/04/2016 09:00 1.073.741.824 5214493.47
25/04/2016 09:00 1.073.741.824 5214493.48
25/04/2016 09:00 1.073.741.824 5214493.49
25/04/2016 09:00 1.073.741.824 5214493.5
25/04/2016 09:00 1.073.741.824 5214493.50
25/04/2016 09:00 1.073.741.824 5214493.51
25/04/2016 09:00 1.073.741.824 5214493.52
25/04/2016 09:00 1.073.741.824 5214493.53
25/04/2016 09:00 1.073.741.824 5214493.54
25/04/2016 09:00 1.073.741.824 5214493.55
25/04/2016 09:00 1.073.741.824 5214493.56
25/04/2016 09:00 1.073.741.824 5214493.57
25/04/2016 09:00 1.073.741.824 5214493.58
25/04/2016 09:00 1.073.741.824 5214493.59
25/04/2016 09:00 1.073.741.824 5214493.6
25/04/2016 09:00 1.073.741.824 5214493.60
25/04/2016 09:00 1.073.741.824 5214493.61
25/04/2016 09:00 1.073.741.824 5214493.62
25/04/2016 09:00 1.073.741.824 5214493.63
25/04/2016 09:00 1.073.741.824 5214493.64
25/04/2016 09:00 1.073.741.824 5214493.65
25/04/2016 09:00 1.073.741.824 5214493.66
25/04/2016 09:00 1.073.741.824 5214493.67
25/04/2016 09:00 1.073.741.824 5214493.68
25/04/2016 09:00 1.073.741.824 5214493.69
25/04/2016 09:00 1.073.741.824 5214493.7
25/04/2016 09:00 1.073.741.824 5214493.70
25/04/2016 09:00 1.073.741.824 5214493.71
25/04/2016 09:00 1.073.741.824 5214493.72
25/04/2016 09:00 1.073.741.824 5214493.73
25/04/2016 09:00 1.073.741.824 5214493.74
25/04/2016 09:00 1.073.741.824 5214493.75
25/04/2016 09:00 1.073.741.824 5214493.76
25/04/2016 09:00 1.073.741.824 5214493.77
25/04/2016 09:00 1.073.741.824 5214493.78
25/04/2016 09:00 1.073.741.824 5214493.79
25/04/2016 09:00 1.073.741.824 5214493.8
25/04/2016 09:00 1.073.741.824 5214493.80
25/04/2016 09:00 1.073.741.824 5214493.81
25/04/2016 09:00 1.073.741.824 5214493.82
25/04/2016 09:00 1.073.741.824 5214493.83
25/04/2016 09:00 1.073.741.824 5214493.84
25/04/2016 09:00 1.073.741.824 5214493.85
25/04/2016 09:00 1.073.741.824 5214493.86
25/04/2016 09:00 1.073.741.824 5214493.87
25/04/2016 09:00 1.073.741.824 5214493.88
25/04/2016 09:00 1.073.741.824 5214493.89
25/04/2016 09:00 1.073.741.824 5214493.9
25/04/2016 09:00 1.073.741.824 5214493.90
25/04/2016 09:00 1.073.741.824 5214493.91
25/04/2016 09:00 1.073.741.824 5214493.92
25/04/2016 09:00 1.073.741.824 5214493.93
25/04/2016 09:00 1.073.741.824 5214493.94
25/04/2016 09:00 1.073.741.824 5214493.95
25/04/2016 09:00 1.073.741.824 5214493.96
25/04/2016 09:00 1.073.741.824 5214493.97
25/04/2016 09:00 1.073.741.824 5214493.98
25/04/2016 09:00 1.073.741.824 5214493.99
20/05/2016 09:15 108.183.552 5214493_fsm
25/04/2016 09:00 1.073.741.824 5214495
25/04/2016 09:00 1.073.741.824 5214495.1
25/04/2016 09:00 1.073.741.824 5214495.2
25/04/2016 09:00 1.073.741.824 5214495.3
20/05/2016 09:15 535.183.360 5214495.4
422 File(s) 445.600.333.824 bytes
2 Dir(s) 198.487.891.968 bytes free

2017-06-06 16:37 GMT-03:00 Adrian Klaver <adrian.klaver@aklaver.com
<mailto:adrian.klaver@aklaver.com>>:

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
<https://www.postgresql.org/docs/9.6/static/storage-toast.html&gt;

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
<https://www.postgresql.org/docs/9.6/static/catalog-pg-class.html&gt;

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>
<mailto: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>
<mailto:adrian.klaver@aklaver.com
<mailto:adrian.klaver@aklaver.com>>

--
Adrian Klaver
adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>

--
Adrian Klaver
adrian.klaver@aklaver.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Change the relfilenode in above from 13741353 to 5214493
*I' no change yeat, but i will...*

select * from pg_classs where reltoastrelid = 9277970
returns:

* 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 *
*---------+-------------+--------------+---------+-----------+----------+-------+-------------+---------------+----------+--------------+---------------+---------------+---------------+-------------+-------------+----------------+---------+----------+-----------+------------+------------+-------------+----------------+----------------+----------------+--------------+------------+--------+------------*
* 9277966 | repositorio | 9277964 | 9277968 | 0 | 10 |
0 | 9277966 | 9277962 | 43779 | 1.50905e+006 | 43779
| 9277970 | 0 | t | f | p
| r | 6 | 0 | f | t | f |
f | f | t | 9360288 |
1 | | *
*(1 registro)*

What is not clear is what 5214495 is?
*Not to me either*

select * from pg_class where relfilenode = 5214495;
*returns: none records*

But I'm worried about the select error. You are returning the
table:pg_toast_9277966 not the pg_toast_5214489... bellow
ERROR: missing chunk number 0 for toast value 10259186 in pg_toast_9277966

Could it be because of the filenode link that is still pointing to another?
-> 13741353

2017-06-06 21:08 GMT-03:00 Adrian Klaver <adrian.klaver@aklaver.com>:

On 06/07/2017 07:53 AM, tel medola wrote:

Change the relfilenode in above from 13741353 to 5214493
/I' no change yeat, but i will.../

What is not clear is what 5214495 is?
/Not to me either/

select * from pg_class where relfilenode = 5214495;
/returns: none records/

But I'm worried about the select error. You are returning the
table:pg_toast_9277966 not the pg_toast_5214489... bellow
ERROR: missing chunk number 0 for toast value 10259186 in pg_toast_9277966

Could it be because of the filenode link that is still pointing to
another? -> 13741353

That is what I am betting.

--
Adrian Klaver
adrian.klaver@aklaver.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general