Re: pg_log: no such file or directory

Поиск
Список
Период
Сортировка
От Bhuvan A
Тема Re: pg_log: no such file or directory
Дата
Msg-id Pine.LNX.4.44.0210301109410.1782-100000@Bhuvan.bksys.co.in
обсуждение исходный текст
Ответ на Re: pg_log: no such file or directory  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: pg_log: no such file or directory  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-admin
> > I use postgresql 7.2. Last night i received a strange error and the
> > postmaster was crashed. It reported
> > 'cannot read block 1470 of pg_log: no such file or directory'.
>
> There is no pg_log in 7.2.  You'll need to be more accurate about your
> situation if you want help ...
>

Sorry for the inconvenience.
$ cat PG_VERSION
7.0

It had been recovered. I did initdb and restored the backup i had. Is
there any other way to recover, in absence of backup? Please let us know.

For your reference, here is the log:

database system was interrupted being in recovery at 2002-10-28 16:34:50
IST
This propably means that some data blocks are corrupted
and you will have to use last backup for recovery.
DEBUG:  CheckPoint record at (2, 1439679740)
DEBUG:  Redo record at (2, 1439679740); Undo record at (0, 0); Shutdown
FALSE
DEBUG:  NextTransactionId: 48106942; NextOid: 3022880
DEBUG:  database system was not properly shut down; automatic recovery in
progress...
DEBUG:  redo starts at (2, 1439679804)
FATAL 2:  cannot read block 1470 of pg_log: No such file or directory
/usr/local/pgsql/bin/postmaster: Startup proc 11284 exited with status 512
- abo

regards,
bhuvaneswaran


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

Предыдущее
От:
Дата:
Сообщение: Re: user functions
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: pg_log: no such file or directory