Re: version number between pgdump and server

Laurent ROCHE <laurent_roche(at)yahoo(dot)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) only a 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