Thread: How to upgrade the pgsql archiver?

How to upgrade the pgsql archiver?

From
"Xueying (Libby) SHEN"
Date:
Hi, I installed PostgreSQL 7.2.1 on my Linux machine and I am exploring
the features. When I use pg_dump to backup my database, I get
the error message below:
=======================================================================
Database version: PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC
2.96
Archiver(db) version: 7.1.3
Aborting because of version mismatch.
Use --ignore-version if you think it's safe to proceed anyway.
========================================================================

This is my first time to install the system and I don't have any 7.1.3
on my system. Does anyone know whether this is safe to just ignore the
message and proceed, or I should upgrade my archiver? If I need an
upgrade, when I can find the package and what is the procedure? Thanks a
lot!

--
Libby


Re: How to upgrade the pgsql archiver?

From
Tom Lane
Date:
"Xueying (Libby) SHEN" <xshen@cs.umass.edu> writes:
> Hi, I installed PostgreSQL 7.2.1 on my Linux machine and I am exploring
> the features. When I use pg_dump to backup my database, I get
> the error message below:
> =======================================================================
> Database version: PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC
> 2.96
> Archiver(db) version: 7.1.3
> Aborting because of version mismatch.
> Use --ignore-version if you think it's safe to proceed anyway.
> ========================================================================

> This is my first time to install the system and I don't have any 7.1.3
> on my system.

Yes you do: clearly you are invoking the pg_dump from it.

Most likely the Linux installation included a set of 7.1.3 PG executables,
and that set is in your search path ahead of whereever you put 7.2.
Check your PATH.

            regards, tom lane