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 768ECD1B917 for ; Thu, 12 Feb 2004 22:42:59 +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 43246-01 for ; Thu, 12 Feb 2004 18:42:58 -0400 (AST) Received: from megazone.bigpanda.com (megazone.bigpanda.com [64.147.171.210]) by svr1.postgresql.org (Postfix) with ESMTP id 8F358D1B4DA for ; Thu, 12 Feb 2004 18:42:55 -0400 (AST) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 3052235843; Thu, 12 Feb 2004 14:42:42 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 2CEE635842; Thu, 12 Feb 2004 14:42:42 -0800 (PST) Date: Thu, 12 Feb 2004 14:42:42 -0800 (PST) From: Stephan Szabo To: Paulo Rogerio Zimolo Cc: pgsql-admin@postgresql.org Subject: Re: Dumping from version 7.3.4 to 7.4.1 In-Reply-To: Message-ID: <20040212144153.G97217@megazone.bigpanda.com> References: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/186 X-Sequence-Number: 12360 On Wed, 11 Feb 2004, Paulo Rogerio Zimolo wrote: > I'm trying to do pg_dump an old version (7.3.4) to a new one (7.4.1) with > the following command: > > pg_dump -U username -h server -i -o database | psql -U username -h > newserver newdatabase > > As a result I got: > > pg_dump: server version:PostgreSQL 7.3.4 on i586-pc-linux-gnu, compiled > by GCC 2.95.3; > pg_dump version:7.2 It looks to me like the pg_dump you're using is even further out of date by the above. I'd suggest trying to use the 7.4.1 pg_dump if you've got it or at least the 7.3.4 one failing that.