Konfig pgcluster

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

Hallo zusammen,
Es scheint etwas schwierig aktuelle Informationen zu pgcluster aufzutreiben.
Mein Problem wurde durch fehlende Angaben in den config files verursacht.
Diese Seite hat mir weitergeholfen:
http://txrbgy.com/Blog/files/783d4667ac6e47802758252ff06bd116-3.php

acki4711