From: Tomasz Myrta <jasiek@klaster.net>
To: vijaykumar M <m_vijaykumar@hotmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: problem in database backup
Date: Thu, 31 Jul 2003 13:40:45 +0200
Message-ID: <3F29003D.1010703@klaster.net> (raw)
In-Reply-To: <BAY2-F56btA1ZPp5ohC00012e0f@hotmail.com>
References: <BAY2-F56btA1ZPp5ohC00012e0f@hotmail.com>
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
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: jasiek@klaster.net, m_vijaykumar@hotmail.com
Subject: Re: problem in database backup
In-Reply-To: <3F29003D.1010703@klaster.net>
* 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