Обсуждение: problem in database backup

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

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