Fw: postgres database crash

Поиск
Список
Период
Сортировка
От anil maran
Тема Fw: postgres database crash
Дата
Msg-id 20061122002942.44451.qmail@web55214.mail.re4.yahoo.com
обсуждение исходный текст
Ответы Re: Fw: postgres database crash  (Richard Broersma Jr <rabroersma@yahoo.com>)
Список pgsql-admin
Hi
CRON job running vacuum on a database and pg_ctl stop -m fast got called

Now I m unable to 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
 
Anil


Sponsored Link


Degrees for employed people - in as fast as 1 year. A.S. / Bachelors / Masters

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Nigel Bishop"
Дата:
Сообщение: Re: Getting bind variables from log file
Следующее
От: Richard Broersma Jr
Дата:
Сообщение: Re: Fw: postgres database crash