postgresql安装hot_standby.docx

Postgresql （主从）hot_standby安装说明一、搭建PT备份数据库配置环境变量vi /etc/sysctl.confkernel.shmmni = 4096kernel.sem = 5010050100 1280fs.file-max = 7672460net.ipv4.ip_local_port_range = 9000 65000net.core.rmem_default = 1048576net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048576net.ipv4.tcp_tw_recycle = 1net.ipv4.tcp_max_syn_backlog = 4096dev_max_backlog = 10000vm.overcommit_memory = 0net.ipv4.ip_conntrack_max = 655360fs.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 hard memlock立数据库用户给两个节点分别创建postgres用户并设置密码mkdir /home/postgreschown -R /home/postgresgroupaddpostgresuseradd -u 501 -g postgres -d /home/postgres -s /bin/bash postgrespasswdpostgresssh免密钥通信配置两台机器的ssh免密钥登录ssh-keygen -t rsa主机：cat ~/.ssh/id_rsa.pub ~/.ssh/authorized_keyschmod go-rwx ~/.ssh/*cd ~/.sshscp id_rsa.pub postgres@57:/home/postgres/.ssh/id_rsa.pub1备机：cd ~/.sshcat id_rsa.pub1authorized_keyschmod go-rwx ~/.ssh/*scp id_rsa.pubpostgres@56:/home/postgres/.ssh/id_rsa.pub2主机：cat id_rsa.pub2authorized_keys备机：cat id_rsa.pub1authorized_keys安装PT数据库软件安装PG的依赖软件包：zypper install lrzsz sysstat e4fsprogs ntp readline-devel zlib zlib-devel openssl openssl-devel pam-devel libxml2-devel libxslt-devel python-devel tcl-devel gcc make flex bison创建源码包存储目录mkdir /app/databasemkdir /app/pgsqlchown -R postgres:users /app/databasechown -R postgres:users /app/pgsqlsu - postgrespostgresql必须用postgres 用户安装，安装之前先改变postgresql的将要安装的目录的权限安装PostgreSQLwget/pub/source/v9.5.3/postgresql-9.5.3.tar.gzcd /app/database tar zxvf postgresql-9.5.3.tar.gzcdpostgresql-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=8gmake worldgmake install-world主备节点设置相关环境变量(主备节点应该一致)vi /home/postgres/.bash_profileexport PGHOM