<html><div style='background-color:'><DIV>
<P>Hi Tomasz Myrta,</P>
<P>Thanks for ur info, u r correct .. after pointing to /usr/bin/pgsql/bin/pg_dump, i'm able to take backup.. </P>
<P>Thank u very much..</P>
<P>With Regards</P>
<P>Vijay</P>
<P><BR><BR> </P></DIV>
<DIV></DIV>>From: Tomasz Myrta <JASIEK(at)KLASTER(dot)NET>
<DIV></DIV>>To: vijaykumar M <M_VIJAYKUMAR(at)HOTMAIL(dot)COM>
<DIV></DIV>>CC: pgsql-sql(at)postgresql(dot)org
<DIV></DIV>>Subject: Re: [SQL] problem in database backup
<DIV></DIV>>Date: Thu, 31 Jul 2003 13:40:45 +0200
<DIV></DIV>>
<DIV></DIV>>Dnia 2003-07-31 13:13, Uytkownik vijaykumar M napisa:
<DIV></DIV>>
<DIV></DIV>>>
<DIV></DIV>>>Hi All,
<DIV></DIV>>>
<DIV></DIV>>>I'm using Postgresql V7.3.3, on that i created one database with
<DIV></DIV>>>name "mydb".
<DIV></DIV>>>
<DIV></DIV>>>* PostgreSQL 7.3.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC)
<DIV></DIV>>>3.2 20020903 (Red Hat Linux 8.0 3.2-7)*
<DIV></DIV>>>
<DIV></DIV>>>While taking a backup of my postgresql database, i'm getting the
<DIV></DIV>>>below error.
<DIV></DIV>>>
<DIV></DIV>>>bash-2.05b$ *pg_dump mydb >mydb.out
<DIV></DIV>>>pg_dump: server version: SAGES/pg_dump.mo; pg_dump version: 7.2.2
<DIV></DIV>>>pg_dump: aborting because of version mismatch (Use the -i option
<DIV></DIV>>>to proceed any
<DIV></DIV>>>================================================================*
<DIV></DIV>>>
<DIV></DIV>>>*bash-2.05b$ pg_dump -i mydb > mydb.out
<DIV></DIV>>>pg_dump: server version: SAGES/pg_dump.mo; pg_dump version: 7.2.2
<DIV></DIV>>>pg_dump: proceeding despite version mismatch
<DIV></DIV>>>pg_dump: query to obtain list of data types failed: ERROR:
<DIV></DIV>>>Attribute "typprtlen" not found
<DIV></DIV>>>==============================================================*
<DIV></DIV>>>
<DIV></DIV>>>After getting these errors, i tried to check the version of pg_dump
<DIV></DIV>>>on my system by using the below command. Here is the result .....
<DIV></DIV>>>
<DIV></DIV>>>*[root(at)sql-linux root]# find / -name pg_dump -print
<DIV></DIV>>>/root/postgresql-7.3.3/src/bin/pg_dump
<DIV></DIV>>>/root/postgresql-7.3.3/src/bin/pg_dump/pg_dump
<DIV></DIV>>>/usr/bin/pg_dump
<DIV></DIV>>>/usr/local/pgsql/bin/pg_dump
<DIV></DIV>>>*
<DIV></DIV>>
<DIV></DIV>>Probably you have both 7.2.2 and 7.3.3 pg_dump versions and PATH
<DIV></DIV>>points to 7.2.2 /usr/bin/pg_dump. Try using
<DIV></DIV>>/usr/local/pgsql/bin/pg_dump
<DIV></DIV>>
<DIV></DIV>>Regards,
<DIV></DIV>>Tomasz Myrta
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV></div><br clear=all><hr>It's all happening @ F1. Feel the thrill! <a href="http://g.msn.com/8HMWENIN/2734??PS=">Race along right here!</a> </html>