Thanks Tom and Shoaib,
Shoaib, I did not delete postmaster.pid. I killed the children and re-started successfully.
Tom, no useful messages in the log prior. I do have a 47M core dump. What should I do with that?
Sam
From: Shoaib Mir [mailto:shoaibmir@xxxxxxxxx]
Sent: Friday, 10 December 2010 2:00 PM
To: Samuel Stearns
Cc: pgsql-admin@xxxxxxxxxxxxxx
Subject: Re: Postgres Crash
Howdy,
Environment:
Solaris 10
Postgres 8.3.12
Postgres crashed and left 26 postmaster processes active in it’s wake. Killed the children and re-started postgres successfully. Messages from the log:
Dec 10 11:52:15 udrv postgres[771]: [ID 748848 local0.info] [6-1] host=,user=,db= LOG: setsockopt(TCP_NODELAY) failed: Invalid argument
Did ypu try deleting postmaster.pid file and then restarting??
--
Shoaib Mir
http://shoaibmir.wordpress.com/
