Re: [ADMIN] recovering data from pgsql 6.1 installation

Hi, Oliver!

>>>>> "OE" == Oliver Elphick writes:

OE> Look at the man page for postgres.

Something in particular?

OE> I suggest you turn on debugging in the backend: nohup postmaster -o -e
OE> -d 2 >> /var/log/postgres.log 2>&1 &

OE> Look at the end of /var/log/postgres.log immediately after a failure to
OE> get an indication of what happened.

$ cat /var/log/postgres.d/messages
[...]
/home/postgres/bin/postmaster: BackendStartup: pid 20300 user akhavr db
mailing socket 5
/home/postgres/bin/postmaster: ServerLoop: done with 5
/home/postgres/bin/postmaster child[20300]:
execv(/home/postgres/bin/postgres, -p, -d2, -P5, -e, mailing, )
FindBackend: found "/home/postgres/bin/postgres" using argv[0]
/home/postgres/bin/postmaster: reaping dead processes...
/home/postgres/bin/postmaster: CleanupProc: pid 20300 exited with status 139
/home/postgres/bin/postmaster: CleanupProc: reinitializing shared memory
and semaphores
binding ShmemCreate(key=9428cec, size=758552)

$ sudo -u postgres /home/postgres/bin/postgres \
-D /home/postgres/data -e -d 2 mailing
FindBackend: found "/home/postgres/bin/postgres" using argv[0]
---debug info---
Quiet = f
Noversion = f
stable = f
timings = f
dates = European
bufsize = 64
query echo = f
multiplexed backend? = f
DatabaseName = [mailing]
----------------

InitPostgres()..
binding ShmemCreate(key=0, size=758552)
Segmentation fault (core dumped)

I guess I should rebuild postgres with debug info and report the backtrace?

--
SY, Andrey V Khavryutchenko http://www.kbi.kiev.ua/~akhavr

Shick's Law:
There is no problem a good miracle can't solve.