X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 2A6E7D1B991 for ; Thu, 6 Nov 2003 17:35:17 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 10280-09 for ; Thu, 6 Nov 2003 13:34:46 -0400 (AST) Received: from enterprise.centliq.com (adsl-65-71-224-185.dsl.rcsntx.swbell.net [65.71.224.185]) by svr1.postgresql.org (Postfix) with ESMTP id 2F35CD1B981 for ; Thu, 6 Nov 2003 13:34:45 -0400 (AST) Received: from centennialwines.com (unknown [192.168.1.2]) by enterprise.centliq.com (Postfix) with ESMTP id E7030FF003 for ; Thu, 6 Nov 2003 10:31:28 -0600 (CST) Message-ID: <3FAA867D.9080308@centennialwines.com> Date: Thu, 06 Nov 2003 11:35:57 -0600 From: "David C. Brown" User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.5) Gecko/20031013 Thunderbird/0.3 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: pg_dump error Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=USER_AGENT_MOZILLA_UA X-Spam-Level: X-Archive-Number: 200311/99 X-Sequence-Number: 11087 I'm receiving an error from pg_dumpall while trying to backup my database. To explain, this database used to be 7.2.1 but we have upgraded the server and I just used pg_dumpall and then reloaded that data into the new system which runs on 7.3.3 The problem is I get an error when using pg_dumpall/pg_dump. Here are the version info and the error messages. Old database. version ------------------------------------------------------------- PostgreSQL 7.2.1 on i586-pc-linux-gnu, compiled by GCC 2.96 (1 row) New database. version --------------------------------------------------------------------------------------------------------- PostgreSQL 7.3.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2 20020903 (Red Hat Linux 8.0 3.2-7) (1 row) Error message when using pg_dump. I get the same message with pg_dumpall. pg_dump -i -U postgres whse > db.out Password: pg_dump: server version: PostgreSQL 7.3.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2 20020903 (Red Hat Linux 8.0 3.2-7); pg_dump version: 7.2.2 pg_dump: proceeding despite version mismatch pg_dump: query to obtain list of data types failed: ERROR: Attribute "typprtlen" not found It says that it's using pg_dump version 7.2.2. I'm not sure if that is the version that comes with 7.3.3, but PostgreSQL was compile fresh from source on the new machine. Where it got this version of pg_dump/pg_dumpall I'm unclear of. If anyone has any ideas that could help me out it would be greatly appreciated. I tried searching the pgsql-admin archives, but was unable to find related items. Thanks, Dave