Hy all,
I request your support for the following problem. (with "postmaster (PostgreSQL) 7.4.1")
On a development-system I lost the pg_xlog-directory due to a system crash, where the physical device on which the mountpoint pg_xlog was located got broken.
LOG: could not open file "/usr/local/pgsql/data/./pg_xlog/0000000100000041" (log file 1, segment 65): No such file or directory
LOG: invalid primary checkpoint record
LOG: could not open file "/usr/local/pgsql/data/./pg_xlog/0000000100000041" (log file 1, segment 65): No such file or directory
LOG: invalid secondary checkpoint record
PANIC: could not locate a valid checkpoint record
LOG: startup process (PID 624) was terminated by signal 6
LOG: aborting startup due to startup process failure
So postmaster is not able to start up.
There is no problem with the data, if that would be lost, but I need the datadefinition i.e. structure of the tables, as I have no recent backup of that. :-(
It would even be no problem, if the database would start up and would be inconsistent or empty, as the data get's imported from an old to-be-replaced Sybase DBMS.
Is there a possibility to extract the data definition or to force postmaster to start, even in an inconsistent state or with all "contents" deleted?
Thanx very much in advance,
Dennis Breithaupt
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
