LOG: logger shutting down

From: anil maran <anilmrn(at)yahoo(dot)com>
To: anil maran <anilmrn(at)yahoo(dot)com>, allan(at)saddi(dot)com
Subject: LOG: logger shutting down
Date: 2006-11-21 01:59:46
Message-ID: 20061121015946.63150.qmail@web55207.mail.re4.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-docs pgsql-novice pgsql-sql

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


____________________________________________________________________________________
Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail beta.
http://new.mail.yahoo.com

Browse pgsql-admin by date

  From Date Subject
Next Message Alex Stienstra 2006-11-21 09:43:08 enable logging on windows
Previous Message Bruce Momjian 2006-11-20 21:28:38 Re: Getting bind variables from log file

Browse pgsql-docs by date

  From Date Subject
Next Message Bruce Momjian 2006-11-21 03:22:52 Re: [Pgcluster-general] PostgreSQL Documentation of
Previous Message Bruce Momjian 2006-11-20 22:18:29 Re: "Clustering"

Browse pgsql-novice by date

  From Date Subject
Next Message George Weaver 2006-11-21 15:15:34 PostgreSQL doesn't accept connections when Windows Server is rebooted
Previous Message Mikael Carneholm 2006-11-20 20:07:24 Re: CHECK constraint and trigger

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Broersma Jr 2006-11-21 06:02:46 Re: Embedded mySQL
Previous Message Abdul Wahab Dahalan 2006-11-21 01:35:13 Embedded mySQL