Tom, Before the crash is this one -
FATAL 1: Sorry, too many clients already Then there is a mixture of three messages - IpcSemaphoreLock: semop(id=-1) failed: Invalid argument DEBUG: pq_flush: send() failed: Bad file descriptor NOTICE: Message from PostgreSQL backend: The Postmaster has informed me that some other backend died abnormally and possibly corrupted shared memory. I have rolled back the current transaction and am going to terminate your database system connection and exit. Please reconnect to the database system and repeat your query. Shall we simply restart? Are there anywhere advices how to handle if too many clients try to connect? Iavor ----- Original Message ----- From: "Tom Lane" <[EMAIL PROTECTED]> To: "Iavor Raytchev" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, November 10, 2002 2:54 PM Subject: Re: [HACKERS] The database system is in recovery mode > "Iavor Raytchev" <[EMAIL PROTECTED]> writes: > > -bash-2.05b$ psql > > psql: FATAL 1: The database system is in recovery mode > > What do you find in the postmaster's log? > > regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html