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 8E687D1C9FA for ; Mon, 22 Sep 2003 08:56:28 +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 79188-10 for ; Mon, 22 Sep 2003 05:55:58 -0300 (ADT) Received: from smtp101.mail.sc5.yahoo.com (smtp101.mail.sc5.yahoo.com [216.136.174.139]) by svr1.postgresql.org (Postfix) with SMTP id 7F0A2D1C9FD for ; Mon, 22 Sep 2003 05:55:55 -0300 (ADT) Received: from ptil-138-190-chn.primus-india.net (HELO IVESIA67) (sgnerd@203.196.190.138 with login) by smtp.mail.vip.sc5.yahoo.com with SMTP; 22 Sep 2003 08:55:56 -0000 Message-ID: <011101c380e8$10200dd0$7502a8c0@hdsc.com> Reply-To: "Kumar" From: "Kumar" To: "psql" Subject: Backup error - Pls help Date: Mon, 22 Sep 2003 14:31:00 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_010E_01C38116.24DA5D60" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/243 X-Sequence-Number: 15221 This is a multi-part message in MIME format. ------=_NextPart_000_010E_01C38116.24DA5D60 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I have 2 versions of Postgres server 7.2 & 7.3.4 installed on Linux server = 7.3. I have not started the Postgres Server 7.2 which is located at /var/li= brary/pgsql. I am running and using only 7.3.4 located at /usr/local/pgsql. After I login, I come to the /usr/local/pgsql/bin and then issued the follo= wing [usr1@Linuxsvr bin]$ pg_dump -h 192.168.2.51 -f /home/usr1/prod.sql prod pg_dump: server version: pg_dump.mo; pg_dump version: 7.2.1 pg_dump: aborting because of version mismatch (Use the -i option to procee= d anyway.) [usr1@Linuxsvr bin]$ pg_dump -h 192.168.2.51 -i -f /home/usr1/prod.sql prod =20 pg_dump: server version: pg_dump.mo; pg_dump version: 7.2.1 pg_dump: proceeding despite version mismatch pg_dump: query to obtain list of data types failed: ERROR: Attribute "typp= rtlen" not foun d [usr1@Linuxsvr bin]$ Where i am doing mistake. Pls shed some light. Thank you very much. Kumar ------=_NextPart_000_010E_01C38116.24DA5D60 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi,
 
I have 2 versions of Postgres server 7.2 & 7.3.4 in= stalled=20 on Linux server 7.3. I have not started the Postgres Server 7.2 which is lo= cated=20 at /var/library/pgsql.
 
I am running and using only 7.3.4 located at=20 /usr/local/pgsql.
 
After I login, I come to the /usr/local/pgsql/bin and t= hen=20 issued the following
 
 

[usr1@Linuxsvr b= in]$=20 pg_dump -h 192.168.2.51 -f /home/usr1/prod.sql prod
pg_dump: server vers= ion:=20 pg_dump.mo; pg_dump version: 7.2.1
pg_dump: aborting because of version= =20 mismatch  (Use the -i option to proceed anyway.)
[usr1@Linuxsvr bin= ]$=20 pg_dump -h 192.168.2.51 -i -f /home/usr1/prod.sql prod

 

pg_dump: server= =20 version: pg_dump.mo; pg_dump version: 7.2.1
pg_dump: proceeding despite= =20 version mismatch
pg_dump: query to obtain list of data types failed:=20 ERROR:  Attribute "typprtlen" not foun
d
[usr1@Linuxsvr=20 bin]$

 

Where i am doing= =20 mistake. Pls shed some light.

 

Thank you very= =20 much.

 

Kumar

=

------=_NextPart_000_010E_01C38116.24DA5D60--