#============================================================ # 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 #------------------------------------------------------------ miami7 8001 8101 # # replicate2.postgres.jp # 8002 # 8102 # # # replicate3.postgres.jp # 8003 # 8103 # #------------------------------------------------------------- # 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 #------------------------------------------------------------- miami6 7001 /usr/bin/rsync ssh -1 yes /usr/bin/pg_dump read_only 1min 3s 11s #------------------------------------------------------------- # set partitional replicate control information # set DB name and Table name to stop reprication # o DB_Name : DB name # o Table_Name : table name #------------------------------------------------------------- # # test_db # log_table #