PostgreSQL Stream 模式搭建

PostgreSQL Stream 模式搭建1、编译安装yum install -y gcc gcc-c++ automake autoconf libjpeg libjpeg-devel libpng libpng-devel freetype freetype-devel libxml2 libxml2-devel zlib zlib-devel glibc glibc-devel glib2 glib2-devel bzip2 bzip2-devel ncurses ncurses-devel curl curl-devel e2fsprogs e2fsprogs-devel krb5 krb5-devel libidn libidn-devel openssl openssl-devel openldap openldap-devel nss_ldap openldap-clients openldap-servers bison* glib* flex readline readline-devel apr apr-util apr-develrzsz sysstat e4fsprogs ntp readline-devel openssl openssl-devel pam-devel libxml2-devel libxslt-devel python-devel tcl-devel flex bisontar –jxvf postgresql-9.2.1.tar.bz2
cd postgresql-9.2.1
./configure --prefix=/usr/local/pgsql
gmake world
gmake install-world2、新建用户，授权#创建数据库目录
mkdir /data
#创建用户 postgres ，并授权
useradd postgres
chown postgres.postgres /data3、配置环境变量#切换到 postgres 用户
su postgres
#为其配置环境变量：
vim ~postgres/.bash_profile
PGLIB=/usr/local/pgsql/lib
PGDATA=/data
PATH=$PATH:/usr/local/pgsql/bin
MANPATH=$MANPATH:/usr/local/pgsql/man
export PGLIB PGDATA PATH MANPATH
export PGDATA=/data4、初始化数据库initdb -D $PGDATA5、Master 配置文件修改vim pg_hba.confhost all all 192.168.2.4/32 trusthost all postgres 192.168.2.4/32 trustvim postgres.conf
listen_addresses="*"
wal_level = "hot_standby"
max_wal_senders = 3
wal_keep_segments = 16 # 80 GB required on pg_xlog
cp /usr/local/pgsql/share/recovery.conf.sample /data/recovery.cone
vim reconver.conf
standby_mode = on
primary_conninfo = "host=master port=5433 user=postgres" #从节点信息6、生成备库实例[postgres@localhost data]$pg_ctl –D $PGDATA -p 5432传送数据文件到slave在备库执行[postgres@localhost data]$pg_basebackup -D $PGDATA -Fp -Xs -v -h master -p 5432 -U postgres7、Slave 配置文件修改[postgres@localhost data]$ vim postgresql.conf注意删除 "#"hot_standby = on
vim reconver.conf
standby_mode = on
primary_conninfo = "host=master port=5432 user=postgres" #主节点信息8、启动主从数据库pg_ctl –D $PGDATAmaster
[postgres@localhost data]$ ps -ef |grep postgres |grep sender
postgres 12021 10924 0 14:37 ？ 00:00:00 postgres: wal sender process postgres 172.16.0.132（33427） streaming 0/3036838slave[postgres@localhost data]$ ps -ef |grep postgres |grep recover
postgres 5479 5471 0 17:24 ？ 00:00:00 postgres: startup process recovering 00000002000000000000000D
注意：这个时候slave从master同步数据，但是slave 是只读的。------------------------------------华丽丽的分割线------------------------------------CentOS 6.3环境下yum安装PostgreSQL 9.3 http://www.linuxidc.com/Linux/2014-05/101787.htmPostgreSQL缓存详述 http://www.linuxidc.com/Linux/2013-07/87778.htmWindows平台编译 PostgreSQL http://www.linuxidc.com/Linux/2013-05/85114.htmUbuntu下LAPP（Linux+Apache+PostgreSQL+PHP）环境的配置与安装 http://www.linuxidc.com/Linux/2013-04/83564.htmUbuntu上的phppgAdmin安装及配置 http://www.linuxidc.com/Linux/2011-08/40520.htmCentOS平台下安装PostgreSQL9.3 http://www.linuxidc.com/Linux/2014-05/101723.htmPostgreSQL配置Streaming Replication集群 http://www.linuxidc.com/Linux/2014-05/101724.htm如何在CentOS 7/6.5/6.4 下安装PostgreSQL 9.3 与 phpPgAdmin http://www.linuxidc.com/Linux/2014-12/110108.htm------------------------------------华丽丽的分割线------------------------------------PostgreSQL 的详细介绍：请点这里
PostgreSQL 的下载地址：请点这里本文永久更新链接地址