Thread: [GENERAL] Redo the filenode link in tablespace
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.
First of all I apologize for the size of the question. But I do not see any other way to do it.
Windows 2008 R2 - 64 bits
PostgreSQL 9.3.5, compiled by Visual C++ build 1600, 64-bit
Size of database: 2.8TB
I have several linked tables with inheritance in distinct tablespaces.
I usually use as the "main" the table that is in the c: \ drive, where it is represented by public.repositorio.
When the C: drive space is running out, I take the following steps:
CREATE TABLESPACE discoXX OWNER postgres LOCATION 'new drive';
CREATE SCHEMA "<schema>" AUTHORIZATION postgres;
CREATE TABLE "<schema>".repositorio (LIKE public.repositorio INCLUDING STORAGE INCLUDING INDEXES INCLUDING DEFAULTS INCLUDING CONSTRAINTS ) INHERITS ( public.repositorio) TABLESPACE discoXX;
COPY public.repositorio TO 'F:\data.bin' BINARY;
--where F:\data.bin is temporary file
ALTER TABLE "<schema>".repositorio NO INHERIT public.repositorio;
copy "<schema>".repositorio from 'F:\data.bin' BINARY;
After finishing the import, I check if everything is correct. I compare the two tables (public.repositorio x <schema>.repositorio). All this being done, I do the following:
truncate public.public;
ALTER TABLE "<schema>".repositorio INHERIT public.repositorio;
After that PostgreSQL is already able to find the information between the tables and the tablespaces scattered between the units, using only the select in the table repositorio.
Well. It happens that in my last operation, I ended up doing the truncate in the public.repositorio without undoing the inheritance of the other tables that were already linked.
Obviously, Postgres cleaned the information of all the units, less of the last one that I had just done, because I still had not redone the link between them.
It happens that I have the backup of the drives, but a physical backup of the drive and not a pg_dump because the base is too large and it would be impracticable to apply a backup policy in this way.
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:
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
repositorio 5205962 5214491 0 10 0 13741352 5205910 0 0 0 5214493 0 True False p r 7 0 False True False False False True 9360288 1
Now the question I need the help of friends ...
Is it possible to re-link to the item before truncate?
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).
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.
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
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 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 *reltablespacerelpagesreltuple srelallvisiblereltoastrelidrel toastidxidrelhasindexrelisshar edrelpersistencerelkindrelnatt srelchecksrelhasoidsrelhaspkey relhasrulesrelhastriggersrelha ssubclassrelispopulatedrelfroz enxidrelminmxidrelaclreloption s
repositorio520596252144910100*13741352*520591000052144930Tru eFalsepr70FalseTrueFalseFalseF alseTrue93602881
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
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
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>:
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
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>:
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>: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
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
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) 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 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
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
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>:
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.ht ml) 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>>: adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.
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 Klavercom>
--
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 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.ht ml) 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>>: adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.
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 Klavercom>
--
Adrian Klaver
adrian.klaver@aklaver.com
Attachment
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>) > 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
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/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.ht ml
<https://www.postgresql.org/docs/9.1/static/release-7-4-2.ht ml>)
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.
<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> com
<mailto:adrian.klaver@aklaver.com>>
-- Adrian Klaver
adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
--
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
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 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
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
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 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.htm l
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
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> > > 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> > > 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
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/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 5214493If 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.2017-06-06 16:37 GMT-03:00 Adrian Klaver <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.
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 freecom>>: <mailto:adrian.klaver@aklaver.
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.htm l
<https://www.postgresql.org/docs/9.6/static/storage-toast.ht ml>
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>
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> com <mailto:adrian.klaver@aklaver.
<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> com
<mailto:adrian.klaver@aklaver.com>>
-- Adrian Klaver
adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
--
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
Holy shit! (sorry)....
Thanks, thanks!!!
It worked!
My goodness!!!!
After I point to the filnode, I did a reindex on the toast and some records have already been located.
2017-06-07 17:58 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
Hello guys.
I would like to thank Adrian very much for his great help and patience.
Without your help, most likely I would be looking for another job now, thank you very much !!!
Thanks to the database being Postgres and the community being so strong and united, everything worked out in the end.
Thank you very much the people who maintains Postgres (I could even help in some, because I'm a programmer too). And
Thanks also to the people who dedicate their time to helping unknow people with problems, especially to Adrian.
Thanks
Roberto.
2017-06-07 22:05 GMT-03:00 tel medola <tel.medola@gmail.com>:
Holy shit! (sorry)....Thanks, thanks!!!It worked!My goodness!!!!After I point to the filnode, I did a reindex on the toast and some records have already been located.2017-06-07 17:58 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
On Thu, Jun 08, 2017 at 07:53:01AM -0300, tel medola wrote: > I would like to thank Adrian very much for his great help and patience. > Without your help, most likely I would be looking for another job now, > thank you very much !!! > > Thanks to the database being Postgres and the community being so strong and > united, everything worked out in the end. > Thank you very much the people who maintains Postgres (I could even help in > some, because I'm a programmer too). And > Thanks also to the people who dedicate their time to helping unknow people > with problems, especially to Adrian. Hi, I wonder whether you might muster the time to do a writeup for the benefit of the list archive -- describe what the problem was, how it came about, and how it was solved ? Thanks, Karsten -- GPG key ID E4071346 @ eu.pool.sks-keyservers.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
Sure!
It's going to be a little long, but I write with great pleasure.
2017-06-08 8:04 GMT-03:00 Karsten Hilbert <Karsten.Hilbert@gmx.net>:
On Thu, Jun 08, 2017 at 07:53:01AM -0300, tel medola wrote:
> I would like to thank Adrian very much for his great help and patience.
> Without your help, most likely I would be looking for another job now,
> thank you very much !!!
>
> Thanks to the database being Postgres and the community being so strong and
> united, everything worked out in the end.
> Thank you very much the people who maintains Postgres (I could even help in
> some, because I'm a programmer too). And
> Thanks also to the people who dedicate their time to helping unknow people
> with problems, especially to Adrian.
Hi, I wonder whether you might muster the time to do a
writeup for the benefit of the list archive -- describe what
the problem was, how it came about, and how it was solved ?
Thanks,
Karsten
--
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thu, Jun 08, 2017 at 08:11:30AM -0300, tel medola wrote: > Sure! > It's going to be a little long, That's the point :-) That way, people of the future can benefit from Adrian's excellent effort. Thanks, Karsten -- GPG key ID E4071346 @ eu.pool.sks-keyservers.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
On 06/07/2017 06:05 PM, tel medola wrote: > Holy shit! (sorry).... > > Thanks, thanks!!! > > It worked! > > My goodness!!!! > After I point to the filnode, I did a reindex on the toast and some > records have already been located. Great, glad that it worked. Just realize we have been modifying a system catalog(pg_class) directly, which is generally a dangerous thing to do. I would take a backup of the table and data via pg_dump to be on the safe side. This assumes you have the space to store it, though the backup when compressed should be a good deal smaller then the actual table size. You might also think about moving the tables to a new tablespace to get a clean tablespace directory. Again this assumes space available. -- Adrian Klaver adrian.klaver@aklaver.com