[URGENT] Problems recovering database - Mailing list pgsql-admin

From Bruno Mattarollo
Subject [URGENT] Problems recovering database
Date
Msg-id Pine.LNX.4.33.0305142227490.17455-100000@web1.greenpeace.org
Whole thread Raw
List pgsql-admin
Hello,

One of our servers has been hacked and the only thing left are the data
files, no dump. Can I recover a database from that? The database
apparently was shutdown correctly before the files were transferred. The
server was runing pgsql 7.2.2 on RedHat ... I have compiled a version of
PostgreSQL 7.2.2 and copied the whole 'data' directory and when starting
pgsql with:

pg_ctl start -D /location/of/data

It complains

DEBUG:  open of /usr2/pgsql/data/pg_xlog/0000000000000000 (log file 0,
segment 0) failed: No such file or directory
DEBUG:  invalid primary checkpoint record
DEBUG:  open of /usr2/pgsql/data/pg_xlog/0000000000000000 (log file 0,
segment 0) failed: No such file or directory
DEBUG:  invalid secondary checkpoint record

But these files were not present in the 'data' directory from this server,
only these:

$ ls
00000010000000B7  00000010000000B8  00000010000000B9  00000010000000BA
00000010000000BB  00000010000000BC  00000010000000BD  00000010000000BE

Any ideas on how should I proceed?

Thank you in advance,

/B

--

--- Bruno Mattarollo <bruno@web1.greenpeace.org> ---
    SysAdmin & TechLead - Greenpeace International
    http://www.greenpeace.org/
----------------------------------------------------



pgsql-admin by date:

Previous
From: Gémes Géza
Date:
Subject: Re: authentication error
Next
From: Björn Metzdorf
Date:
Subject: Re: [URGENT] Problems recovering database