LOG: logger shutting down

[anil maran <anilmrn(at)yahoo(dot)com>]

my db server has crashed

i m using postgres

what happened is when reindexing was happening

postgres got shut down

now i m unable to start can you give me any pointers

CRON running vacuum on a database
and pg_ctl stop -m fast got called

Now I m unalbe ot run the database, the following is the error when I run pg_ctl -D /work/database start
LOG:  logger shutting down

on running tail -n 30 postgresql-Mon.log
LOG:  database system was not properly shut down; automatic recovery in progress
LOG:  redo starts at 8A/8F00833C
PANIC:  block 1100 unfound
LOG:  startup process (PID 31612) 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 2006-11-20 16:56:18 PST
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 8A/8F01D6D4
LOG:  redo record is at 8A/8F00833C; undo record is at 0/0; shutdown FALSE
LOG:  next transaction ID: 32782967; next OID: 2499839
LOG:  next MultiXactId: 972; next MultiXactOffset: 2099
LOG:  database system was not properly shut down; automatic recovery in progress
LOG:  redo starts at 8A/8F00833C
PANIC:  block 1100 unfound
LOG:  startup process (PID 31846) 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 2006-11-20 17:12:21 PST
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 8A/8F01D6D4
LOG:  redo record is at 8A/8F00833C; undo record is at 0/0; shutdown FALSE
LOG:  next transaction ID: 32782967; next OID: 2499839
LOG:  next MultiXactId: 972; next MultiXactOffset: 2099
LOG:  database system was not properly shut down; automatic recovery in progress
LOG:  redo starts at 8A/8F00833C
PANIC:  block 1100 unfound
LOG:  startup process (PID 32000) was terminated by signal 6
LOG:  aborting startup due to startup process failure
LOG:  logger shutting down

pg_controldata
pg_control version number:            812
Catalog version number:               200510211
Database system identifier:           4952196794948500735
Database cluster state:               in recovery
pg_control last modified:             Mon 20 Nov 2006 05:14:36 PM PST
Current log file ID:                  138
Next log file segment:                170
Latest checkpoint location:           8A/8F01D6D4
Prior checkpoint location:            8A/8C01924C
Latest checkpoint's REDO location:    8A/8F00833C
Latest checkpoint's UNDO location:    0/0
Latest checkpoint's TimeLineID:       1
Latest checkpoint's NextXID:          32782967
Latest checkpoint's NextOID:          2499839
Latest checkpoint's NextMultiXactId:  972
Latest checkpoint's NextMultiOffset:  2099
Time of latest checkpoint:            Mon 20 Nov 2006 12:53:56 PM PST
Maximum data alignment:               4
Database block size:                  8192
Blocks per segment of large relation: 131072
Bytes per WAL segment:                16777216
Maximum length of identifiers:        64
Maximum columns in an index:          32
Date/time type storage:               floating-point numbers
Maximum length of locale name:        128
LC_COLLATE:                           en_US.UTF-8
LC_CTYPE:                             en_US.UTF-8


I tried running pg_resetxlog everything got lost, so restoring the copied database folder

I got pointers to looking at pg_filedump and I could not find out how to specify options to filedump
Please help me out
my data bases is like 1gigabyte, panicking
thanks

 

---

Sponsored Link

Mortgage rates as low as 4.625% - $150,000 loan for $579 a month. Intro-*Terms