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
>
>