Hello, I am developing an php application and by mistake a wrong timezone was
set after I initialized the connection, which resulted in a core dump of the
current process.
The postgres version is 8.0.3 running on a freebsd 6.0-RELEASE machine with
the generic kernel.
I tried searching for similar problems but I could not find similar reports.
from /var/log/messages:
Jan 10 17:14:40 dndwebdev01 postgres[17374]: [1-1] ERROR: unrecognized time
zone name: "America/Indiana"
Jan 10 17:14:40 dndwebdev01 kernel: pid 17374 (postgres), uid 70: exited on
signal 11 (core dumped)
Jan 10 17:14:40 dndwebdev01 postgres[17372]: [1-1] WARNING: terminating
connection because of crash of another server process
Jan 10 17:14:40 dndwebdev01 postgres[17372]: [1-2] DETAIL: The postmaster has
commanded this server process to roll back the current transaction and exit,
because another server
Jan 10 17:14:40 dndwebdev01 postgres[17372]: [1-3] process exited abnormally
and possibly corrupted shared memory.
Jan 10 17:14:40 dndwebdev01 postgres[17372]: [1-4] HINT: In a moment you
should be able to reconnect to the database and repeat your command.
Nick