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