pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
unrecognized configuration parameter "synchronize_seqscans" 2+ messages / 2 participants [nested] [flat]
* unrecognized configuration parameter "synchronize_seqscans" @ 2008-06-04 06:39 Mikel Lindsaar <raasdnil@gmail.com> 0 siblings, 1 reply; 2+ messages in thread From: Mikel Lindsaar @ 2008-06-04 06:39 UTC (permalink / raw) To: pgsql-admin 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: unrecognized configuration parameter "synchronize_seqscans" @ 2008-06-04 14:28 Tom Lane <tgl@sss.pgh.pa.us> parent: Mikel Lindsaar <raasdnil@gmail.com> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2008-06-04 14:28 UTC (permalink / raw) To: Mikel Lindsaar <raasdnil@gmail.com>; +Cc: pgsql-admin "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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-06-04 14:28 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2008-06-04 06:39 unrecognized configuration parameter "synchronize_seqscans" Mikel Lindsaar <raasdnil@gmail.com> 2008-06-04 14:28 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox