X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9DB5AD8036 for ; Thu, 13 Oct 2005 13:12:57 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 41085-07 for ; Thu, 13 Oct 2005 16:12:50 +0000 (GMT) Received: from mx1.surnet.cl (mx2.surnet.cl [216.155.73.181]) by svr1.postgresql.org (Postfix) with ESMTP id 9E4EAD7B26 for ; Thu, 13 Oct 2005 13:12:50 -0300 (ADT) Received: from unknown (HELO cluster.surnet.cl) ([216.155.73.165]) by mx1.surnet.cl with ESMTP; 13 Oct 2005 13:12:18 -0300 Received: from alvh.no-ip.org (200.85.216.75) by cluster.surnet.cl (7.0.043) (authenticated as alvherre@surnet.cl) id 433A601F00735387; Thu, 13 Oct 2005 13:12:49 -0300 Received: by alvh.no-ip.org (Postfix, from userid 1000) id 60121C2D469; Thu, 13 Oct 2005 13:12:50 -0300 (CLST) Date: Thu, 13 Oct 2005 13:12:50 -0300 From: Alvaro Herrera To: Nirav Parikh Cc: pgsql-admin@postgresql.org Subject: Re: Urgent! Message-ID: <20051013161250.GC8138@surnet.cl> Mail-Followup-To: Nirav Parikh , pgsql-admin@postgresql.org References: <221385EC3F18A44DB0925467A1D2395F38FB07@exsrv3.workskillsprofessionals.com.au> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <221385EC3F18A44DB0925467A1D2395F38FB07@exsrv3.workskillsprofessionals.com.au> User-Agent: Mutt/1.5.10i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.946 required=5 tests=[AWL=-1.712, DNS_FROM_RFC_ABUSE=0.374, DNS_FROM_RFC_POST=1.376, FORGED_RCVD_HELO=0.05, RCVD_IN_BL_SPAMCOP_NET=1.832, RCVD_IN_NJABL_PROXY=1.026] X-Spam-Level: ** X-Archive-Number: 200510/149 X-Sequence-Number: 19221 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)