Skip site navigation (1) Skip section navigation (2)

Re: Urgent!

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Nirav Parikh <nirav(dot)p(at)workskillsprofessionals(dot)com(dot)au>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Urgent!
Date: 2005-10-13 16:12:50
Message-ID: 20051013161250.GC8138@surnet.cl (view raw or flat)
Thread:
Lists: 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)

In response to

  • Urgent! at 2005-10-13 01:18:21 from Nirav Parikh

pgsql-admin by date

Next:From: Scott MarloweDate: 2005-10-13 16:21:24
Subject: Re: Urgent!
Previous:From: Tom LaneDate: 2005-10-13 16:12:08
Subject: Re: DB Cluster hanging

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group