Hi,
I need urgent help.
I am using PostgreSQL version 8.0.1.
postmaster fails to start and the log file looks as follow:
LOG: database system was shut down at 2005-05-24 15:50:46 MSD
LOG: checkpoint record is at 1/8D117BE4
LOG: redo record is at 1/8D117BE4; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 3859443; next OID: 1904360
LOG: database system is ready
LOG: could not send data to client: Broken pipe
LOG: received smart shutdown request
LOG: checkpoints are occurring too frequently (18 seconds apart)
HINT: Consider increasing the configuration parameter "checkpoint_segments".
LOG: database system was interrupted at 2005-05-24 16:07:50 MSD
LOG: checkpoint record is at 1/A50109AC
LOG: redo record is at 1/A500075C; undo record is at 0/0; shutdown FALSE
LOG: next transaction ID: 3859613; next OID: 1904360
LOG: database system was not properly shut down; automatic recovery in progress
LOG: redo starts at 1/A500075C
PANIC: btree_delete_page_redo: lost target page
LOG: startup process (PID 4409) was terminated by signal 6
LOG: aborting startup due to startup process failure
LOG: logger shutting down
LOG: database system was interrupted while in recovery at 2005-05-24 16:11:14 MSD
HINT: This probably means that some data is corrupted and you will have to use the last backup for recovery.
LOG: checkpoint record is at 1/A50109AC
LOG: redo record is at 1/A500075C; undo record is at 0/0; shutdown FALSE
LOG: next transaction ID: 3859613; next OID: 1904360
LOG: database system was not properly shut down; automatic recovery in progress
LOG: redo starts at 1/A500075C
PANIC: btree_delete_page_redo: lost target page
LOG: startup process (PID 4417) was terminated by signal 6
LOG: aborting startup due to startup process failure
LOG: logger shutting down
The sequence of events was as follow:
1) computer was shut down without stopping postmaster.
2) postmaster was started, but because of an error that there might be another postmaster running, the postmaster was started again.
3) since then each time I try to start the postmaster I get the same error.
To start the postmaster I use "pg_ctl start".
I am running on Linux redhat 9 kernel 2.4..20-8.
Regards,
Nir Dweck
Computer engineer
Tadiran Telecom
18 Hasivim Street,
P.O.Box 7607
Petach-Tikva 49170 Israel
Tel: 972-3-9262807
Fax: 972-3-9262755
<mailto:Nir.dweck@tadirantele.com>