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@gmail.com] Sent: Friday, 10 December 2010 2:00 PMTo: Samuel StearnsCc: pgsql-admin@postgresql.orgSubject: Re: [ADMIN] Postgres Crash
On Fri, Dec 10, 2010 at 2:17 PM, Samuel Stearns <SStearns@internode.com.au> wrote:
Howdy, Environment: Solaris 10Postgres 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
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 Mirhttp://shoaibmir.wordpress.com/
pgsql-admin by date:
Соглашаюсь с условиями обработки персональных данных