pg_dump problem

From: Leonardo M(dot) Ramé <l(dot)rame(at)griensu(dot)com>
To: PostgreSql-general <pgsql-general(at)postgresql(dot)org>
Subject: pg_dump problem
Date: 2012-10-05 20:51:37
Message-ID: 20121005205137.GA7642@leonardo-laptop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)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

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.

Any hint?.

Regards,
--
Leonardo M. Ramé
Medical IT - Griensu S.A.
Av. Colón 636 - Piso 8 Of. A
X5000EPT -- Córdoba
Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19
Cel.: +54 9 351 6629292

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2012-10-05 21:30:15 Re: pg_dump problem
Previous Message Wolf Schwurack 2012-10-05 16:01:36 Re: [Pgbouncer-general] Again, problem with pgbouncer