	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    

Fri, 4 May 2001 14:08:07 -0600
Roberto Mello <rmello@cc.usu.edu>
Postmaster refuses to start 
Roberto Mello <rmello@cc.usu.edu> writes:
> 	My postmaster is refusing to start. I don't know what's wrong. If
> anyone has pointers/tips/whatever, please tell me. 

Perhaps a gdb backtrace from one of the core files would yield clues.

			regards, tom lane

Fri, 04 May 2001 19:05:52 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: Postmaster refuses to start 