PostgreSQL 8.4 won't start after blackout

Posted by RiZe on Server Fault See other posts from Server Fault or by RiZe
Published on 2009-11-30T12:54:03Z Indexed on 2010/03/27 2:03 UTC
Read the original article Hit count: 698

Filed under:
|
|

I have problem with starting PostgreSQL 8.4 on Ubuntu 9.10 Server after blackout. When I try to connect to the database it says:

psql: server closed the connection unexpectedly
This probably means the server terminated abnormally before or while processing the request.

When I try to start it by using command

sudo -u postgres /etc/init.d/postgresql-8.4 start
 * Starting PostgreSQL 8.4 database server                               [ OK ]

Netstat output

netstat -tulp
(No info could be read for "-p": geteuid()=1000 but you should be root.)
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name
tcp        0      0 localhost:postgresql    *:*                     LISTEN      -
tcp        0      0 192.168.1.35:svn        *:*                     LISTEN      -
tcp        0      0 192.168.1.35:http-alt   *:*                     LISTEN      -
tcp        0      0 *:ssh                   *:*                     LISTEN      -
tcp6       0      0 localhost:postgresql    [::]:*                  LISTEN      -
tcp6       0      0 [::]:ssh                [::]:*                  LISTEN      -
udp        0      0 *:bootpc                *:*                                 -

But still don't work so lets restart it

sudo -u postgres /etc/init.d/postgresql-8.4 restart
 * Restarting PostgreSQL 8.4 database server                                     * The PostgreSQL server failed to start. Please check the log output:
2009-11-30 13:39:37 CET LOG:  database system was shut down at 2009-11-30 13:39:33 CET
2009-11-30 13:39:37 CET LOG:  autovacuum launcher started
2009-11-30 13:39:37 CET LOG:  database system is ready to accept connections
2009-11-30 13:39:37 CET LOG:  incomplete startup packet
2009-11-30 13:39:38 CET LOG:  server process (PID 2240) was terminated by signal 11: Segmentation fault
2009-11-30 13:39:38 CET LOG:  terminating any other active server processes
2009-11-30 13:39:38 CET LOG:  all server processes terminated; reinitializing
2009-11-30 13:39:38 CET LOG:  database system was interrupted; last known up at 2009-11-30 13:39:37 CET
2009-11-30 13:39:38 CET LOG:  database system was not properly shut down; automatic recovery in progress
2009-11-30 13:39:38 CET LOG:  record with zero length at 0/11D464C
2009-11-30 13:39:38 CET LOG:  redo is not required
2009-11-30 13:39:38 CET LOG:  autovacuum launcher started
2009-11-30 13:39:38 CET LOG:  database system is ready to accept connections
2009-11-30 13:39:38 CET LOG:  server process (PID 2248) was terminated by signal 11: Segmentation fault
2009-11-30 13:39:38 CET LOG:  terminating any other active server processes
2009-11-30 13:39:38 CET LOG:  all server processes terminated; reinitializing
2009-11-30 13:39:38 CET LOG:  database system was interrupted; last known up at 2009-11-30 13:39:38 CET
2009-11-30 13:39:38 CET LOG:  database system was not properly shut down; automatic recovery in progress
2009-11-30 13:39:38 CET LOG:  record with zero length at 0/11D4690
2009-11-30 13:39:38 CET LOG:  redo is not required
2009-11-30 13:39:39 CET LOG:  autovacuum launcher started
2009-11-30 13:39:39 CET LOG:  database system is ready to accept connections
2009-11-30 13:39:39 CET LOG:  server process (PID 2256) was terminated by signal 11: Segmentation fault
2009-11-30 13:39:39 CET LOG:  terminating any other active server processes
2009-11-30 13:39:39 CET LOG:  all server processes terminated; reinitializing
2009-11-30 13:39:39 CET LOG:  database system was interrupted; last known up at 2009-11-30 13:39:38 CET
2009-11-30 13:39:39 CET LOG:  database system was not properly shut down; automatic recovery in progress
2009-11-30 13:39:39 CET LOG:  record with zero length at 0/11D46D4
2009-11-30 13:39:39 CET LOG:  redo is not required
2009-11-30 13:39:39 CET LOG:  autovacuum launcher started
2009-11-30 13:39:39 CET LOG:  database system is ready to accept connections
2009-11-30 13:39:39 CET LOG:  server process (PID 2264) was terminated by signal 11: Segmentation fault
2009-11-30 13:39:39 CET LOG:  terminating any other active server processes
2009-11-30 13:39:39 CET LOG:  all server processes terminated; reinitializing
2009-11-30 13:39:39 CET LOG:  database system was interrupted; last known up at 2009-11-30 13:39:39 CET
2009-11-30 13:39:39 CET LOG:  database system was not properly shut down; automatic recovery in progress
2009-11-30 13:39:40 CET LOG:  record with zero length at 0/11D4718
2009-11-30 13:39:40 CET LOG:  redo is not required
2009-11-30 13:39:40 CET LOG:  autovacuum launcher started
2009-11-30 13:39:40 CET LOG:  database system is ready to accept connections
2009-11-30 13:39:40 CET LOG:  server process (PID 2272) was terminated by signal 11: Segmentation fault
2009-11-30 13:39:40 CET LOG:  terminating any other active server processes
2009-11-30 13:39:40 CET LOG:  all server processes terminated; reinitializing
2009-11-30 13:39:40 CET LOG:  database system was interrupted; last known up at 2009-11-30 13:39:40 CET
2009-11-30 13:39:40 CET LOG:  database system was not properly shut down; automatic recovery in progress
2009-11-30 13:39:40 CET LOG:  record with zero length at 0/11D475C
2009-11-30 13:39:40 CET LOG:  redo is not required
2009-11-30 13:39:40 CET LOG:  autovacuum launcher started
2009-11-30 13:39:40 CET LOG:  database system is ready to accept connections
2009-11-30 13:39:41 CET LOG:  server process (PID 2280) was terminated by signal 11: Segmentation fault
2009-11-30 13:39:41 CET LOG:  terminating any other active server processes
2009-11-30 13:39:41 CET LOG:  all server processes terminated; reinitializing
2009-11-30 13:39:41 CET LOG:  database system was interrupted; last known up at 2009-11-30 13:39:40 CET
2009-11-30 13:39:41 CET LOG:  database system was not properly shut down; automatic recovery in progress
2009-11-30 13:39:41 CET LOG:  record with zero length at 0/11D47A0
2009-11-30 13:39:41 CET LOG:  redo is not required
2009-11-30 13:39:41 CET LOG:  autovacuum launcher started
2009-11-30 13:39:41 CET LOG:  database system is ready to accept connections
2009-11-30 13:39:41 CET LOG:  server process (PID 2288) was terminated by signal 11: Segmentation fault
2009-11-30 13:39:41 CET LOG:  terminating any other active server processes
2009-11-30 13:39:41 CET LOG:  all server processes terminated; reinitializing
2009-11-30 13:39:41 CET LOG:  database system was interrupted; last known up at 2009-11-30 13:39:41 CET
2009-11-30 13:39:41 CET LOG:  database system was not properly shut down; automatic recovery in progress
2009-11-30 13:39:41 CET LOG:  record with zero length at 0/11D47E4
2009-11-30 13:39:41 CET LOG:  redo is not required
2009-11-30 13:39:41 CET LOG:  autovacuum launcher started
2009-11-30 13:39:41 CET LOG:  database system is ready to accept connections
2009-11-30 13:39:42 CET LOG:  server process (PID 2296) was terminated by signal 11: Segmentation fault
2009-11-30 13:39:42 CET LOG:  terminating any other active server processes
2009-11-30 13:39:42 CET LOG:  all server processes terminated; reinitializing
2009-11-30 13:39:42 CET LOG:  database system was interrupted; last known up at 2009-11-30 13:39:41 CET
2009-11-30 13:39:42 CET LOG:  database system was not properly shut down; automatic recovery in progress
2009-11-30 13:39:42 CET LOG:  record with zero length at 0/11D4828
2009-11-30 13:39:42 CET LOG:  redo is not required
2009-11-30 13:39:42 CET LOG:  autovacuum launcher started
2009-11-30 13:39:42 CET LOG:  database system is ready to accept connections
2009-11-30 13:39:42 CET LOG:  server process (PID 2304) was terminated by signal 11: Segmentation fault
2009-11-30 13:39:42 CET LOG:  terminating any other active server processes
2009-11-30 13:39:42 CET LOG:  all server processes terminated; reinitializing
2009-11-30 13:39:42 CET LOG:  database system was interrupted; last known up at 2009-11-30 13:39:42 CET
2009-11-30 13:39:42 CET LOG:  database system was not properly shut down; automatic recovery in progress
2009-11-30 13:39:42 CET LOG:  record with zero length at 0/11D486C
2009-11-30 13:39:42 CET LOG:  redo is not required
2009-11-30 13:39:43 CET LOG:  autovacuum launcher started
2009-11-30 13:39:43 CET LOG:  database system is ready to accept connections
2009-11-30 13:39:43 CET LOG:  server process (PID 2312) was terminated by signal 11: Segmentation fault
2009-11-30 13:39:43 CET LOG:  terminating any other active server processes
2009-11-30 13:39:43 CET LOG:  all server processes terminated; reinitializing
2009-11-30 13:39:43 CET LOG:  database system was interrupted; last known up at 2009-11-30 13:39:42 CET
2009-11-30 13:39:43 CET LOG:  database system was not properly shut down; automatic recovery in progress
2009-11-30 13:39:43 CET LOG:  record with zero length at 0/11D48B0
2009-11-30 13:39:43 CET LOG:  redo is not required
2009-11-30 13:39:43 CET LOG:  autovacuum launcher started
2009-11-30 13:39:43 CET LOG:  database system is ready to accept connections
                                                                         [fail]

So what happened and what can I do to solve this? Thanks for replies

© Server Fault or respective owner

Related posts about postgresql

Related posts about psql