X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id E7596D1C513
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 31 Jul 2003 11:40:27 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 40721-10
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 31 Jul 2003 08:39:26 -0300 (ADT)
Received: from serwer.skawsoft.com.pl (serwer.skawsoft.com.pl [213.25.37.66])
	by svr1.postgresql.org (Postfix) with ESMTP id E9741D1C50C
	for <pgsql-sql@postgresql.org>; Thu, 31 Jul 2003 08:40:25 -0300 (ADT)
Received: from klaster.net (core-1.citynet.pl [80.48.135.69])
	by serwer.skawsoft.com.pl (Postfix) with ESMTP
	id 3FBC42B3F1; Thu, 31 Jul 2003 13:40:22 +0200 (CEST)
Message-ID: <3F29003D.1010703@klaster.net>
Date: Thu, 31 Jul 2003 13:40:45 +0200
From: Tomasz Myrta <jasiek@klaster.net>
User-Agent: Mozilla/5.0 (Windows; U; Win 9x 4.90; en-US;
 rv:1.4) Gecko/20030624
X-Accept-Language: pl, en-us, en
MIME-Version: 1.0
To: vijaykumar M <m_vijaykumar@hotmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: problem in database backup
References: <BAY2-F56btA1ZPp5ohC00012e0f@hotmail.com>
In-Reply-To: <BAY2-F56btA1ZPp5ohC00012e0f@hotmail.com>
Content-Type: text/plain; charset=ISO-8859-2; format=flowed
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200307/485
X-Sequence-Number: 14599

Dnia 2003-07-31 13:13, Użytkownik vijaykumar M napisał:

> 
> Hi All,
> 
> I'm using Postgresql V7.3.3, on that i created one database with name 
> "mydb".
> 
> * 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)*
> 
> While taking a backup of my postgresql database, i'm getting the below 
> error.
> 
> bash-2.05b$ *pg_dump mydb >mydb.out
> pg_dump: server version: SAGES/pg_dump.mo; pg_dump version: 7.2.2
> pg_dump: aborting because of version mismatch  (Use the -i option to 
> proceed any
> ================================================================*
> 
> *bash-2.05b$ pg_dump -i mydb > mydb.out
> pg_dump: server version: SAGES/pg_dump.mo; 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
> ==============================================================*
> 
> After getting these errors, i tried to check the version of pg_dump on 
> my system by using the below command. Here is the result .....
> 
> *[root@sql-linux root]# find / -name pg_dump -print
> /root/postgresql-7.3.3/src/bin/pg_dump
> /root/postgresql-7.3.3/src/bin/pg_dump/pg_dump
> /usr/bin/pg_dump
> /usr/local/pgsql/bin/pg_dump
> *

Probably you have both 7.2.2 and 7.3.3 pg_dump versions and PATH points 
to 7.2.2 /usr/bin/pg_dump. Try using /usr/local/pgsql/bin/pg_dump

Regards,
Tomasz Myrta