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

[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/da