From sgnerd@yahoo.com.sg Mon Sep 22 08:56:28 2003 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-- From dev@archonet.com Mon Sep 22 09:51:25 2003 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 8FEA9D1B575 for ; Mon, 22 Sep 2003 09:51:25 +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 94111-03 for ; Mon, 22 Sep 2003 06:50:49 -0300 (ADT) Received: from anchor-post-34.mail.demon.net (anchor-post-34.mail.demon.net [194.217.242.92]) by svr1.postgresql.org (Postfix) with ESMTP id 79A9FD1B8A9 for ; Mon, 22 Sep 2003 06:50:41 -0300 (ADT) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-34.mail.demon.net with esmtp (Exim 3.35 #1) id 1A1NL8-0008Pu-0Y; Mon, 22 Sep 2003 10:50:43 +0100 Received: from localhost (localhost.localdomain [127.0.0.1]) by mainbox.archonet.com (Postfix) with ESMTP id 6D3C016B36; Mon, 22 Sep 2003 10:50:35 +0100 (BST) Received: from client17.archonet.com (client17.archonet.com [192.168.1.17]) by mainbox.archonet.com (Postfix) with ESMTP id CE42516B30; Mon, 22 Sep 2003 10:50:34 +0100 (BST) From: Richard Huxton To: "Kumar" , "psql" Subject: Re: Backup error - Pls help Date: Mon, 22 Sep 2003 10:50:34 +0100 User-Agent: KMail/1.5 References: <011101c380e8$10200dd0$7502a8c0@hdsc.com> In-Reply-To: <011101c380e8$10200dd0$7502a8c0@hdsc.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200309221050.34908.dev@archonet.com> X-Virus-Scanned: by AMaViS snapshot-20020531 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/245 X-Sequence-Number: 15223 On Monday 22 September 2003 10:01, Kumar wrote: > 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/library/pgsql. RedHat 7.3 I guess you mean? > 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 > following > > > [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 > proceed anyway.) [usr1@Linuxsvr bin]$ pg_dump -h 192.168.2.51 -i -f > /home/usr1/prod.sql prod What directory you are in has nothing to do with which copy of a program you will run. There is a utility called "which" to help you: "which pg_dump". Almost certainly what you want to do is: /usr/local/pgsql/bin/pg_dump -h ... You probably want to get a book on unix/linux and read up about the various search paths. -- Richard Huxton Archonet Ltd From sgnerd@yahoo.com.sg Mon Sep 22 11:41:48 2003 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 841D9D1B535 for ; Mon, 22 Sep 2003 11:41:48 +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 11059-02 for ; Mon, 22 Sep 2003 08:41:40 -0300 (ADT) Received: from smtp012.mail.yahoo.com (smtp012.mail.yahoo.com [216.136.173.32]) by svr1.postgresql.org (Postfix) with SMTP id 91F0ED1B525 for ; Mon, 22 Sep 2003 08:41:36 -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 11:41:38 -0000 Message-ID: <007d01c380ff$366684d0$7502a8c0@hdsc.com> Reply-To: "Kumar" From: "Kumar" To: "Richard Huxton" , "psql" References: <011101c380e8$10200dd0$7502a8c0@hdsc.com> <200309221050.34908.dev@archonet.com> Subject: Re: Backup error - Pls help Date: Mon, 22 Sep 2003 17:16:38 +0530 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit 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/247 X-Sequence-Number: 15225 While I issue which pg_dump it is showed me /usr/local/pg_dump But how to run the backup utility pg_dump to backup my database. ----- Original Message ----- From: "Richard Huxton" To: "Kumar" ; "psql" Sent: Monday, September 22, 2003 3:20 PM Subject: Re: [SQL] Backup error - Pls help > On Monday 22 September 2003 10:01, Kumar wrote: > > 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/library/pgsql. > > RedHat 7.3 I guess you mean? > > > 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 > > following > > > > > > [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 > > proceed anyway.) [usr1@Linuxsvr bin]$ pg_dump -h 192.168.2.51 -i -f > > /home/usr1/prod.sql prod > > What directory you are in has nothing to do with which copy of a program you > will run. There is a utility called "which" to help you: "which pg_dump". > Almost certainly what you want to do is: > /usr/local/pgsql/bin/pg_dump -h ... > > You probably want to get a book on unix/linux and read up about the various > search paths. > -- > Richard Huxton > Archonet Ltd From sgnerd@yahoo.com.sg Mon Sep 22 12:10:47 2003 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 34A13D1B8DE for ; Mon, 22 Sep 2003 12:10:47 +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 15983-03 for ; Mon, 22 Sep 2003 09:10:36 -0300 (ADT) Received: from smtp012.mail.yahoo.com (smtp012.mail.yahoo.com [216.136.173.32]) by svr1.postgresql.org (Postfix) with SMTP id 612D4D1B588 for ; Mon, 22 Sep 2003 09:10:32 -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 12:10:35 -0000 Message-ID: <00ae01c38103$412f26c0$7502a8c0@hdsc.com> Reply-To: "Kumar" From: "Kumar" To: "\"Richard Huxton\"" , "\"psql\"" Subject: Fw: Backup error - Pls help Date: Mon, 22 Sep 2003 17:45:42 +0530 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit 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/248 X-Sequence-Number: 15226 Dear Friend, I understood what you are saying. But could you pls tell me how to change the path of the pg_dump so that it should point to /usr/local/pgsql/bin/pg_dump Please help ----- Original Message ----- From: "Kumar" To: "Richard Huxton" ; "psql" Sent: Monday, September 22, 2003 5:16 PM Subject: Re: [SQL] Backup error - Pls help > While I issue > which pg_dump it is showed me > /usr/local/pg_dump > > But how to run the backup utility pg_dump to backup my database. > > ----- Original Message ----- > From: "Richard Huxton" > To: "Kumar" ; "psql" > Sent: Monday, September 22, 2003 3:20 PM > Subject: Re: [SQL] Backup error - Pls help > > > > On Monday 22 September 2003 10:01, Kumar wrote: > > > 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/library/pgsql. > > > > RedHat 7.3 I guess you mean? > > > > > 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 > > > following > > > > > > > > > [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 > > > proceed anyway.) [usr1@Linuxsvr bin]$ pg_dump -h 192.168.2.51 -i -f > > > /home/usr1/prod.sql prod > > > > What directory you are in has nothing to do with which copy of a program > you > > will run. There is a utility called "which" to help you: "which pg_dump". > > Almost certainly what you want to do is: > > /usr/local/pgsql/bin/pg_dump -h ... > > > > You probably want to get a book on unix/linux and read up about the > various > > search paths. > > -- > > Richard Huxton > > Archonet Ltd > From dev@archonet.com Mon Sep 22 12:52:29 2003 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 B46CED1BC59 for ; Mon, 22 Sep 2003 12:52:29 +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 23678-03 for ; Mon, 22 Sep 2003 09:52:01 -0300 (ADT) Received: from anchor-post-31.mail.demon.net (anchor-post-31.mail.demon.net [194.217.242.89]) by svr1.postgresql.org (Postfix) with ESMTP id D3C08D1B54D for ; Mon, 22 Sep 2003 09:51:57 -0300 (ADT) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-31.mail.demon.net with esmtp (Exim 3.35 #1) id 1A1QAb-000JCa-0V; Mon, 22 Sep 2003 13:52:01 +0100 Received: from localhost (localhost.localdomain [127.0.0.1]) by mainbox.archonet.com (Postfix) with ESMTP id 187AF16EB5; Mon, 22 Sep 2003 13:52:00 +0100 (BST) Received: from client17.archonet.com (client17.archonet.com [192.168.1.17]) by mainbox.archonet.com (Postfix) with ESMTP id 733DC169FB; Mon, 22 Sep 2003 13:51:59 +0100 (BST) From: Richard Huxton To: "Kumar" , "\"psql\"" Subject: Re: Fw: Backup error - Pls help Date: Mon, 22 Sep 2003 13:51:59 +0100 User-Agent: KMail/1.5 References: <00ae01c38103$412f26c0$7502a8c0@hdsc.com> In-Reply-To: <00ae01c38103$412f26c0$7502a8c0@hdsc.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200309221351.59600.dev@archonet.com> X-Virus-Scanned: by AMaViS snapshot-20020531 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/249 X-Sequence-Number: 15227 On Monday 22 September 2003 13:15, Kumar wrote: > Dear Friend, > I understood what you are saying. But could you pls tell me how to change > the path of the pg_dump so that it should point to > /usr/local/pgsql/bin/pg_dump There's a guide on the Linux Documentation Project here: http://www.tldp.org/HOWTO/Path.html but it might not be RedHat specific (if that's what you are running). You probably want to look at /etc/profile - this should be where your path is set. It also runs all the files in /etc/profile.d/ (on RedHat) Perhaps the best method, if you want to keep both versions of PG is to rename the "wrong" pg_dump to pg_dump.alt and then you can do (as root) # cd /usr/bin # ln -s ../local/pgsql/bin/pg_dump This will create a link from /usr/bin/pg_dump to /usr/local/pgsql/bin/pg_dump which should make it your default. You can still run the old version as pg_dump.alt - this should help to ensure you know which one you are running. HTH -- Richard Huxton Archonet Ltd