Pg_dump version mismatch

Started by Toni Tortosaalmost 18 years ago2 messagesgeneral
Jump to latest
#1Toni Tortosa
ttortosa@obertic.com

Hello,

I'm a newbie in this list.

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?

Thanks

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Toni Tortosa (#1)
Re: Pg_dump version mismatch

Toni Tortosa <ttortosa@obertic.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