
Any way to recover?

FATAL 2:  open of /usr/local/pgsql/5432/pg_clog/06F6 failed: No such file or directory

The RAID controller went on our server today ... is it safe to just
'touch' the files, or is this a 'restore from backup and deal with the
losses' sort of thing? :(




Thu, 6 Mar 2003 22:10:15 -0400 (AST)
"Marc G. Fournier" <scrappy@hub.org>
Bad crash, pg_clog files missing ... ?
"Marc G. Fournier" <scrappy@hub.org> writes:
> FATAL 2:  open of /usr/local/pgsql/5432/pg_clog/06F6 failed: No such file or directory

> The RAID controller went on our server today ... is it safe to just
> 'touch' the files, or is this a 'restore from backup and deal with the
> losses' sort of thing? :(

What range of filenames is actually in $PGDATA/pg_clog/ ?

I suspect 06F6 is well beyond that range, in which case this error
implies corrupted table files, in which case "restore from backup"
is the indicated course of action :-(

			regards, tom lane

Thu, 06 Mar 2003 23:32:11 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: Bad crash, pg_clog files missing ... ? 

'K, that's what I ended up doing ... the server crashed *really* hard, but
I had a backup from 24hrs previous that I used to do restores ... I kinda
figured that I was lost :(

But, the files available are/where ...

venus# ls -lt
total 1168
-rw-------  1 pgsql  pgsql   81920 Mar  6 19:50 0168
-rw-------  1 pgsql  pgsql  262144 Mar  5 20:06 0167
-rw-------  1 pgsql  pgsql  262144 Mar  5 14:10 0166
-rw-------  1 pgsql  pgsql  262144 Mar  5 09:03 0165
-rw-------  1 pgsql  pgsql  262144 Mar  5 02:08 0164


On Thu, 6 Mar 2003, Tom Lane wrote:

> "Marc G. Fournier" <scrappy@hub.org> writes:
> > FATAL 2:  open of /usr/local/pgsql/5432/pg_clog/06F6 failed: No such file or directory
>
> > The RAID controller went on our server today ... is it safe to just
> > 'touch' the files, or is this a 'restore from backup and deal with the
> > losses' sort of thing? :(
>
> What range of filenames is actually in $PGDATA/pg_clog/ ?
>
> I suspect 06F6 is well beyond that range, in which case this error
> implies corrupted table files, in which case "restore from backup"
> is the indicated course of action :-(
>
> 			regards, tom lane
>

Fri, 7 Mar 2003 00:46:20 -0400 (AST)
"Marc G. Fournier" <scrappy@hub.org>
Re: Bad crash, pg_clog files missing ... ? 