Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 483939F95B5 for ; Mon, 5 Nov 2007 09:06:04 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 61063-08 for ; Mon, 5 Nov 2007 09:06:00 -0400 (AST) X-Greylist: delayed 01:25:02.729059 by SQLgrey-1.7.5 Received: from jefferson.patriot.net (jefferson.patriot.net [209.249.176.3]) by postgresql.org (Postfix) with ESMTP id C16F59F959C for ; Mon, 5 Nov 2007 09:06:00 -0400 (AST) Received: from www.patriot.net ([209.249.177.125]) by jefferson.patriot.net (8.13.4/8.13.4/Debian-3sarge3) with ESMTP id lA5BeqKH001326 for ; Mon, 5 Nov 2007 06:40:55 -0500 Received: from 164.214.4.62 (SquirrelMail authenticated user eromain) by www.patriot.net with HTTP; Mon, 5 Nov 2007 06:40:56 -0500 (EST) Message-ID: <64187.164.214.4.62.1194262856.squirrel@www.patriot.net> Date: Mon, 5 Nov 2007 06:40:56 -0500 (EST) Subject: Error Migrating From 7.4 to 8.2.5 From: eromain@patriot.net To: pgsql-admin@postgresql.org User-Agent: SquirrelMail/1.4.9a MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200711/48 X-Sequence-Number: 27291 I am running PGSQL 7.4 on a Solaris 9 system. I am trying to upgrade to 8.2.5. Both 7.4 and 8.2.5 are on the same server. When I try to use 8.2.5 pg_dumpall to dump the 7.4 databse I receive the following error: pg_dumpall: query failed: ERROR: xlog flush request 58/A0AFB0C0 is not satisfied --- flushed only to 5/B2004628 CONTEXT: writing block 15 of relation 21182403/16408 pg_dumpall: query was: SELECT usename as rolname, usesuper as rolsuper, true as rolinherit, usesuper as rolcreaterole, usecreatedb as rolcreatedb, usecatupd as rolcatupdate, true as rolcanlogin, -1 as rolconnlimit, passwd as rolpassword, valuntil as rolvaliduntil, null as rolcomment FROM pg_shadow UNION ALL SELECT groname as rolname, false as rolsuper, true as rolinherit, false as rolcreaterole, false as rolcreatedb, false as rolcatupdate, false as rolcanlogin, -1 as rolconnlimit, null::text as rolpassword, null::abstime as rolvaliduntil, null as rolcomment FROM pg_group WHERE NOT EXISTS (SELECT 1 FROM pg_shadow WHERE usename = groname) ORDER BY 1 I shut down the 7.4 database and ran pg_resetxlog. This is just a test so I am not worried about losing data. Restarted the database and tried pg_dumpall again. I still received the same error but on a different block. How do I fix this problem? Thank you.