Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-docspgsql-novicepgsql-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

pgsql-novice by date

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

pgsql-docs by date

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

pgsql-admin by date

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

pgsql-sql by date

Next:From: Richard Broersma JrDate: 2006-11-21 06:02:46
Subject: Re: Embedded mySQL
Previous:From: Abdul Wahab DahalanDate: 2006-11-21 01:35:13
Subject: Embedded mySQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group