469,337 Members | 6,124 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,337 developers. It's quick & easy.

lost pg_xlog // recover database-structure without it?

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

Nov 23 '05 #1
2 2736
Dennis Breithaupt wrote:
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.

[...]

....in the 2nd approach I solved the problem running pg_resetxlog. :-/
nice tool, very nice dbms ;)

sorry for the unnecessery posting...

-Dennis Breithaupt

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 23 '05 #2
Dennis Breithaupt wrote:
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.

[...]

....in the 2nd approach I solved the problem running pg_resetxlog. :-/
nice tool, very nice dbms ;)

sorry for the unnecessery posting...

-Dennis Breithaupt

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Achilles | last post: by
2 posts views Thread by Adam Haberlach | last post: by
reply views Thread by zhicheng wang | last post: by
reply views Thread by mike_dba | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by Marylou17 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.