Обсуждение: unrecognized configuration parameter "synchronize_seqscans"
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
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
"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