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

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: >

Re: [GENERAL] Transaction error

2005-09-01 Thread Tom Lane
"Casey T. Deccio" <[EMAIL PROTECTED]> writes: > On Thu, 2005-09-01 at 11:59 -0400, Tom Lane wrote: >> 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 tran

Re: [GENERAL] Transaction error

2005-09-01 Thread Tom Lane
"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 > D