pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: vijaykumar M <m_vijaykumar@hotmail.com>
To: jasiek@klaster.net
Cc: pgsql-sql@postgresql.org
Subject: Re: problem in database backup
Date: Thu, 31 Jul 2003 11:59:36 +0000
Message-ID: <BAY2-F1493RNpggkzpB00012fe3@hotmail.com> (raw)

<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>&nbsp;</P></DIV>
<DIV></DIV>&gt;From: Tomasz Myrta <JASIEK@KLASTER.NET>
<DIV></DIV>&gt;To: vijaykumar M <M_VIJAYKUMAR@HOTMAIL.COM>
<DIV></DIV>&gt;CC: pgsql-sql@postgresql.org 
<DIV></DIV>&gt;Subject: Re: [SQL] problem in database backup 
<DIV></DIV>&gt;Date: Thu, 31 Jul 2003 13:40:45 +0200 
<DIV></DIV>&gt; 
<DIV></DIV>&gt;Dnia 2003-07-31 13:13, U¿ytkownik vijaykumar M napisa³: 
<DIV></DIV>&gt; 
<DIV></DIV>&gt;&gt; 
<DIV></DIV>&gt;&gt;Hi All, 
<DIV></DIV>&gt;&gt; 
<DIV></DIV>&gt;&gt;I'm using Postgresql V7.3.3, on that i created one database with 
<DIV></DIV>&gt;&gt;name "mydb". 
<DIV></DIV>&gt;&gt; 
<DIV></DIV>&gt;&gt;* PostgreSQL 7.3.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 
<DIV></DIV>&gt;&gt;3.2 20020903 (Red Hat Linux 8.0 3.2-7)* 
<DIV></DIV>&gt;&gt; 
<DIV></DIV>&gt;&gt;While taking a backup of my postgresql database, i'm getting the 
<DIV></DIV>&gt;&gt;below error. 
<DIV></DIV>&gt;&gt; 
<DIV></DIV>&gt;&gt;bash-2.05b$ *pg_dump mydb &gt;mydb.out 
<DIV></DIV>&gt;&gt;pg_dump: server version: SAGES/pg_dump.mo; pg_dump version: 7.2.2 
<DIV></DIV>&gt;&gt;pg_dump: aborting because of version mismatch (Use the -i option 
<DIV></DIV>&gt;&gt;to proceed any 
<DIV></DIV>&gt;&gt;================================================================* 
<DIV></DIV>&gt;&gt; 
<DIV></DIV>&gt;&gt;*bash-2.05b$ pg_dump -i mydb &gt; mydb.out 
<DIV></DIV>&gt;&gt;pg_dump: server version: SAGES/pg_dump.mo; pg_dump version: 7.2.2 
<DIV></DIV>&gt;&gt;pg_dump: proceeding despite version mismatch 
<DIV></DIV>&gt;&gt;pg_dump: query to obtain list of data types failed: ERROR: 
<DIV></DIV>&gt;&gt;Attribute "typprtlen" not found 
<DIV></DIV>&gt;&gt;==============================================================* 
<DIV></DIV>&gt;&gt; 
<DIV></DIV>&gt;&gt;After getting these errors, i tried to check the version of pg_dump 
<DIV></DIV>&gt;&gt;on my system by using the below command. Here is the result ..... 
<DIV></DIV>&gt;&gt; 
<DIV></DIV>&gt;&gt;*[root@sql-linux root]# find / -name pg_dump -print 
<DIV></DIV>&gt;&gt;/root/postgresql-7.3.3/src/bin/pg_dump 
<DIV></DIV>&gt;&gt;/root/postgresql-7.3.3/src/bin/pg_dump/pg_dump 
<DIV></DIV>&gt;&gt;/usr/bin/pg_dump 
<DIV></DIV>&gt;&gt;/usr/local/pgsql/bin/pg_dump 
<DIV></DIV>&gt;&gt;* 
<DIV></DIV>&gt; 
<DIV></DIV>&gt;Probably you have both 7.2.2 and 7.3.3 pg_dump versions and PATH 
<DIV></DIV>&gt;points to 7.2.2 /usr/bin/pg_dump. Try using 
<DIV></DIV>&gt;/usr/local/pgsql/bin/pg_dump 
<DIV></DIV>&gt; 
<DIV></DIV>&gt;Regards, 
<DIV></DIV>&gt;Tomasz Myrta 
<DIV></DIV>&gt; 
<DIV></DIV>&gt; 
<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>

view thread (4+ messages)  latest in thread

Message-ID: <BAY2-F1493RNpggkzpB00012fe3@hotmail.com>
Permalink:  ../BAY2-F1493RNpggkzpB00012fe3@hotmail.com/
Also on:    postgresql.org/message-id/BAY2-F1493RNpggkzpB00012fe3@hotmail.com

copy link · copy postgr.es

reply

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, jasiek@klaster.net
  Subject: Re: problem in database backup
  In-Reply-To: <BAY2-F1493RNpggkzpB00012fe3@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