Re: Pg_dump version mismatch

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Toni Tortosa <ttortosa(at)obertic(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Pg_dump version mismatch
Date: 2008-05-17 00:19:09
Message-ID: 4392.1210983549@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Toni Tortosa <ttortosa(at)obertic(dot)com> writes:
> I'm working with a Debian 4.0 linux server, and I've installed
> postgresql 8.2.6. I didn't update to 8.2.7

> When I try to do a pg_dump to backup my databases, It shows this error:

> pg_dump: server version: 8.2.7; pg_dump version: 8.2.6
> pg_dump: aborting because of version mismatch (Use the -i option to proceed anyway.)

> Once for each table in the database. Is it possible to modify server
> version or pg_dump version. Would work fine if I use -i parameter to
> ignore versions?

This particular combination is safe enough, so if you really can't be
bothered to update your pg_dump to 8.2.7 you could use -i. The -i
switch is pretty dangerous to use in production scripts, though, since
sooner or later it will probably mask a more serious problem.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-05-17 00:25:49 Re: PostgreSQL executing my function too many times during query
Previous Message Adrian Klaver 2008-05-16 23:28:51 Re: writing a function without installing a language