Re: [GENERAL] Transaction error

2005-09-01 Thread Casey T. Deccio 
On Thu, 2005-09-01 at 13:11 -0400, Tom Lane wrote:
> > How would I create a dummy clog segment file, if needed?
> 
> What you'll have to do is pad out the segment file to full size (256K)
> by appending zeroes.  (dd from /dev/zero is useful for this.)
> 

It worked!  Thanks for your help!

Casey


---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq

Re: [GENERAL] Transaction error

2005-09-01 Thread Casey T. Deccio 
On Thu, 2005-09-01 at 11:59 -0400, Tom Lane wrote:
> "Casey T. Deccio" <[EMAIL PROTECTED]> writes:
> > I recently shut down my machine (as far as I know, it went down 
> > cleanly).  When I brought it back up, one of my databases was messed 
> > up.  Here is the error I get when I try to select:
> 
> > ERROR:  could not access status of transaction 4114057
> > DETAIL:  could not open file "/var/lib/postgres/data/pg_clog/0003": No 
> > such file or directory
> 
> > I tried restoring a backup of the data directory that did contain the 
> > 0003 file, but that didn't work either.
> 
> Define "didn't work" ... what happened, exactly, when you tried it?
> 

Sorry, I was too tired last night to try it again and post the error.
Here it is:

ERROR:  could not access status of transaction 4114057
DETAIL:  could not read from file "/var/lib/postgres/data/pg_clog/0003"
at offset 237568: Success

> People have occasionally dealt with this sort of scenario by creating
> dummy clog segment files by hand, and I'd think that restoring the
> segment file from a backup would do as well or better.
> 

How would I create a dummy clog segment file, if needed?

Regards,
Casey


---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org

[GENERAL] Transaction error

2005-09-01 Thread Casey T. Deccio 

Hi,

I recently shut down my machine (as far as I know, it went down 
cleanly).  When I brought it back up, one of my databases was messed 
up.  Here is the error I get when I try to select:


ERROR:  could not access status of transaction 4114057
DETAIL:  could not open file "/var/lib/postgres/data/pg_clog/0003": No 
such file or directory


I tried restoring a backup of the data directory that did contain the 
0003 file, but that didn't work either.  I don't have a copy of the 
dump before the crash--though I think that is what I'll backup next 
time.  How can I get my data back?


Debian GNU/Linux
postgres 7.4.7

Casey


---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings