From m_vijaykumar@hotmail.com Thu Jul 31 11:13:44 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 5287BD1C50C for ; Thu, 31 Jul 2003 11:13: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 37480-09 for ; Thu, 31 Jul 2003 08:12:42 -0300 (ADT) Received: from hotmail.com (bay2-f56.bay2.hotmail.com [65.54.247.56]) by svr1.postgresql.org (Postfix) with ESMTP id EBFF7D1C4D7 for ; Thu, 31 Jul 2003 08:13:40 -0300 (ADT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Thu, 31 Jul 2003 04:13:43 -0700 Received: from 202.63.107.19 by by2fd.bay2.hotmail.msn.com with HTTP; Thu, 31 Jul 2003 11:13:43 GMT X-Originating-IP: [202.63.107.19] X-Originating-Email: [m_vijaykumar@hotmail.com] From: "vijaykumar M" To: pgsql-sql@postgresql.org Subject: problem in database backup Date: Thu, 31 Jul 2003 11:13:43 +0000 Mime-Version: 1.0 Content-Type: text/html Message-ID: X-OriginalArrivalTime: 31 Jul 2003 11:13:43.0509 (UTC) FILETIME=[CD9E7850:01C35754] X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/484 X-Sequence-Number: 14598


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

============================================================

Kindly guide me to solve this problem. ..

Thanks in advance,

With Regards,

Vijay

 

 

 

 

 


It's all happening @ F1. Feel the thrill! Race along right here! From jasiek@klaster.net Thu Jul 31 11:40:27 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 E7596D1C513 for ; 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 ; 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 ; 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 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 Cc: pgsql-sql@postgresql.org Subject: Re: problem in database backup References: In-Reply-To: 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 From m_vijaykumar@hotmail.com Thu Jul 31 11:59:36 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 2E7EFD1C7F5 for ; Thu, 31 Jul 2003 11:59:36 +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 44409-06 for ; Thu, 31 Jul 2003 08:58:34 -0300 (ADT) Received: from hotmail.com (bay2-f149.bay2.hotmail.com [65.54.247.149]) by svr1.postgresql.org (Postfix) with ESMTP id DEA7CD1C7F4 for ; Thu, 31 Jul 2003 08:59:33 -0300 (ADT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Thu, 31 Jul 2003 04:59:36 -0700 Received: from 202.63.107.19 by by2fd.bay2.hotmail.msn.com with HTTP; Thu, 31 Jul 2003 11:59:36 GMT X-Originating-IP: [202.63.107.19] X-Originating-Email: [m_vijaykumar@hotmail.com] From: "vijaykumar M" To: jasiek@klaster.net Cc: pgsql-sql@postgresql.org Subject: Re: problem in database backup Date: Thu, 31 Jul 2003 11:59:36 +0000 Mime-Version: 1.0 Content-Type: text/html Message-ID: X-OriginalArrivalTime: 31 Jul 2003 11:59:36.0904 (UTC) FILETIME=[36C53480:01C3575B] X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/486 X-Sequence-Number: 14600

Hi Tomasz Myrta,

Thanks for ur info, u r correct .. after pointing to /usr/bin/pgsql/bin/pg_dump, i'm able to take backup..

Thank u very much..

With Regards

Vijay



 

>From: Tomasz Myrta
>To: vijaykumar M
>CC: pgsql-sql@postgresql.org
>Subject: Re: [SQL] problem in database backup
>Date: Thu, 31 Jul 2003 13:40:45 +0200
>
>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
>
>

It's all happening @ F1. Feel the thrill! Race along right here! From dev@archonet.com Thu Jul 31 12:00:02 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 653F7D1C50C for ; Thu, 31 Jul 2003 12:00:02 +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 44402-07 for ; Thu, 31 Jul 2003 08:59:00 -0300 (ADT) Received: from anchor-post-39.mail.demon.net (anchor-post-39.mail.demon.net [194.217.242.80]) by svr1.postgresql.org (Postfix) with ESMTP id 94433D1C515 for ; Thu, 31 Jul 2003 08:59:58 -0300 (ADT) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-39.mail.demon.net with esmtp (Exim 3.36 #2) id 19iC6D-0002nj-0U; Thu, 31 Jul 2003 13:00:01 +0100 Received: from localhost (localhost.localdomain [127.0.0.1]) by mainbox.archonet.com (Postfix) with ESMTP id E2FDA1663F; Thu, 31 Jul 2003 12:59:59 +0100 (BST) Received: from client17.archonet.com (client17.archonet.com [192.168.1.17]) by mainbox.archonet.com (Postfix) with ESMTP id 32E101663E; Thu, 31 Jul 2003 12:59:59 +0100 (BST) From: Richard Huxton To: "vijaykumar M" , pgsql-sql@postgresql.org Subject: Re: problem in database backup Date: Thu, 31 Jul 2003 12:59:58 +0100 User-Agent: KMail/1.5 References: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200307311259.58296.dev@archonet.com> X-Virus-Scanned: by AMaViS snapshot-20020531 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/487 X-Sequence-Number: 14601 On Thursday 31 July 2003 12:13, vijaykumar M wrote: *please* don't post HTML only emails to mailing lists OK - you seem to have two pg_dump - one in /usr/bin/pg_dump and one in /usr/local/pgsql/bin/pg_dump. If you type "which pg_dump" as the user who normally does the dump, which one does it show (probably /usr/bin). Now do "pg_dump --version" and see what version it is. My guess is you want the one in /usr/local/... and the one in /usr/bin is from old RPMs -- Richard Huxton Archonet Ltd