PgSQL使用Bucardo进行主从同步
准备工作
安装依赖包(按顺序)
# yum install perl-boolean
# yum install postgresql-plperl
# wget http://files.directadmin.com/services/9.0/ExtUtils-MakeMaker-6.31.tar.gz
# wget http://search.cpan.org/CPAN/authors/id/E/EX/EXODIST/Test-Simple-1.302125.tar.gz
# wget http://search.cpan.org/CPAN/authors/id/J/JP/JPEACOCK/version-0.9918.tar.gz
# wget http://www.cpan.org/authors/id/T/TU/TURNSTEP/DBD-Pg-3.5.0.tar.gz
# wget http://search.cpan.org/CPAN/authors/id/T/TI/TIMB/DBI-1.630.tar.gz
# wget http://bucardo.org/downloads/dbix_safe.tar.gz 安装Bucardo
# wget http://bucardo.org/downloads/Bucardo-5.4.1.tar.gz以上perl模块安装步骤
# tar xvf (...)
# cd (...)
# perl Makefile.PL
# make
# make install配置
创建配置文件
在系统用户的home目录下创建.bucardorc文件，内容如下：
log_conflict_file = /home/devops/bucardo/log/bucardo_conflict.log
piddir = /home/devops/bucardo/run
reason_file = /home/devops/bucardo/log/bucardo.restart.reason.log
warning_file = /home/devops/bucardo/log/bucardo.warning.log
syslog_facility = LOG_LOCAL
运行bucardo install（/user/local/bin）
安装perl模块过程中报错解决
出现Could not open ‘’: No such file or directory at lib/ExtUtils/MM_Unix.pm
# yum install perl-ExtUtils-MakeMaker出现Can’t locate Data/Dumper.pm in @INC
# yum install ‘perl(Data::Dumper)’