pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedproblem in database backup
4+ messages / 3 participants
[nested] [flat]
* problem in database backup
@ 2003-07-31 11:13 vijaykumar M <m_vijaykumar@hotmail.com>
2003-07-31 11:40 ` Re: problem in database backup Tomasz Myrta <jasiek@klaster.net>
2003-07-31 11:59 ` Re: problem in database backup Richard Huxton <dev@archonet.com>
0 siblings, 2 replies; 4+ messages in thread
From: vijaykumar M @ 2003-07-31 11:13 UTC (permalink / raw)
To: 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> 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>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: problem in database backup
2003-07-31 11:13 problem in database backup vijaykumar M <m_vijaykumar@hotmail.com>
@ 2003-07-31 11:40 ` Tomasz Myrta <jasiek@klaster.net>
1 sibling, 0 replies; 4+ messages in thread
From: Tomasz Myrta @ 2003-07-31 11:40 UTC (permalink / raw)
To: vijaykumar M <m_vijaykumar@hotmail.com>; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: problem in database backup
2003-07-31 11:13 problem in database backup vijaykumar M <m_vijaykumar@hotmail.com>
@ 2003-07-31 11:59 ` Richard Huxton <dev@archonet.com>
1 sibling, 0 replies; 4+ messages in thread
From: Richard Huxton @ 2003-07-31 11:59 UTC (permalink / raw)
To: vijaykumar M <m_vijaykumar@hotmail.com>; pgsql-sql
On Thursday 31 July 2003 12:13, vijaykumar M wrote:
*please* don't post HTML only emails to mailing lists
OK - you seem to have two pg_dump - one in /usr/bin/pg_dump and one in
/usr/local/pgsql/bin/pg_dump.
If you type "which pg_dump" as the user who normally does the dump, which one
does it show (probably /usr/bin).
Now do "pg_dump --version" and see what version it is.
My guess is you want the one in /usr/local/... and the one in /usr/bin is from
old RPMs
--
Richard Huxton
Archonet Ltd
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: problem in database backup
@ 2003-07-31 11:59 vijaykumar M <m_vijaykumar@hotmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: vijaykumar M @ 2003-07-31 11:59 UTC (permalink / raw)
To: jasiek@klaster.net; +Cc: pgsql-sql
<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@KLASTER.NET>
<DIV></DIV>>To: vijaykumar M <M_VIJAYKUMAR@HOTMAIL.COM>
<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 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@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>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2003-07-31 11:59 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-07-31 11:13 problem in database backup vijaykumar M <m_vijaykumar@hotmail.com>
2003-07-31 11:40 ` Tomasz Myrta <jasiek@klaster.net>
2003-07-31 11:59 ` Richard Huxton <dev@archonet.com>
2003-07-31 11:59 Re: problem in database backup vijaykumar M <m_vijaykumar@hotmail.com>
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