problem in database backup

From: "vijaykumar M" <m_vijaykumar(at)hotmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: problem in database backup
Date: 2003-07-31 11:13:43
Message-ID: BAY2-F56btA1ZPp5ohC00012e0f@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

<html><div style='background-color:'><DIV>
<P><BR>Hi All,</P>
<P>I'm using Postgresql V7.3.3, on that i created one database with name "mydb".</P>
<P><FONT color=#000033><STRONG>&nbsp;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)</STRONG></FONT></P>
<P>While taking a backup of my postgresql database, i'm getting the below error.</P>
<P>bash-2.05b$ <STRONG><FONT color=#993366>pg_dump mydb &gt;mydb.out<BR>pg_dump: server version: SAGES/pg_dump.mo; pg_dump version: 7.2.2<BR>pg_dump: aborting because of version mismatch&nbsp; (Use the -i option to proceed any<BR>================================================================</FONT></STRONG></P>
<P><STRONG><FONT color=#993366>bash-2.05b$ pg_dump -i mydb &gt; mydb.out<BR>pg_dump: server version: SAGES/pg_dump.mo; pg_dump version: 7.2.2<BR>pg_dump: proceeding despite version mismatch<BR>pg_dump: query to obtain list of data types failed: ERROR:&nbsp; Attribute "typprtlen" not found<BR>==============================================================</FONT></STRONG></P>
<P><FONT color=#000033>After getting these</FONT><FONT color=#000033> errors, i tried&nbsp;to check the version of pg_dump on my system by using the below command. Here is the result .....</FONT></P>
<P><STRONG><FONT color=#993366>[root(at)sql-linux root]# find / -name pg_dump -print<BR>/root/postgresql-7.3.3/src/bin/pg_dump<BR>/root/postgresql-7.3.3/src/bin/pg_dump/pg_dump<BR>/usr/bin/pg_dump<BR>/usr/local/pgsql/bin/pg_dump<BR></FONT></STRONG><FONT color=#993366></FONT></P>
<P><FONT color=#993366>============================================================</P></FONT>
<P><FONT color=#000033>Kindly guide me to solve this problem. .. </FONT></P>
<P><FONT color=#000033>Thanks in advance,</FONT></P>
<P><FONT color=#000033>With Regards,</FONT></P>
<P><FONT color=#000033>Vijay</FONT></P>
<P>&nbsp;</P>
<P>&nbsp;</P>
<P>&nbsp;</P>
<P>&nbsp;</P>
<P>&nbsp;</P></DIV></div><br clear=all><hr>It's all happening @ F1. Feel the thrill! <a href="http://g.msn.com/8HMXENIN/2734??PS=">Race along right here!</a> </html>

Attachment Content-Type Size
unknown_filename text/html 2.0 KB

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tomasz Myrta 2003-07-31 11:40:45 Re: problem in database backup
Previous Message Christoph Haller 2003-07-31 09:30:03 Re: Fwd: Bad Join moment - how is this happening?