Re: unrecognized configuration parameter "synchronize_seqscans"

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Mikel Lindsaar" <raasdnil(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: unrecognized configuration parameter "synchronize_seqscans"
Date: 2008-06-04 14:28:29
Message-ID: 24355.1212589709@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Mikel Lindsaar" <raasdnil(at)gmail(dot)com> writes:
> I am trying to set up a pg_dump between a postgresql 8.3.1 server and edb
> 8.3 server.

> When I do:
> pg_dump -s -U testmaster -h 10.0.0.1 -p 5444 testuser | psql -U postgres -h
> localhost testslave

> I get:
> 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

Hmm, apparently the source isn't *really* 8.3 ... but it must claim to
be, else pg_dump wouldn't try to send it that command. I think you're
confused about the version situation, and you've probably also got some
messy combination of stock PG server and edb-customized pg_dump, or
perhaps vice versa. You're going to have to go ask them for help if
you can't get it sorted by triple-checking the versions.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2008-06-04 14:45:35 Re: Create Index Performance Issue
Previous Message Marcin Kasperski 2008-06-04 11:57:33 Is it possible to convert WAL's between architectures?