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

Dennis Breithaupt wrote:
[color=blue]
> 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.
>[/color]
[...]

....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 majordomo@postgresql.org

Dennis Breithaupt wrote:
[color=blue]
> 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.
>[/color]
[...]

....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 majordomo@postgresql.org