Hallo allerseits,
Ich habe auf zwei host pgcluster installiert, kann auch alles starten sobald ich aber was machen will erhalte ich “PGRreplication failed”.
Fragen:
- Ist es richtig dass die cluster.conf auf beiden Rechnern identisch sein muss ?
- Wie kann ich den Fehler weiter eingrenzen ?
Setup:
pgclusterdb1 -> pglb, pgclusterdb1, pgrepl1
pgclusterdb2 -> pgclusterdb2, pgrepl2
Configfiles:
pgclusterdb1
cluster.conf
<Replicate_Server_Info>
<Host_Name> pgrepl1 </Host_Name>
8001
<Recovery_Port> 8101 </Recovery_Port>
</Replicate_Server_Info>
<Host_Name> pgrepl1.pnet.ch </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>
<Rsync_Timeout> 10min </Rsync_Timeout>
<Rsync_Bwlimit> 0KB </Rsync_Bwlimit>
<Pg_Dump_Path> /usr/local/pgsql/bin/pg_dump </Pg_Dump_Path>
<Ping_Path> /bin/ping </Ping_Path>
<When_Stand_Alone> read_only </When_Stand_Alone>
<Replication_Timeout> 1min </Replication_Timeout>
<LifeCheck_Timeout> 3s </LifeCheck_Timeout>
<LifeCheck_Interval> 11s </LifeCheck_Interval>
pgreplicate.conf
<Cluster_Server_Info>
<Host_Name>pgclusterdb1</Host_Name>
5432
<Recovery_Port>7001</Recovery_Port>
</Cluster_Server_Info>
<Cluster_Server_Info>
<Host_Name>pgclusterdb2</Host_Name>
5432
<Recovery_Port>7001</Recovery_Port>
</Cluster_Server_Info>
<loadbalance_server_info>
<host_name>pglb</host_name>
<recovery_port>6001</recovery_port>
</loadbalance_server_info>
<host_name>pgrepl1</host_name>
<replication_port>8001</replication_port>
<recovery_port>8101</recovery_port>
<rlog_port>8301</rlog_port>
<response_mode>normal</response_mode>
<use_replication_log>no</use_replication_log>
pglb.conf
<cluster_server_info>
<host_name>pgclusterdb1</host_name>
5432
<max_connect>32</max_connect>
</cluster_server_info>
<cluster_server_info>
<host_name>pgclusterdb2</host_name>
5432
<max_connect>32</max_connect>
</cluster_server_info>
<host_name>pglb</host_name>
<backend_socket_dir>/tmp</backend_socket_dir>
<receive_port>5433</receive_port>
<recovery_port>6001</recovery_port>
<max_cluster_num>128</max_cluster_num>
<use_connection_pooling>no</use_connection_pooling>
<Log_File_Info>
<File_Name> /var/opt/postgres/pg_log/pglb.log </File_Name>
<File_Size> 1M </File_Size>
3
</Log_File_Info>
pgclusterdb2
cluster.conf
<Replicate_Server_Info>
<Host_Name> pgrepl1 </Host_Name>
8001
<Recovery_Port> 8101 </Recovery_Port>
</Replicate_Server_Info>
<Host_Name> pgrepl2.pnet.ch </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>
<Rsync_Timeout> 10min </Rsync_Timeout>
<Rsync_Bwlimit> 0KB </Rsync_Bwlimit>
<Pg_Dump_Path> /usr/local/pgsql/bin/pg_dump </Pg_Dump_Path>
<Ping_Path> /bin/ping </Ping_Path>
<When_Stand_Alone> read_only </When_Stand_Alone>
<Replication_Timeout> 1min </Replication_Timeout>
<LifeCheck_Timeout> 3s </LifeCheck_Timeout>
<LifeCheck_Interval> 11s </LifeCheck_Interval>
pgreplicate.conf
<Cluster_Server_Info>
<Host_Name>clusterdb1</Host_Name>
5432
<Recovery_Port>7001</Recovery_Port>
</Cluster_Server_Info>
<Cluster_Server_Info>
<Host_Name>clusterdb2</Host_Name>
5432
<Recovery_Port>7001</Recovery_Port>
</Cluster_Server_Info>
<loadbalance_server_info>
<host_name>pglb</host_name>
<recovery_port>6001</recovery_port>
</loadbalance_server_info>
<host_name>pgrepl2</host_name>
<replication_port>8001</replication_port>
<recovery_port>8101</recovery_port>
<rlog_port>8301</rlog_port>
<response_mode>normal</response_mode>
<use_replication_log>no</use_replication_log>
Besten Dank für etwas Licht ins Dunkel…
acki4711