Re: Postgres Crash - Mailing list pgsql-admin

From Samuel Stearns
Subject Re: Postgres Crash
Date
Msg-id 68B59BEDCD36854AADBDF17E91B2937A07844CD02E@EXCHMAIL.staff.internode.com.au
Whole thread Raw
In response to Re: Postgres Crash  (Shoaib Mir <shoaibmir@gmail.com>)
Responses Re: Postgres Crash
Re: Postgres Crash
List pgsql-admin

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 PM
To: Samuel Stearns
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Postgres Crash

 

On Fri, Dec 10, 2010 at 2:17 PM, Samuel Stearns <SStearns@internode.com.au> wrote:

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/

pgsql-admin by date:

Previous
From: Shoaib Mir
Date:
Subject: Re: Postgres Crash
Next
From: Shoaib Mir
Date:
Subject: Re: Postgres Crash