Postgresql 7.1 Beta 5, Postmaster dead 
Author Message
 Postgresql 7.1 Beta 5, Postmaster dead

Woke up this morning and my DB was no longer accepting connections.
The postmaster had stopped running.  Here are my log files, the old
one first.

--- old log ---
Lock file "/usr/local/pgsql/data/postmaster.pid" already exists.
Is another postmaster (pid 450) running in "/usr/local/pgsql/data"?

--- fresh log ---
DEBUG:  starting up
DEBUG:  database system was interrupted at 2001-03-08 09:57:30
DEBUG:  CheckPoint record at (0, 29799500)
DEBUG:  Redo record at (0, 29799500); Undo record at (0, 0); Shutdown
FALSE
DEBUG:  NextTransactionId: 56058; NextOid: 38568
DEBUG:  database system was not properly shut down; automatic recovery
in progress...
DEBUG:  ReadRecord: record with zero len at (0, 29799564)
DEBUG:  Formatting logfile 0 seg 1 block 1589 at offset 5260
DEBUG:  The last logId/logSeg is (0, 1)
DEBUG:  redo is not required
DEBUG:  database system is in production state

-- end --
Any thoughts what may have casued this?  This database has been
running uninterupted for days, although it may have had a bit more
traffic today.

Thanks!

Ryan Mahoney



Mon, 25 Aug 2003 21:34:46 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Postgresql 7.1 Beta 5, Postmaster dead

2. Postgresql goes down need to restart (redhat postgresql service script) lock files removal avoid 2 postmasters

3. 7.1, detecting dead sessions?

4. 7.1 Beta 1 & table size calculation

5. PG 7.1 pre-beta bug ...

6. PG 7.1 pre-beta bug ...

7. Beta 7.1 and Solaris

8. pg_dumpall -c (7.1 beta 4 buglet)

9. DB2 v. 7.1 beta - SQL sp problem

10. Docs for beta 7.1

11. Problems with Multibyte in 7.1 beta?

12. PostgreSQL 7.1 and ORACLE 8.x


 
Powered by phpBB® Forum Software