|
|
 | | From: | Jim Buttafuoco | | Subject: | pg_clog problem (PG version 7.4.5) | | Date: | Sat, 22 Jan 2005 09:35:02 -0500 |
|
|
 | 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/0402": No such file or directory
Pg version is
select version();
version
-------------------------------------------------------------------------------------------------
PostgreSQL 7.4.5 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.4 (Debian 1:3.3.4-6sarge1)
I do have a good backup from the day before, if needed. is there a magic command to get me out of this?
Thanks
Jim
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
|
|
| | From: | Jim Buttafuoco | | Subject: | Re: pg_clog problem (PG version 7.4.5) | | Date: | Sat, 22 Jan 2005 09:58:00 -0500 |
|
|
|
I just upgraded to 7.4.6 and have the same error message.
---------- Original Message -----------
From: "Jim Buttafuoco"
To: "pgsql-hackers"
Sent: Sat, 22 Jan 2005 09:35:02 -0500
Subject: [HACKERS] pg_clog problem (PG version 7.4.5)
> 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/0402": No such file or directory
>
> Pg version is
> select version();
> version
> -------------------------------------------------------------------------------------------------
> PostgreSQL 7.4.5 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.4 (Debian 1:3.3.4-6sarge1)
>
> I do have a good backup from the day before, if needed. is there a magic command to get me out of this?
>
> Thanks
> Jim
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
------- End of Original Message -------
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
|
|
| | From: | Joshua D. Drake | | Subject: | Re: pg_clog problem (PG version 7.4.5) | | Date: | Sat, 22 Jan 2005 08:00:25 -0800 |
|
|
| This is a multi-part message in MIME format.
--------------040603070207090802020909
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
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/pgsql/data/pg_clog/0402": No such file or directory
>
>Pg version is
>select version();
> version
>-------------------------------------------------------------------------------------------------
> PostgreSQL 7.4.5 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.4 (Debian 1:3.3.4-6sarge1)
>
>I do have a good backup from the day before, if needed. is there a magic command to get me out of this?
>
>
You could try creating that file by writing a bunch of zeros to it, for
example:
Shutdown PostgreSQL
Then run the following command in $PGDATA/pg_clog
dd bs=8K count=1 if=/dev/zero of=
Where the filename is the name of the file missing.
No promises though.
Sincerely,
Joshua D. Drake
>Thanks
>Jim
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 8: explain analyze is your friend
>
>
--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL
--------------040603070207090802020909
Content-Type: text/x-vcard; charset=utf-8;
name="jd.vcf"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
filename="jd.vcf"
begin:vcard
fn:Joshua Drake
n:Drake;Joshua
org:Command Prompt, Inc.
adr:;;PO Box 215 ;Cascade Locks;OR;97014;US
email;internet:jd@commandprompt.com
title:Consultant
tel;work:503-667-4564
tel;fax:503-210-0334
x-mozilla-html:FALSE
url:http://www.commandprompt.com
version:2.1
end:vcard
--------------040603070207090802020909
Content-Type: text/plain
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
MIME-Version: 1.0
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
--------------040603070207090802020909--
|
|
|
