[HACKERS] Format of raw files
Good morning to all. First I apologize for my English. After a HD crash I have recovered a portion of the data in binary files of postgres, carving it from the HD. But I do not know the format of these files, and find difficult to translate it and / or import. Many thanks for your attention, and for your help. Rosario Borda -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] Format of raw files
On Fri, Feb 24, 2012 at 7:47 AM, Rosario Borda rosarioenzoluca.bo...@gmail.com wrote: Good morning to all. First I apologize for my English. After a HD crash I have recovered a portion of the data in binary files of postgres, carving it from the HD. But I do not know the format of these files, and find difficult to translate it and / or import. Many thanks for your attention, and for your help. You might be able to get something out of it using the pg_filedump utility. http://sources.redhat.com/rhdb/utilities.html It is uncertain whether there is a version compatible with your crashed database, though. It's worth noting that dead tuples are also included in the binary files (a tuple becomes dead when it is deleted using DELETE, or when a replacement is created using UPDATE), and if you do not have all the control files, you may have no way to determine which tuples are live and which are dead. It is usually a much better idea to go after a backup of the database. If you haven't got one, you're sadly left with a mighty painful task. -- When confronted by a difficult problem, solve it by reducing it to the question, How would the Lone Ranger handle this? -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] Format of raw files
Excerpts from Rosario Borda's message of vie feb 24 09:47:01 -0300 2012: Good morning to all. First I apologize for my English. After a HD crash I have recovered a portion of the data in binary files of postgres, carving it from the HD. But I do not know the format of these files, and find difficult to translate it and / or import. Many thanks for your attention, and for your help. These may be useful: http://www.commandprompt.com/blogs/alvaro_herrera/2012/02/another_day_another_recovery/ http://www.commandprompt.com/blogs/alvaro_herrera/2011/03/recovering_a_lost-and-found_database/ -- Álvaro Herrera alvhe...@commandprompt.com The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
