Re: [ADMIN] recovering data from pgsql 6.1 installation

Andrey V Khavryutchenko wrote:
  >OE> Look at the man page for postgres.
  >
  >Something in particular?

I can't remember what your original question was!  postgres is the backend
program, which is started by postmaster for each connection.

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

  >$ sudo -u postgres /home/postgres/bin/postgres \
  >                   -D /home/postgres/data -e -d 2 mailing
 ...
  >Segmentation fault (core dumped)
  >
  >I guess I should rebuild postgres with debug info and report the backtrace?

Remember you can also use gdb (or ddd, which is nicer) to attach to a
running process.

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
               PGP key from public servers; key ID 32B8FAA1
                 ========================================
     "Who is like unto thee, O LORD, among the gods? who is
      like thee, glorious in holiness, fearful in praises,
      doing wonders?"             Exodus 15:11