POSTGRESQL10.3源码安装主从搭建

一、下载POSTGRESQL源码安装包及主机配置 https://www.postgresql.org/ftp/source/v10.3/ postgresql-10.3.tar.gz 虚拟机环境 node1  192.168.159.151 node2  192.168.159.152 操作系统为redhat6.5 数据库为postgresql10.3 两个节点均配置/etc/hosts vi /etc/hosts node1  192.168.159.151 node2  192.168.159.152 二、编译安装 （1）创建postgres用户 useradd -m -r -s /bin/bash -u 5432 postgres （2）安装相关依赖包 yum install gettext gcc make perl python perl-ExtUtils-Embed   readline-devel   zlib-devel    openssl-devel   libxml2-devel  cmake  gcc-c++ libxslt-devel  openldap-devel  pam-devel  python-devel  cyrus-sasl-devel  libgcrypt-devel  libgpg-error-devel  libstdc++-devel （3）配置POSTGRES ./configure --prefix=/opt/postgresql-10.3 --with-segsize=8 --with-wal-segsize=64 --with-wal-blocksize=16 --with-blocksize=16 --with-libedit-preferred --with-perl --with-python --with-openssl --with-libxml --with-libxslt --enable-profiling --enable-thread-safety --enable-nls=zh_CN 最后几行出现以下黄色输出即配置正确，否则根据报错提示继续安装依赖包 configure: using CPPFLAGS= -D_GNU_SOURCE -I/usr/include/libxml2  configure: using LDFLAGS=  -Wl,--as-needed configure: creating ./config.status config.status: creating GNUmakefile config.status: creating src/Makefile.global config.status: creating src/include/pg_config.h config.status: creating src/include/pg_config_ext.h config.status: creating src/interfaces/ecpg/include/ecpg_config.h config.status: linking src/backend/port/tas/dummy.s to src/backend/port/tas.s config.status: linking src/backend/port/dynloader/linux.c to src/backend/port/dynloader.c config.status: linking src/backend/port/posix_sema.c to src/backend/port/pg_sema.c config.status: linking src/backend/port/sysv_shmem.c to src/backend/port/pg_shmem.c config.status: linking src/backend/port/dynloader/linux.h to src/include/dynloader.h config.status: linking src/include/port/linux.h to src/include/pg_config_os.h config.status: linking src/makefiles/Makefile.linux to src/Makefile.port （4）编译 make && make install 最后几行出现以下黄色输出即配置正确 make[1]: Leaving directory `/opt/postgresql-10.3/src' make -C config install make[1]: Entering directory `/opt/postgresql-10.3/config' /bin/mkdir -p '/opt/postgresql-10.3/lib/pgxs/config' /usr/bin/install -c -m 755 ./install-sh '/opt/postgresql-10.3/lib/pgxs/config/install-sh' /usr/bin/install -c -m 755 ./missing '/opt/postgresql-10.3/lib/pgxs/config/missing' make[1]: Leaving directory `/opt/postgresql-10.3/config' PostgreSQL installation complete. （5）安装 make world && make install -world 最后几行出现以下黄色输出即配置正确 make[1]: Leaving directory `/opt/postgresql-10.3/src' make -C config install make[1]: Entering directory `/opt/postgresql-10.3/config' /bin/mkdir -p '/opt/postgresql-10.3/lib/pgxs/config' /usr/bin/install -c -m 755 ./install-sh '/opt/postgresql-10.3/lib/pgxs/config/install-sh' /usr/bin/install -c -m 755 ./missing '/opt/postgresql-10.3/lib/pgxs/config/missing' make[1]: Leaving directory `/opt/postgresql-10.3/config' PostgreSQL installation complete. make: Leaving directory `/opt/postgresql-10.3' （6）创建相关目录及配置环境变量 mkdir -p /data/pgdata/serverlog mkdir /data/pg su - postgres vi .bash_profile  （删除原来的所有，以下黄色部分直接复制粘贴） # .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific environment and startup programs PATH=$PATH:$HOME/bin export PATH # postgres #PostgreSQL端口 PGPORT=5432 #PostgreSQL数据目录 PGDATA=/data/pgdata export PGPORT PGDATA  #所使用的语言 export LANG=zh_CN.utf8 #PostgreSQL 安装目录 export PGHOME=/data/pg #PostgreSQL 连接库文件 export LD_LIBRARY_PATH=$PGHOME/lib:/lib64:/usr/lib64:/usr/local/lib64:/lib:/usr/lib:/usr/local/lib:$LD_LIBRARY_PATH export DATE=`date +"%Y%m%d%H%M"` #将PostgreSQL的命令行添加到 PATH 环境变量 export PATH=$PGHOME/bin:$PATH #PostgreSQL的 man 手册 export MANPATH=$PGHOME/share/man:$MANPATH #PostgreSQL的默认用户 export PGUSER=postgres #PostgreSQL默认主机地址 export PGHOST=127.0.0.1 #默认的数据库名 export PGDATABASE=postgres #定义日志存放目录 PGLOG="$PGDATA/serverlog" source .bash_profile （7）初始化数据库 #执行数据库初始化脚本 root用户登录 chown -R postgres.postgres /data/ su - postgres $/opt/postgresql-10.3/bin/initdb --encoding=utf8 -D /data/pg/data 警告:为本地连接启动了 "trust" 认证. 你可以通过编辑 pg_hba.conf 更改或你下次 行 initdb 时使用 -A或者--auth-local和--auth-host选项. Success. You can now start the database server using: 启动数据库 su - postgres /opt/postgresql-10.3/bin/pg_ctl -D /data/pg/data -l logfile start （8）相关命令拷贝 root用户 mkdir /data/pg/bin cp /opt/postgresql-10.3/bin/*   /data/pg/bin chown -R postgres.postgres  /data/pg/bin 三、postgresql主从搭建 1、主库配置