X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 610AFD1DA57 for ; Sun, 18 Apr 2004 03:52:57 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 47592-07 for ; Sun, 18 Apr 2004 03:52:57 -0300 (ADT) Received: from vscan01.westnet.com.au (vscan01.westnet.com.au [203.10.1.131]) by svr1.postgresql.org (Postfix) with ESMTP id 98A86D1C515 for ; Sun, 18 Apr 2004 03:52:54 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by localhost (Postfix) with ESMTP id 490D152FAE for ; Sun, 18 Apr 2004 14:52:53 +0800 (WST) Received: from bart.graham.fdns.net (dsl-202-72-174-99.wa.westnet.com.au [202.72.174.99]) by vscan01.westnet.com.au (Postfix) with ESMTP id 059E051BDE for ; Sun, 18 Apr 2004 14:52:52 +0800 (WST) Subject: Anyone using pgreplicator? From: Alan Graham To: pgsql-admin@postgresql.org Content-Type: text/plain Message-Id: <1082271170.2884.2.camel@bart.graham.fdns.net> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.4-8mdk Date: Sun, 18 Apr 2004 14:52:50 +0800 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/241 X-Sequence-Number: 13214 Apologies if this is off topic, but I've tried the pgreplicator forums, and they appear to be dormant. I've also tried the general list.. I'm trying to get a multi master replication app running, I thought I was doing well, I've got past all of the problems mentioned on the pgreplicator forums and (checking the archives) on this list, ie, tcl installed ok, script changes for postgresql 7.3.4 in, communications using scp as user replicator working... Everything in fact works. Except that it doesn't actually replicate. When I synchronise. I can see the traffic going between the sites. I can see the record being replicated appearing on the flow table, I can see it on the history file on both the source and the destination, so it's reaching the destination. There is no sign of any error in any of the pgreplicator logs or the system logs. I've even started postgresql in debug log mode and tailed the log while started the replicator on the remote site. I see the communications come in, and see the commands being entered. But the data isn't being changed on the destination. Any pgreplicator users out there seen this sort of thing before? Any suggestions as to debug options, extra logging, etc, I can try? I thought it might be a permissions issue, but all users have full access. The replicator user can make the changes by submitting an SQL update. pgreplicator has a 'rejected sql' log file, but that's empty. I'm at my wits end... Regards -- Alan Graham