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 F3FE1D1BB13 for ; Mon, 22 Sep 2003 08:55:44 +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 81643-08 for ; Mon, 22 Sep 2003 05:55:14 -0300 (ADT) Received: from chn-dns.primus-india.net (unknown [203.196.153.7]) by svr1.postgresql.org (Postfix) with ESMTP id 3CCE2D1C9FA for ; Mon, 22 Sep 2003 05:55:10 -0300 (ADT) Received: from IVESIA67 (ptil-138-190-chn.primus-india.net [203.196.190.138] (may be forged)) by chn-dns.primus-india.net (8.12.8/8.12.8) with SMTP id h8M8YTeP007710 for ; Mon, 22 Sep 2003 14:04:33 +0530 Message-ID: <010401c380e7$f3cdb010$7502a8c0@hdsc.com> From: "Senthil Kumar S" To: "psql" Subject: Backup error - Please help Date: Mon, 22 Sep 2003 14:30:13 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0101_01C38116.08D44AE0" 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/250 X-Sequence-Number: 15228 This is a multi-part message in MIME format. ------=_NextPart_000_0101_01C38116.08D44AE0 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_0101_01C38116.08D44AE0 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_0101_01C38116.08D44AE0--