From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
---|---|
To: | Lee Duynslager <lee(dot)duynslager(at)gmail(dot)com> |
Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: file signature for files that make up postgres database |
Date: | 2011-03-04 19:05:00 |
Message-ID: | 1299264897-sup-3384@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Excerpts from Lee Duynslager's message of jue mar 03 19:23:35 -0300 2011:
> Hi I am trying to recover a postgres database from a ext3 partition
> that the filesystem has become corrupt and lost files. Can anybody
> tell me what are the file signatures for the files that comprise a
> postgres database?
>
> Anybody know of any tools that can detect and recover postgres files
> from an EXT3 partition? I see that photorec is supposed to be able to
> recognize mysql database files.
Being confronted with exactly this problem currently, I find that
pg_filedump is an excellent tool for identifying files -- both for
detecting which files are PG data files, and also for determining which
file belongs to a given table. Still, it involves too much manual work.
For a small set of files that's OK, but when confronted with a hundred
files or more, it surely needs more automation.
--
Álvaro Herrera <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
From | Date | Subject | |
---|---|---|---|
Next Message | Dimitri Fontaine | 2011-03-04 19:26:28 | Re: Quick Extensions Question |
Previous Message | Tom Lane | 2011-03-04 19:04:06 | Re: Quick Extensions Question |