X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 4018B9FB37A for ; Wed, 30 Aug 2006 21:04:17 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 66208-02-6 for ; Thu, 31 Aug 2006 00:04:10 +0000 (UTC) X-Greylist: delayed 00:18:48.107955 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 3AA1C9FB375 for ; Wed, 30 Aug 2006 21:03:28 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from eciweb.eldocomp.com (smtp.eldocomp.com [205.159.99.39]) by svr4.postgresql.org (Postfix) with ESMTP id A0B045AF8D7 for ; Wed, 30 Aug 2006 23:44:39 +0000 (GMT) Received: by eciweb.eldocomp.com with XWall v3.36 ; Wed, 30 Aug 2006 16:44:33 -0700 From: Naomi Walker To: "pgsql-admin@postgresql.org" Cc: William Bloom Subject: Upgrading from 7.4 to 8.1 Date: Wed, 30 Aug 2006 16:44:32 -0700 X-Assembled-By: XWall v3.36 Message-ID: <44F622E0.6040009@eldocomp.com> Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200608/341 X-Sequence-Number: 22884 We are preparing to upgrade to 8.1 from 7.4 Postrgres. In this case, it is = a Red Hat Linux server. Using the 8.1.4 pg_dumpall, pointed at the 7.4 instance, we g= et the following errors. Anyone know why? Naomi /applications/pgsql/8.1.4/bin/pg_dumpall -- -- PostgreSQL database cluster dump -- \connect postgres -- -- Roles -- CREATE ROLE ""; ALTER ROLE "" WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN; pg_dumpall: query failed: ERROR: type "e" does not exist pg_dumpall: query was: SELECT useconfig[1] FROM pg_shadow WHERE usename =3D = E'\003' --=20 ---------------------------------------------------------------------------- Naomi Walker Chief Information Officer Eldorado Computing, Inc. nwalker@eldocomp.com 602-604-3100 ---------------------------------------------------------------------------- Far and away the best prize that life offers is the chance to work hard at work worth doing. - Theodore Roosevelt ---------------------------------------------------------------------------- -- CONFIDENTIALITY NOTICE -- Information transmitted by this=C2=A0e-mail is proprietary to MphasiS and/or= its Customers and is intended for use only by the individual or entity to w= hich it is addressed, and may contain information that is=C2=A0privileged, c= onfidential or exempt from disclosure under applicable law. If you are not t= he intended recipient or it appears that this e-mail has been forwarded to y= ou without proper authority, you are notified that any use or dissemination = of this information in any manner is strictly prohibited. In such cases, ple= ase notify us immediately at mailmaster@mphasis.com and delete this mail fro= m your records.