Hi everybody!
I'm currently testing PgCluster-1.5.0rc9.
I have much trouble with deadlocked connections which didn't occur in rc7.
I've got the same settings and app's which I used with rc7.
Deadlocked connections only appear if I use cascaded replication servers!
If I use only one replication server, everything works fine.
I worked around this, using statement timeouts but this is only a work around
for now!
Has anyone any idea how to get cascaded replication servers work properly
(possible A. Mitani)?
Btw:
1. Does pg_ctl reload also reload cluster.conf, so I can dynamically add and
remove replication servers without restarting postgresql?
2. Does anyone know if rlog (User_Replication_Log=yes) is still needed if I use
cascaded replication servers?
Many thanks in advance!
Best regards,
Markus S.
Configuration of server 1 (TVHW-221):
etc/hosts:
127.0.0.1 TVHW-221 localhost.localdomain localhost
192.168.161.222 TVHW-222
pgreplicate.conf:
<Cluster_Server_Info>
<Host_Name>TVHW-221</Host_Name>
<Port>5432</Port>
<Recovery_Port>7101</Recovery_Port>
</Cluster_Server_Info>
<Cluster_Server_Info>
<Host_Name>TVHW-222</Host_Name>
<Port>5432</Port>
<Recovery_Port>7101</Recovery_Port>
</Cluster_Server_Info>
<Replication_Port>8001</Replication_Port>
<Recovery_Port>8101</Recovery_Port>
<RLOG_Port>8301</RLOG_Port>
<Response_Mode>reliable</Response_Mode>
<Use_Replication_Log>yes</Use_Replication_Log>
cluster.conf:
<Replicate_Server_Info>
<Host_Name>TVHW-221</Host_Name>
<Port>8001</Port>
<Recovery_Port>8101</Recovery_Port>
</Replicate_Server_Info>
<Recovery_Port>7101</Recovery_Port>
<Rsync_Path>/usr/bin/rsync</Rsync_Path>
<Rsync_Option>ssh -1</Rsync_Option>
<Rsync_Compress>yes</Rsync_Compress>
<Pg_Dump_Path>/usr/bin/pg_dump</Pg_Dump_Path>
<When_Stand_Alone>read_only</When_Stand_Alone>
Configuration of server 2 (TVHW-222):
etc/hosts:
127.0.0.1 TVHW-222 localhost.localdomain localhost
192.168.161.221 TVHW-221
pgreplicate.conf:
<Cluster_Server_Info>
<Host_Name>TVHW-221</Host_Name>
<Port>5432</Port>
<Recovery_Port>7101</Recovery_Port>
</Cluster_Server_Info>
<Cluster_Server_Info>
<Host_Name>TVHW-222</Host_Name>
<Port>5432</Port>
<Recovery_Port>7101</Recovery_Port>
</Cluster_Server_Info>
<Replicate_Server_Info>
<Host_Name>TVHW-221</Host_Name>
<Port>8001</Port>
<Recovery_Port>8101</Recovery_Port>
</Replicate_Server_Info>
<Replication_Port>8001</Replication_Port>
<Recovery_Port>8101</Recovery_Port>
<RLOG_Port>8301</RLOG_Port>
<Response_Mode>reliable</Response_Mode>
<Use_Replication_Log>yes</Use_Replication_Log>
cluster.conf:
<Replicate_Server_Info>
<Host_Name>TVHW-222</Host_Name>
<Port>8001</Port>
<Recovery_Port>8101</Recovery_Port>
</Replicate_Server_Info>
<Recovery_Port>7101</Recovery_Port>
<Rsync_Path>/usr/bin/rsync</Rsync_Path>
<Rsync_Option>ssh -1</Rsync_Option>
<Rsync_Compress>yes</Rsync_Compress>
<Pg_Dump_Path>/usr/bin/pg_dump</Pg_Dump_Path>
<When_Stand_Alone>read_only</When_Stand_Alone>
__________________________________________________________________________________
Dieses Mail wurde vom Infotech SecureMail Service ueberprueft und fuer sicher
befunden.
Fuer weitere Informationen zu Infotech SecureMail Service waehlen Sie bitte:
www.infotech.at
This email has been scanned by Infotech SecureMail Service and it has been
classified as secure.
For more information on Infotech SecureMail direct your web browser to:
www.infotech.at
|
