[Pgcluster-general] ERROR: This query is not permitted when all replication servers fell down

[Karsten Nielsen]

That is great. But is it true that I have to run postmaster on the
replicator servers ?

I have one server for load balancer
       two servers for db-clusters
       two servers for replicators

And do they have to have cluster.conf files or not. And what about the
pg_hba.conf does that have to have special enteries for the cluster as
for the db-cluster servers ?

Best regards,
- Karsten Nielsen

On Wed, 30 May 2007 04:05:51 +0100 (BST) (05:05 CEST)
> According to me, your configuration was true. Please
> start postmaster pgreplicate by this command
> $/usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data
> -o "-i" start
> $/usr/local/pgsql/bin/pgreplicate -D
> /usr/local/pgsql/share -l 
> because configuration pgreplicate in replicator server
> is in /usr/local/pgsql/share
> 
> Best regard,
> Dewi Andriyanti
> 
> On Tue, 2007-05-29 at 10:04 +0200, Karsten Nielsen wrote:
> > Hi,
> > 
> > I have this setup.
> > 
> >                 [Load Balancer]
> >            ________/    \________
> >           /                      \
> >  [DB-Cluster1]                   [DB-Cluster2]
> >           \_________    _________/
> >              \      \  /      /
> >               \      \/      /
> >                \     /\     /
> >        [Replicator 1] [Replicator 2]
> > 
> > It is running fine until I test a fall out of Replicator 1. If I turn off replicator 1 the system fails with:
> > ERROR:  This query is not permitted when all replication servers fell down
> > Eventhough that replicator 2 is running.
> > 
> > If I restart postgres on cluster db 1 and 2 then the setup runs again - this is not the way I expect it to run.
> > 
> > I have attached my config files.
> > 
> > 
> > _______________________________________________
> > Pgcluster-general mailing list
> > Pgcluster-general at pgfoundry.org
> > http://pgfoundry.org/mailman/listinfo/pgcluster-general