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