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
|
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: