Re: [SQL] postgres server crashes unexpectedly

2008-03-18 Thread Chadwick Horn
"Chadwick Horn" <[EMAIL PROTECTED]> writes: I keep getting this error: Attempting reset: WARNING: terminating connection because of crash of another server process It looks to me like psql is managing to start a new connection before the postmaster notices the crash of the p

Re: [SQL] postgres server crashes unexpectedly

2008-03-18 Thread Chadwick Horn
In all honesty, we're fairly "trapped" on the box we have due to the depths of corporate approvals required to get something new online. I would, most def, prefer to be on anything BUT this... - Original Message - From: "Joshua Kramerý€€€„" <[EMAIL PRO

Re: [SQL] postgres server crashes unexpectedly

2008-03-18 Thread Chadwick Horn
rocessing the request. The connection to the server was lost. Attempting reset: Succeeded. What could be doing this? It just started out of the blue... I reindexed the index it mentioned and it seems to error out more... -Chadwick - Original Message - From: "Tom Lane" &l

[SQL] postgres server crashes unexpectedly

2008-03-17 Thread Chadwick Horn
hi all, we've had a db to stop working for some reason and have searched through google to it's ends to no avail. we have reindexed the database and system database as tried to determine other things that would keep it from working... again, to no avail. this just started occuring about 2 week