postgresql安装hotstandby详解Word格式.docx

1、fs.aio-max-nr = 1048576net.ipv4.tcp_timestamps = 0使文件修改生效sysctl -pvi /etc/security/limits.conf* soft nofile 131072* hard nofile 131072* soft nproc 131072* hard nproc 131072* soft core unlimited* hard core unlimited* soft memlock 50000000* hard memlock 500000002 建立数据库用户给两个节点分别创建postgres用户并设置密码mkdir /

2、home/postgreschown -R /home/postgresgroupadd postgresuseradd -u 501 -g postgres -d /home/postgres -s /bin/bash postgrespasswd postgres3 ssh免密钥通信配置两台机器的ssh免密钥登录ssh-keygen -t rsa主机：cat /.ssh/id_rsa.pub /.ssh/authorized_keyschmod go-rwx /.ssh/*cd /.sshscp id_rsa.pub postgres192.168.11.157:/home/postgre

3、s/.ssh/id_rsa.pub1备机：cat id_rsa.pub1authorized_keysscp id_rsa.pub postgres192.168.11.156:/home/postgres/.ssh/id_rsa.pub2cat id_rsa.pub24 安装PT数据库软件安装PG的依赖软件包：zypper install lrzsz sysstat e4fsprogs ntp readline-devel zlib zlib-devel openssl openssl-devel pam-devel libxml2-devel libxslt-devel python-de

4、vel tcl-devel gcc make flex bison创建源码包存储目录mkdir /app/databasemkdir /app/pgsqlchown -R postgres:users /app/databaseusers /app/pgsqlsu - postgrespostgresql必须用postgres 用户安装，安装之前先改变postgresql的将要安装的目录的权限安装PostgreSQLwget https:/ftp.postgresql.org/pub/source/v9.5.3/postgresql-9.5.3.tar.gzcd /app/database t

5、ar zxvf postgresql-9.5.3.tar.gzcd postgresql-9.5.3./configure -prefix=/app/pgsql -with-pgport=5432 -with-perl -with-python -with-openssl -with-pam -without-ldap -with-libxml -with-libxslt -with-blocksize=8 gmake worldgmake install-world主备节点设置相关环境变量（主备节点应该一致）vi /home/postgres/.bash_profileexport PGHO

6、ME=/app/pgsqlexport LD_LIBRARY_PATH=$PGHOME/lib:/lib64:/usr/lib64:/usr/local/lib64:/lib:/usr/lib:/usr/local/lib:$LD_LIBRARY_PATHexport DATE=date +%Y%m%d%H%Mexport PATH=$PGHOME/bin:$PATH:.export MANPATH=$PGHOME/share/man:$MANPATH备机安装pg_standby进入编译后的/postgresql-9.5.3/contrib./pg_standby目录，执行以下命令make i

7、nstall这时便安装好pg_standby。5 主机应用配置主机初始化数据库mkdir -pv /app/DBusers /app/DBcd /app/pgsql/bin./initdb -D /app/DB 备库（postgres用户安装 备节点只需要安装软件，不需要init数据库）配置监听地址和端口：vi postgresql.conflisten_addresses = *port = 5432wal_level = hot_standbymax_wal_senders = 1允许远程连接：vi pg_hba.conf添加host all all 192.168.11.0/24 trusthost replication postgres 127.0.0.1/0 trust主机设定WAL归档vi postgres.conf设定如下参数：archive_mode = onarchive_command = scp %p 192.168.11.157:/app/pgsql/backup/standby_log/%f standby.logrecovery_end_command = rm -f /tmp/pgsql.trigger.5432/tmp目录下创建pgsql.trigger.5432文件，停止备份后会删除该文件防止错误操作7 测试1） 主机登录st