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