Message-ID: <3FAA91BE.5070405@centennialwines.com>
Date: Thu, 06 Nov 2003 12:23:58 -0600
From: "David C. Brown" <dbrown@centennialwines.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
	rv:1.5) Gecko/20031013 Thunderbird/0.3
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: Re: pg_dump error
References: <3FAA867D.9080308@centennialwines.com>
In-Reply-To: <3FAA867D.9080308@centennialwines.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

86 this request.  I've found my problem.  It seems that Dell had an old 
version (7.2.2) of PostgreSQL installed.  It was using pg_dump from that 
version instead of the new version.

The database dump worked great with the new version.

Dave

David C. Brown wrote:

> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>