Обсуждение: unrecognized configuration parameter "synchronize_seqscans"

Поиск
Список
Период
Сортировка

unrecognized configuration parameter "synchronize_seqscans"

От
"Mikel Lindsaar"
Дата:
Hey all, I posted this over on the EDB forums as well, no answers yet, so I am trying here.

I am trying to set up a pg_dump between a postgresql 8.3.1 server and edb 8.3 server. 

This is to get slony working between the two. 

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 

Any ideas on how to get around this?  - Maybe manually doing the dump command with psql?

Thanks 

Mikel 

Re: unrecognized configuration parameter "synchronize_seqscans"

От
Tom Lane
Дата:
"Mikel Lindsaar" <raasdnil@gmail.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