Thread: pg_log: no such file or directory
Hi, 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'. While googling i found, "You can change "/\name/" to "/name/" in src/backend/catalog/genbki.sh, then re-make install in that directory; or just use the latest nightly snapshot." But in script src/backend/catalog/genbki.sh, i donot find any string "/\name/". Rather i find "/ name/" at one instance. Do i have to make my change here and re-make? Or i have to upgrade to latest version? In which case i can able to recover my data? How do i recover my data then? Valuable suggestions are very welcome. TIA. regards, bhuvaneswaran
Bhuvan A <bhuvansql@myrealbox.com> writes:
> 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 ...
regards, tom lane
> > 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
Yow, 7.0. You should probably upgrade soon. 7.3 will be released in a few weeks. --------------------------------------------------------------------------- Bhuvan A wrote: > > > 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 > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073