ks for the help
Jim
-- Original Message ---
From: Tom Lane <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Cc: Alvaro Herrera <[EMAIL PROTECTED]>, "pgsql-hackers"
Sent: Sat, 22 Jan 2005 13:41:04 -0500
Subject: Re: [HACKERS] pg_clog problem (PG version 7.4.5)
>
"Jim Buttafuoco" <[EMAIL PROTECTED]> writes:
> Thanks for the reply. here is an "ls" of my pg_clog directory. The 0402
> file, I created as per Joshua's directions.
> I might have created one too small. If so, what size do you think I should
> use.
> bda1:/usr/local/pgsql/data# ls -l pg_clog
Alvaro Herrera <[EMAIL PROTECTED]>
To: Jim Buttafuoco <[EMAIL PROTECTED]>
Cc: "Joshua D. Drake" <[EMAIL PROTECTED]>, pgsql-hackers
Sent: Sat, 22 Jan 2005 15:07:35 -0300
Subject: Re: [HACKERS] pg_clog problem (PG version 7.4.5)
> On Sat, Jan 22, 2005 at 12:06:46P
On Sat, Jan 22, 2005 at 12:06:46PM -0500, Jim Buttafuoco wrote:
> didn't work.
>
>
> ERROR: could not access status of transaction 1076101119
> DETAIL: could not read from file "/usr/local/pgsql/data/pg_clog/0402" at
> offset 57344: Success
>
> any more ideas?
You need to extend the file f
ECTED]>
To: [EMAIL PROTECTED]
Cc: pgsql-hackers
Sent: Sat, 22 Jan 2005 08:00:25 -0800
Subject: Re: [HACKERS] pg_clog problem (PG version 7.4.5)
> Jim Buttafuoco wrote:
>
> >hackers,
> >
> >I am having a problem with table (identified by pg_dump). I get the follow
>
Jim Buttafuoco wrote:
hackers,
I am having a problem with table (identified by pg_dump). I get the follow error when I try to COPY the table to
stdout (or /dev/null).
DB=# copy rnk to '/dev/null';
ERROR: could not access status of transaction 1076101119
DETAIL: could not open file "/usr/local/
I just upgraded to 7.4.6 and have the same error message.
-- Original Message ---
From: "Jim Buttafuoco" <[EMAIL PROTECTED]>
To: "pgsql-hackers"
Sent: Sat, 22 Jan 2005 09:35:02 -0500
Subject: [HACKERS] pg_clog problem (PG version 7.4.5)
> hacker
hackers,
I am having a problem with table (identified by pg_dump). I get the follow
error when I try to COPY the table to
stdout (or /dev/null).
DB=# copy rnk to '/dev/null';
ERROR: could not access status of transaction 1076101119
DETAIL: could not open file "/usr/local/pgsql/data/pg_clog/0
