[URGENT] Problems recovering database
От | Bruno Mattarollo |
---|---|
Тема | [URGENT] Problems recovering database |
Дата | |
Msg-id | Pine.LNX.4.33.0305142227490.17455-100000@web1.greenpeace.org обсуждение исходный текст |
Список | 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 по дате отправления: