[Pgcluster-general] Pgcluster-general Digest, Vol 28, Issue 18
dewi andriyanti
emailq_stis at yahoo.com
Wed May 30 03:05:51 UTC 2007
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
--- pgcluster-general-request at pgfoundry.org wrote:
> Send Pgcluster-general mailing list submissions to
> pgcluster-general at pgfoundry.org
>
> To subscribe or unsubscribe via the World Wide Web,
> visit
>
>
http://pgfoundry.org/mailman/listinfo/pgcluster-general
> or, via email, send a message with subject or body
> 'help' to
> pgcluster-general-request at pgfoundry.org
>
> You can reach the person managing the list at
> pgcluster-general-owner at pgfoundry.org
>
> When replying, please edit your Subject line so it
> is more specific
> than "Re: Contents of Pgcluster-general digest..."
>
>
> Today's Topics:
>
> 1. ERROR: This query is not permitted when all
> replication
> servers fell down (Karsten Nielsen)
>
>
>
----------------------------------------------------------------------
>
> Message: 1
> Date: Tue, 29 May 2007 10:04:48 +0200
> From: Karsten Nielsen <karsten at wwi.dk>
> Subject: [Pgcluster-general] ERROR: This query is
> not permitted when
> all replication servers fell down
> To: pgcluster-general at pgfoundry.org
> Message-ID: <1180425888.4515.17.camel at k-man>
> Content-Type: text/plain; charset="us-ascii"
>
> 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.
>
>
> -------------- next part --------------
>
#============================================================
> # Cluster DB Server configuration file
>
#------------------------------------------------------------
> # file: cluster.conf
>
#------------------------------------------------------------
> # This file controls:
> # o which hosts & port are replication server
> # o which port use for replication request to
> replication server
> # o which command use for recovery function
>
#============================================================
>
#------------------------------------------------------------
> # set Replication Server information
> # o Host_Name : hostname
> # o Port : connection for postmaster
> # o Recovery_Port : connection for recovery process
>
#------------------------------------------------------------
> <Replicate_Server_Info>
> <Host_Name> maildb-rp01.wwi.local </Host_Name>
> <Port> 8001 </Port>
> <Recovery_Port> 8101 </Recovery_Port>
> </Replicate_Server_Info>
> <Replicate_Server_Info>
> <Host_Name> maildb-rp02.wwi.local </Host_Name>
> <Port> 8001 </Port>
> <Recovery_Port> 8101 </Recovery_Port>
> </Replicate_Server_Info>
> #<Replicate_Server_Info>
> # <Host_Name> replicate3.postgres.jp </Host_Name>
> # <Port> 8003 </Port>
> # <Recovery_Port> 8103 </Recovery_Port>
> #</Replicate_Server_Info>
>
#-------------------------------------------------------------
> # set Cluster DB Server information
> # o Host_Name : host name which connect with
> replication server
> # o Recovery_Port : connection for recovery
> # o Rsync_Path : path of rsync command
> # o Rsync_Option : file transfer option for rsync
> # o Rsync_Compress : use compression option for
> rsync
> # [yes/no]. default : yes
> # o Pg_Dump_Path : path of pg_dump
> # o When_Stand_Alone : When all replication
> servers fell,
> # you can set up two
> kinds of permittion,
> # "real_only" or
> "read_write".
> # o Replication_Timeout : timeout of each
> replication request
> # o Lifecheck_Timeout : timeout of the lifecheck
> response
> # o Lifecheck_Interval : interval time of the
> lifecheck
> # (range 1s - 1h)
> # 10s -- 10 seconds
> # 10min -- 10 minutes
> # 1h -- 1 hours
>
#-------------------------------------------------------------
> <Host_Name> maildb01.wwi.local </Host_Name>
> <Recovery_Port> 7001 </Recovery_Port>
> <Rsync_Path> /usr/bin/rsync </Rsync_Path>
> <Rsync_Option> ssh -1 </Rsync_Option>
> <Rsync_Compress> yes </Rsync_Compress>
> <Pg_Dump_Path> /usr/local/pgsql/bin/pg_dump
> </Pg_Dump_Path>
> <When_Stand_Alone> read_only </When_Stand_Alone>
> <Replication_Timeout> 30s </Replication_Timeout>
> <LifeCheck_Timeout> 3s </LifeCheck_Timeout>
> <LifeCheck_Interval> 3s </LifeCheck_Interval>
>
#-------------------------------------------------------------
> # set partitional replicate control information
> # set DB name and Table name to stop reprication
> # o DB_Name : DB name
> # o Table_Name : table name
>
#-------------------------------------------------------------
> #<Not_Replicate_Info>
> # <DB_Name> test_db </DB_Name>
> # <Table_Name> log_table </Table_Name>
> #</Not_Replicate_Info>
> -------------- next part --------------
>
#============================================================
> # Cluster DB Server configuration file
>
#------------------------------------------------------------
> # file: cluster.conf
>
#------------------------------------------------------------
> # This file controls:
> # o which hosts & port are replication server
> # o which port use for replication request to
> replication server
> # o which command use for recovery function
>
#============================================================
>
#------------------------------------------------------------
> # set Replication Server information
> # o Host_Name : hostname
> # o Port : connection for postmaster
> # o Recovery_Port : connection for recovery process
>
#------------------------------------------------------------
> <Replicate_Server_Info>
> <Host_Name> maildb-rp01.wwi.local </Host_Name>
> <Port> 8001 </Port>
> <Recovery_Port> 8101 </Recovery_Port>
> </Replicate_Server_Info>
> <Replicate_Server_Info>
> <Host_Name> maildb-rp02.wwi.local </Host_Name>
> <Port> 8001 </Port>
> <Recovery_Port> 8101 </Recovery_Port>
> </Replicate_Server_Info>
> #<Replicate_Server_Info>
> # <Host_Name> replicate3.postgres.jp </Host_Name>
> # <Port> 8003 </Port>
> # <Recovery_Port> 8103 </Recovery_Port>
> #</Replicate_Server_Info>
>
#-------------------------------------------------------------
> # set Cluster DB Server information
> # o Host_Name : host name which connect with
> replication server
> # o Recovery_Port : connection for recovery
> # o Rsync_Path : path of rsync command
> # o Rsync_Option : file transfer option for rsync
> # o Rsync_Compress : use compression option for
> rsync
> # [yes/no]. default : yes
> # o Pg_Dump_Path : path of pg_dump
> # o When_Stand_Alone : When all replication
> servers fell,
> # you can set up two
> kinds of permittion,
> # "real_only" or
> "read_write".
> # o Replication_Timeout : timeout of each
> replication request
> # o Lifecheck_Timeout : timeout of the lifecheck
> response
>
=== message truncated ===
Send instant messages to your online friends http://uk.messenger.yahoo.com
More information about the Pgcluster-general
mailing list