Thread: pg_log: no such file or directory

pg_log: no such file or directory

From
Bhuvan A
Date:
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


Re: pg_log: no such file or directory

From
Tom Lane
Date:
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

Re: pg_log: no such file or directory

From
Bhuvan A
Date:
> > 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


Re: pg_log: no such file or directory

From
Bruce Momjian
Date:
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