<div style="background-color:"><div><p>Hi Tomasz Myrta,<p>Thanks for ur info, u r correct .. after pointing to
/usr/bin/pgsql/bin/pg_dump,i'm able to take backup.. <p>Thank u very much..<p>With Regards<p>Vijay<p><br /><br
/> </div><div></div>>From:Tomasz Myrta <div></div>>To: vijaykumar M <div></div>>CC: pgsql-sql@postgresql.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, U�ytkownik vijaykumar M napisa�: <div></div>>
<div></div>>><div></div>>>Hi All, <div></div>>> <div></div>>>I'm using Postgresql V7.3.3, on
thati created one database with <div></div>>>name "mydb". <div></div>>> <div></div>>>* PostgreSQL
7.3.3on 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>>>belowerror. <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:
abortingbecause 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"
notfound <div></div>>>==============================================================* <div></div>>>
<div></div>>>Aftergetting these errors, i tried to check the version of pg_dump <div></div>>>on my system
byusing the below command. Here is the result ..... <div></div>>> <div></div>>>*[root@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
both7.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=">Racealong right here!</a>
