| From: | Dennis Breithaupt <dennisb(at)tetaworx(dot)de> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | lost pg_xlog // recover database-structure without it? |
| Date: | 2004-06-11 15:03:40 |
| Message-ID: | 40C9C9CC.4010600@tetaworx.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dennis Breithaupt | 2004-06-11 15:25:55 | Re: lost pg_xlog (SOLVED) |
| Previous Message | zhicheng wang | 2004-06-11 13:34:54 | postgresql training course, please recommend |