Re: Urgent! - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: Urgent!
Date
Msg-id 20051013161250.GC8138@surnet.cl
Whole thread Raw
In response to Urgent!  ("Nirav Parikh" <nirav.p@workskillsprofessionals.com.au>)
List pgsql-admin
Nirav Parikh wrote:
> Hi,
>
> I got this error message when I tried to do pg_dump on the database.
>
> pg_dump: ERROR:  invalid memory alloc request size 4294967293
> pg_dump: SQL command to dump the contents of table "wordlist" failed:
> PQendcopy() failed.
> pg_dump: Error message from server: ERROR:  invalid memory alloc request
> size 4294967293
> pg_dump: The command was: COPY public.wordlist (word_id, word,
> count_word) TO stdout;
>
> I went to phppgadmin and try to access the worldlist table and it also
> gives me following error message:
>
> ERROR:  could not access status of transaction 6849340
> DETAIL:  could not open file "/var/lib/pgsql/data/pg_clog/0006": No such
> file or directory

What version is this?  Also, is the system running with fsync=off or on
disks with write cache enabled?

--
Alvaro Herrera       Valdivia, Chile   ICBM: S 39º 49' 17.7", W 73º 14' 26.8"
"La fuerza no está en los medios físicos
sino que reside en una voluntad indomable" (Gandhi)

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: DB Cluster hanging
Next
From: "codeWarrior"
Date:
Subject: Re: DB Cluster hanging