Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 57AC92E00CC for ; Wed, 4 Jun 2008 03:40:04 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 44138-03 for ; Wed, 4 Jun 2008 03:39:59 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from rv-out-0506.google.com (rv-out-0506.google.com [209.85.198.233]) by developer.postgresql.org (Postfix) with ESMTP id C3F872E002D for ; Wed, 4 Jun 2008 03:40:00 -0300 (ADT) Received: by rv-out-0506.google.com with SMTP id b25so2102440rvf.43 for ; Tue, 03 Jun 2008 23:39:59 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; bh=bVkAchKQ6fJKr/fTWmHSA8d98MJNkpCW6/V4OyU9LWM=; b=DrGznluvELLp/PfVRrVlzqplhKpnS/uWe8wG8dJ723fg0c4zhV++eXfEdkjI36y7lUUnXUFZIYSQyHbDsM9Ekt4SDfwzGBMlH0oL4YpLGew8l7q/0XyE5+FN/zInefOIFKOS0JCfVuVYSX1gEn7BZVOXIkT45Eqirbo2mPe2ZIA= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type; b=oeZbSy8szhJ9B25uKwk+iMKoodH2ecRpN7Zv9duU6NLtdGcca9rixNqQZiW982JLpEtEjO9cx3AENzQFn5DDJjz7mDNuIAIKoMLx199pURG5jEtMYLW/nc19hBPuac0JjiaBbUOF1eftzRhdJRvn9v+a76i6uFZMdJMg59epynw= Received: by 10.143.165.13 with SMTP id s13mr4515432wfo.69.1212561599786; Tue, 03 Jun 2008 23:39:59 -0700 (PDT) Received: by 10.142.222.13 with HTTP; Tue, 3 Jun 2008 23:39:59 -0700 (PDT) Message-ID: <57a815bf0806032339x66c24b3ah567f03ad03b62665@mail.gmail.com> Date: Wed, 4 Jun 2008 16:39:59 +1000 From: "Mikel Lindsaar" To: pgsql-admin@postgresql.org Subject: unrecognized configuration parameter "synchronize_seqscans" MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1278_29114923.1212561599739" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=AWL=-0.001, HTML_MESSAGE=0.001, NORMAL_HTTP_TO_IP=0.001 X-Spam-Level: X-Archive-Number: 200806/22 X-Sequence-Number: 29360 ------=_Part_1278_29114923.1212561599739 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 ------=_Part_1278_29114923.1212561599739 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 


------=_Part_1278_29114923.1212561599739--