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.