Leonardo =?iso-8859-1?Q?M=2E_Ram=E9?= <l.rame@xxxxxxxxxxx> writes: > I'm trying to migrate a PostgreSql 8.3 database from a Windows 2003 > server to a PostgreSql 8.4 Linux x86_64 server running Ubuntu Server > 12.04. > When running pg_dump from the Linux server, I get: > postgres@ubuntupostgresql:~$ pg_dump -h 192.168.10.105 -U postgres ris > pg_dump: SQL command failed > pg_dump: Error message from server: ERROR: unrecognized configuration parameter "synchronize_seqscans" > pg_dump: The command was: SET synchronize_seqscans TO off An 8.3 server certainly ought to accept that command. > I've read in older mails that this massage shows when one side is > running EnterpriseDB version of PostgreSql and the other is running a > PostgreSql version. I must point out this is not my case, both sides are > running PostgreSql versions, the Linux side is running the one from the > official repository, and the Windows one is running an old 8.3 version > downloaded from postgresql.org. What "old 8.3 version" is that? A pre-release snapshot perhaps? After looking through the commit history, it appears that this setting was exposed post-beta, which means your results would fit with running an 8.3 beta or RC release. Leaving aside the wisdom of still being on a beta release four years later, my advice would be to dump with the pg_dump that came with the beta release. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
