Tom, ran a CREATE INDEX to the gdb operated postmaster. Nothing new due to missing debugging libraries, so this might not help: Reading symbols from /usr/bin/postmaster...(no debugging symbols found)...done. Missing separate debuginfos, use: debuginfo-install postgresql-server-8.3.9-1PGDG.f12.x86_64 (gdb) run Starting program: /usr/bin/postmaster [Thread debugging using libthread_db enabled] Detaching after fork from child process 2869. LOG: database system was interrupted; last known up at 2010-03-24 05:51:12 PDT LOG: database system was not properly shut down; automatic recovery in progress LOG: redo starts at CF/D482490 LOG: unexpected pageaddr CE/AD490000 in log file 207, segment 13, offset 4784128 LOG: redo done at CF/D48FB80 Detaching after fork from child process 2870. Detaching after fork from child process 2871. Detaching after fork from child process 2872. LOG: database system is ready to accept connections Detaching after fork from child process 2996. Detaching after fork from child process 3682. Detaching after fork from child process 3685. Detaching after fork from child process 3687. Detaching after fork from child process 3688. Detaching after fork from child process 3690. Detaching after fork from child process 3691. Detaching after fork from child process 3696. Detaching after fork from child process 3698. Detaching after fork from child process 3702. Detaching after fork from child process 3706. Detaching after fork from child process 3710. LOG: background writer process (PID 2870) was terminated by signal 9: Killed LOG: terminating any other active server processes LOG: statistics collector process (PID 2872) was terminated by signal 9: Killed Detaching after fork from child process 5595. FATAL: the database system is in recovery mode Is there anything meaningful for you? Does it makes sense to install the debuginfos to catch the problem? If yes, I may do so. Paul asked me, to check another function of the postgis set for a memory leak. I will try this now. Thanks & regards Frans 2010/3/24 Tom Lane <tgl@xxxxxxxxxxxxx>: > Can you provide a stack trace from the crash? > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
