Re: [ADMIN] recovering data from pgsql 6.1 installation

Hi!

I'm trying to recover the database, created by pgsql, installed by previous
admin.  Freshly installed postgresql 6.1 can't read it.  Investigation
showed up that the backend dumps core.

The backtrace follows:

$ gdb postgres core
GDB is free software and you are welcome to distribute copies of it
 under certain conditions; type "show copying" to see the conditions.
There is absolutely no warranty for GDB; type "show warranty" for details.
GDB 4.16 (i586-ksi-linux), Copyright 1996 Free Software Foundation, Inc...
(no debugging symbols found)...
Core was generated by `/home/akhavr/postgres -D /home/postgres/data -e -d 2 mail
ingad'.
Program terminated with signal 11, Segmentation fault.
Reading symbols from /usr/lib/libcrypt.so.1...(no debugging symbols found)...
done.
Reading symbols from /lib/libdl.so.1...(no debugging symbols found)...done.
Reading symbols from /lib/libm.so.5...(no debugging symbols found)...done.
Reading symbols from /usr/lib/libreadline.so.2...
(no debugging symbols found)...done.
Reading symbols from /lib/libtermcap.so.2...(no debugging symbols found)...
done.
Reading symbols from /lib/libc.so.5...(no debugging symbols found)...done.
Reading symbols from /lib/ld-linux.so.1...(no debugging symbols found)...done.
#0  0x80e89b0 in comphash ()
(gdb) bt
#0  0x80e89b0 in comphash ()
#1  0x80e8a5f in CatalogCacheComputeHashIndex ()
#2  0x80e8fc2 in SearchSysCache ()
#3  0x80eb1ec in SearchSysCacheTuple ()
#4  0x80ee325 in SetUserId ()
#5  0x80ee698 in InitUserid ()
#6  0x80ee8ba in InitPostgres ()
#7  0x80ccb36 in PostgresMain ()
#8  0x80964d7 in main ()
#9  0x80621de in _start ()
(gdb)

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

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