[URGENT] Problems recovering database

From: Bruno Mattarollo <bruno(at)web1(dot)greenpeace(dot)org>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: [URGENT] Problems recovering database
Date: 2003-05-14 20:31:41
Message-ID: Pine.LNX.4.33.0305142227490.17455-100000@web1.greenpeace.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)web1(dot)greenpeace(dot)org> ---
SysAdmin & TechLead - Greenpeace International
http://www.greenpeace.org/
----------------------------------------------------

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bruno Mattarollo 2003-05-14 20:42:00 Re: [URGENT] Problems recovering database
Previous Message Gémes Géza 2003-05-14 20:24:15 Re: authentication error