dbTalk Databases Forums  

Cannot start PostgreSQL

comp.databases.postgresql.novice comp.databases.postgresql.novice


Discuss Cannot start PostgreSQL in the comp.databases.postgresql.novice forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Reinhard Hnat
 
Posts: n/a

Default Cannot start PostgreSQL - 09-28-2004 , 12:12 AM






I have been workong with postgresql for months without problem and did not
change anything (I hope so). But now i cannot restart it. Starting with
pg_ctl start says 'postmaster successfully started', but when i try to check
with pg_ctl status it says 'pg_ctl: postmaster or postgres is not running'.
There is no matrching process to be seen with 'ps ax'. If i start postmaster
directly i see the following:

DBAdmin@linuxtest:~> postgres -D $PGDATA
LOG: database system was shut down at 2004-09-07 11:15:03 CEST
LOG: open of /home/DBAdmin/postgres/data/pg_xlog/000000010000003E (log file
1, segment 62) failed: Datei oder Verzeichnis nicht gefunden
LOG: invalid primary checkpoint record
LOG: open of /home/DBAdmin/postgres/data/pg_xlog/000000010000003E (log file
1, segment 62) failed: Datei oder Verzeichnis nicht gefunden
LOG: invalid secondary checkpoint record
PANIC: unable to locate a valid checkpoint record
Abgebrochen

'Datei oder Verzeichnis nicht gefunden' means in english: 'File or directory
not found'
'Abgebrochen' means in english 'Aborted'

The files noted in the above messages do not exist but there are otheres
called 0000000100000078 .. 000000010000007D

Has anyone an idea what might be the reason for this and how to recover.
Thanks in advance
----
R.Hnat




---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend


Reply With Quote
  #2  
Old   
Tom Lane
 
Posts: n/a

Default Re: Cannot start PostgreSQL - 09-28-2004 , 09:04 AM






"Reinhard Hnat" <hnat (AT) logotronic (DOT) co.at> writes:
Quote:
DBAdmin@linuxtest:~> postgres -D $PGDATA
LOG: database system was shut down at 2004-09-07 11:15:03 CEST
LOG: open of /home/DBAdmin/postgres/data/pg_xlog/000000010000003E (log file
1, segment 62) failed: Datei oder Verzeichnis nicht gefunden
LOG: invalid primary checkpoint record
LOG: open of /home/DBAdmin/postgres/data/pg_xlog/000000010000003E (log file
1, segment 62) failed: Datei oder Verzeichnis nicht gefunden
LOG: invalid secondary checkpoint record
PANIC: unable to locate a valid checkpoint record

The files noted in the above messages do not exist but there are otheres
called 0000000100000078 .. 000000010000007D
Did you suffer some kind of system crash? xlog files don't normally
just disappear.

You can probably get out of this with pg_resetxlog. I'm not sure
whether you will find corrupted data after you do. The log messages
seem to indicate that the database had been shut down cleanly before
the problem occurred; if so the contents of xlog aren't really needed.
But if you had filesystem corruption it may have affected more than
just the xlog files. A dump and reload might be prudent.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.