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.