Re: [GENERAL] Redo the filenode link in tablespace

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

Re: [GENERAL] Redo the filenode link in tablespace

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

Re: [GENERAL] Redo the filenode link in tablespace

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 : > 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

Re: [GENERAL] Redo the filenode link in tablespace

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

Re: [GENERAL] Redo the filenode link in tablespace

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.

Re: [GENERAL] Redo the filenode link in tablespace

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 : > On 06/07/2017 07:53 AM, tel medola wrote: > >>

Re: [GENERAL] Redo the filenode link in tablespace

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

Re: [GENERAL] Redo the filenode link in tablespace

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 |

Re: [GENERAL] Redo the filenode link in tablespace

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

Re: [GENERAL] Redo the filenode link in tablespace

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 |

Re: [GENERAL] Redo the filenode link in tablespace

On 06/06/2017 11:09 AM, tel medola wrote: I will not be able to recover my information any more, right? That is what I am trying to figure out. The last error you got was: " Returns the error below: Missing chunk number 0 for toast value 10259186 in pg_toast_9277966 " This is related to the

Re: [GENERAL] Redo the filenode link in tablespace

I will not be able to recover my information any more, right? 2017-06-06 10:37 GMT-03:00 Adrian Klaver : > 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

Re: [GENERAL] Redo the filenode link in tablespace

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 |

Re: [GENERAL] Redo the filenode link in tablespace

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 |

Re: [GENERAL] Redo the filenode link in tablespace

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

Re: [GENERAL] Redo the filenode link in tablespace

Hi, attachment. select: select * from pg_class where relfilenode = 5214489 Thanks 2017-06-05 16:02 GMT-03:00 Adrian Klaver : > On 06/05/2017 11:55 AM, tel medola wrote: > >> show? >> /Yes/ >> > > Yes, what? > > Please run the command as shown: > > select * from

Re: [GENERAL] Redo the filenode link in tablespace

I will send as soon as possible. He's running the vacuum yet. 2017-06-05 16:02 GMT-03:00 Adrian Klaver : > 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

Re: [GENERAL] Redo the filenode link in tablespace

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

Re: [GENERAL] Redo the filenode link in tablespace

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

Re: [GENERAL] Redo the filenode link in tablespace

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...

Re: [GENERAL] Redo the filenode link in tablespace

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

Re: [GENERAL] Redo the filenode link in tablespace

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 : > On 06/01/2017 03:47 AM, tel medola wrote: > >> Did you get any help with this? >>

Re: [GENERAL] Redo the filenode link in tablespace

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

Re: [GENERAL] Redo the filenode link in tablespace

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

Re: [GENERAL] Redo the filenode link in tablespace

On 05/31/2017 06:05 AM, tel medola wrote: Hi. I have a rather serious problem in my database. I'll try to summarize what happened and how far I've gotten with the help of friends from the pgsql-sql list. When I returned the copy of the drives, the records were no longer found. For