From: vijaykumar M <m_vijaykumar@hotmail.com>
To: pgsql-sql@postgresql.org
Subject: problem in database backup
Date: Thu, 31 Jul 2003 11:13:43 +0000
Message-ID: <BAY2-F56btA1ZPp5ohC00012e0f@hotmail.com> (raw)
<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> 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 >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 (Use the -i option to proceed any<BR>================================================================</FONT></STRONG></P>
<P><STRONG><FONT color=#993366>bash-2.05b$ pg_dump -i mydb > 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: Attribute "typprtlen" not found<BR>==============================================================</FONT></STRONG></P>
<P><FONT color=#000033>After getting these</FONT><FONT color=#000033> errors, i tried 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@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> </P>
<P> </P>
<P> </P>
<P> </P>
<P> </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>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: m_vijaykumar@hotmail.com
Subject: Re: problem in database backup
In-Reply-To: <BAY2-F56btA1ZPp5ohC00012e0f@hotmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox