Postmaster refuses to start - Mailing list pgsql-hackers

From Roberto Mello
Subject Postmaster refuses to start
Date
Msg-id 20010504140807.A2691@cc.usu.edu
Whole thread Raw
Responses Re: Postmaster refuses to start  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
My postmaster is refusing to start. I don't know what's wrong. If
anyone has pointers/tips/whatever, please tell me. One of my backup scripts was wrong so I don't have current backups
(that's what you get for trusting other people to do your backups). Any
way to recover my databases? The oddities started yesterday. Everytime I'd call a PL/pgSQL
function, the backend would die. The function was working perfectly up to
that point so I know there's nothing wrong with it.I am running PG 7.1 from the Debian packages.
Here's what my log says:

[tons of these]
pq_recvbuf: unexpected EOF on client connection
pq_recvbuf: unexpected EOF on client connection
pq_recvbuf: unexpected EOF on client connection
pq_recvbuf: unexpected EOF on client connection
Server process (pid 3599) exited with status 11 at Thu May  3 10:32:47 2001
Terminating any active server processes...
Server processes were terminated at Thu May  3 10:32:55 2001
Reinitializing shared memory and semaphores
Server process (pid 3616) exited with status 11 at Thu May  3 10:35:21 2001
Terminating any active server processes...
Server processes were terminated at Thu May  3 10:35:21 2001
Reinitializing shared memory and semaphores
pq_recvbuf: unexpected EOF on client connection
pq_recvbuf: unexpected EOF on client connection
pq_recvbuf: unexpected EOF on client connection
pq_recvbuf: unexpected EOF on client connection
Server process (pid 5115) exited with status 11 at Thu May  3 16:03:09 2001
Terminating any active server processes...
Server processes were terminated at Thu May  3 16:03:12 2001 
Reinitializing shared memory and semaphores
Server process (pid 5118) exited with status 11 at Thu May  3 16:03:42 2001
Terminating any active server processes...
Server processes were terminated at Thu May  3 16:03:42 2001
Reinitializing shared memory and semaphores
Server process (pid 5122) exited with status 11 at Thu May  3 16:04:00 2001
Terminating any active server processes...
Server processes were terminated at Thu May  3 16:04:00 2001
Reinitializing shared memory and semaphores
Server process (pid 5158) exited with status 11 at Thu May  3 16:08:43 2001
Terminating any active server processes...
Server processes were terminated at Thu May  3 16:08:45 2001 
Reinitializing shared memory and semaphores
Server process (pid 5176) exited with status 11 at Thu May  3 16:15:32 2001
Terminating any active server processes...
Server processes were terminated at Thu May  3 16:15:33 2001
Reinitializing shared memory and semaphores
The Data Base System is starting up
The Data Base System is starting up
pq_recvbuf: unexpected EOF on client connection
Smart Shutdown request at Thu May  3 16:17:59 2001
Server process (pid 5271) exited with status 11 at Thu May  3 16:21:35 2001
Terminating any active server processes...
Server processes were terminated at Thu May  3 16:21:36 2001
Reinitializing shared memory and semaphores
Server process (pid 5288) exited with status 11 at Thu May  3 16:26:47 2001
Terminating any active server processes...
Server processes were terminated at Thu May  3 16:26:49 2001
Reinitializing shared memory and semaphores
Server process (pid 5293) exited with status 11 at Thu May  3 16:28:32 2001
Terminating any active server processes...
Server processes were terminated at Thu May  3 16:28:32 2001 
Reinitializing shared memory and semaphores
The Data Base System is starting up
Server process (pid 7780) exited with status 512 at Fri May  4 04:06:34 2001
Terminating any active server processes...
Server processes were terminated at Fri May  4 04:06:34 2001
Reinitializing shared memory and semaphores
/usr/lib/postgresql/bin/postmaster: Startup proc 7781 exited with status 512 - abort
/usr/lib/postgresql/bin/postmaster: Startup proc 9347 exited with status 512 - abort
/usr/lib/postgresql/bin/postmaster: Startup proc 9364 exited with status 512 - abort
/usr/lib/postgresql/bin/postmaster: Startup proc 9380 exited with status 512 - abort
These last lines are me trying to restart the postmaster via pg_ctl
with debugging set to 5.
Any help is very much appreciated.
-Roberto

-- 
+----| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+ Roberto Mello - Computer Science, USU -
http://www.brasileiro.net      http://www.sdl.usu.edu - Space Dynamics Lab, Developer    
 


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: "PQgetvalue: ERROR!
Next
From: "Joe Conway"
Date:
Subject: Re: Re: New Linux xfs/reiser file systems