Re: version number between pgdump and server - Mailing list pgsql-general

Laurent ROCHE <laurent_roche@yahoo.com> writes:
> I get the following message:
> pg_dump.exe -h my_server -p 5432 -U
> postgres -F p -v -f "C:\Projects\table.sql" -t
> "\"public\".\"my_table\"" my_db
> pg_dump: server version: 8.3.3; pg_dump version: 8.3.0
> pg_dump: aborting because of version mismatch  (Use the -i option to proceed anyway.)
> pg_dump: *** aborted because of error

> Will it not be more reasonable to abort only if the first two numbers mismatch but not the last one which is (AFAIK)
onlya patch number and does not change the features ? 

FYI, this has been changed for 8.4.

http://archives.postgresql.org/pgsql-hackers/2008-03/msg01071.php
http://archives.postgresql.org/pgsql-committers/2008-04/msg00157.php

Nonetheless, it'd be a good idea to update your pg_dump.

            regards, tom lane