流复制搭建安装、配置与切换

1、流的安装、配置与切上传至/usr/local/src下yumyuminstall-yreadline-devel.x86_64 yum install -y zlib-devel.x86_64-8*/usr/sbin/ntpdate vi /etc/sysctl.conf kernel.shmmni=4096kernel.sem=501006412800050100fs.file-max= net.core.rmem_max=net.core.wmem_default=net.core.wmem_max= mit_memory= fs.aio-max-nr= 将参数加载到内核，执行sysctl

2、配置limits.confvi softnofile hardnofilesoftnprochardnprocsoftcore hardcore softmemlock hardmemlock 关闭vi/etc/sysconfig/selinux 状态：chkconfiglist|grepi关闭：# /sbin/chkconfig iptables rootlocalhost# groupadd postgres rootlocalhost#useradd-gpostgrespostgres rootlocalhost# passwd postgresrootlocalhostsrc#tar-

3、jxvfpostgresql-9.4.2.tar.bz2 rootlocalhost src#cd postgresql-9.4.2postgresql-9.4.2#./configure -prefix=/usr/local/postgresql-9.4.2 -with-rootlocalhost pgsql-9.4.2#make rootlocalhost pgsql-9.4.2#make install rootlocalhost pgsql-9.4.2#cd /usr/local rootlocalhost local#ln-spostgresql-9.4.2pgsqlrootloca

4、lhost local#chown-Rpostgres:postgrespostgresql-9.4.2 rootlocalhost local#chown -R postgres:postgres pgsql设置 Postgres 用户环境变量 rootlocalhostpgsql-9.4.2supostgres postgreslocalhost$morebash_profile postgreslocalhost $ vi .bash_profileexport PATH # .bash_profile#Getthealiasesandfunctions if -f /.bashrc ;

5、 then.#Userspecificenvironmentandstartupprograms export PGPORT=5432export PGDATA=/PGDATA/dataexportexportrootlocalhostmkdir -p /PGDATA/data rootlocalhostmkdir -p /PGDATA/archive_log rootlocalhostchown-Rpostgres:postgres/PGDATA od -R 700 /PGDATArootlocalhostsu 这数据库名填写的是 replication，这并不是表示连接到名称为 repli

6、cation 数据库上，而是表示准replication 编辑 的安postgreslocalhostdata$postgres localhost data$ mkdir pg_log postgres localhost data$od700pg_log postgres localhost data$ ls -lthrtotal2postgrespostgres4.0KJul2909:442postgres postgres4.0KJul2909:442postgrespostgres4.0KJul2909:442postgrespostgres4.0KJul2909:442postgr

7、espostgres4.0KJul2909:442postgres postgres4.0KJul2909:442postgrespostgres4.0KJul2909:442postgrespostgres4.0KJul2909:444postgrespostgres4.0KJul2909:44-rw- 1 postgres postgres4Jul2909:44PG_VERSION 4 postgres postgres 4.0K Jul 29 09:44 pg_logical-rw-1postgres88Jul2909:44-1 postgrespostgres1.6KJul2909:4

8、4-1 postgrespostgres4.4KJul2909:443postgrespostgres4.0KJul2909:442postgrespostgres4.0KJul2909:442postgrespostgres4.0KJul2909:442postgrespostgres4.0KJul2909:442postgrespostgres4.0KJul2909:445postgrespostgres4.0KJul2909:44-rw-1postgrespostgres 21KJul2910:01postgresql.conf 2 postgres postgres 4.0K Jul

9、29 10:01 pg_logpostgreslocalhost $pg_ctlstart server startingcreaterolereploginreplicationencryptedpasswordrep; select 如postgres localhost $ vi.pgpass postgres localhost $od600.pgpasspostgres localhost $ cat .pgpass postgres localhost $od600.pgpassrootlocalhostsupostgreslocalhost$pg_basebackup-h192.

10、168.236.120-p5432-Urep-Fp-P -x-R-D$PGDATA -lrepbackup20150729 37466/37466 kB (100%), 1/1 tablespacepostgreslocalhost $cd/PGDATA/data postgres localhost $vi recovery.conf standby_mode = onprimary_conninfo=user=reppassword=rephost=192.168.179.109port=5432 mand = cp /PGDATA/archive_log/%f %ptrigger_fil

11、e=recovery_timeline= postgreslocalhost pg_xlog$scp00*postgreslocalhost pgdata$ls-l total 120-rw-1postgres198Jul2911:48drwx-5postgrespostgres 4096Jul2911:48drwx-2postgrespostgres 4096Jul2911:48drwx-2postgrespostgres 4096Jul2911:48drwx-2postgrespostgres 4096Jul2911:48-rw-1postgrespostgres 4678Jul2911:

12、52-rw-1postgrespostgres 1636Jul2911:48drwx-2postgrespostgres 4096Jul2911:48drwx-4postgrespostgres 4096Jul2911:48drwx-4postgrespostgres 4096Jul2911:48drwx-2postgrespostgres 4096Jul2911:48drwx-2postgrespostgres 4096Jul2911:48drwx-2postgrespostgres 4096Jul2911:48drwx-2postgrespostgres 4096Jul2911:48drw

13、x-2postgrespostgres 4096Jul2911:48drwx-2postgrespostgres 4096Jul2911:48drwx-2postgrespostgres 4096Jul2911:48drwx-2postgrespostgres 4096Jul2911:48drwx-2postgrespostgres 4096Jul2911:48-rw-1postgres4Jul2911:48drwx-3postgrespostgres 4096Jul2911:48-rw-1postgres88Jul2911:481postgrespostgres21267Jul2911:48

14、-rw-rw-r- 1 postgres postgres227Jul2911:51recovery.conf postgres localhost $ pg_ctl startserverpostgreslocalhost archive$top-c-u29518postgres 20 0 266m22161532S 0.0 0.1 0:00.00postgres: walsenderprocess rep192.168.179.228(17596) streaming0/6000500postgreslocalhost $top-c-u5489postgres 20 0 266m16281

15、120S 0.0 0.0 0:00.03postgres:startup5498postgres 20 0 270m17881296S 0.0 0.0 0:00.08postgres:wal receiverprocess streamingpostgres localhost $ pg_controldata pg_control version number:CatalogversionDatabase cluster state:inpostgreslocalhost $pg_controlversionCatalogversionDatabasesystemDatabasecluste

16、rinarchive5postgreslocalhostpg_xlog$psqlpostgres psql (9.4.2)Typehelpforhelp. postgres=#createtablexing(idint,namevarchar(20); postgres=# insert into xing values(1,guang);postgres=#select*fromxing; id | name+1 |(1 postgresdroptablexing; DROP TABLEpostgres=# No relations 开机自启动 rootlocalhoststart-scri

17、pts#cp/usr/local/src/postgresql-9.4.2/contrib/start- scripts/linux /etc/init.d/postgresqlrootlocalhost start-scripts# cd /etc/init.d/ rootlocalhostinit.d#ls-l|grep-ipostgresql-rw-r-r- 1rootroot 3437Jul2909:45postgresql rootlocalhost init.d#od +x postgresql rootlocalhost init.d# vi postgresql prefix=

18、/usr/local/pgsql -postgresql装路PGDATA=/PGDATA/data -postgresql 的数据 流主备切postgreslocalhost pg_xlog$ pg_ctl stop -m fast waiting for server to shut down.server postgreslocalhost pg_xlog$scp00*注作为初次切换需要copy 日志文件，当主节点ps ef|grep postgres 时看不到postgreslocalhostdata$pg_ctlpromote server promoting注：会使recovery.

19、confpostgreslocalhostpg_xlog$ps-ef|greppostgres3072830656 015:1500:00:00postgres:archiverprocess lastwasstandby_mode= primary_conninfo=user=reppassword=rephost=192.168.236.228port=5432 mand = cp /PGDATA/archive_log/%f %ptrigger_file=/PGDATA/trigger_activestandby recovery_timeline = latestpostgresloc

20、alhost$cdpostgreslocalhost pg_xlog$scp.historypostgreslocalhostdata$pg_ctlstart server startingpostgreslocalhostdata$LOG: redirectinglogoutputtologgingcollectorprocess HINT: Future log output will appear in directory /PGDATA/data/pg_log.top cupostgreslocalhostpg_xlog$ps-ef|grep013:1600:00:00su-postg

21、res013:1600:00:00-postgres1015:1100:00:00 /usr/local/postgresql-postgres015:1100:00:00postgres:loggerpostgres015:1100:00:00 postgres: checkpointer postgres015:1100:00:00postgres:writerpostgres015:1100:00:00postgres:statscollectorpostgres015:1500:00:00postgres:walwriterpostgres015:15 postgres015:1500

22、:00:00postgres:archiverprocess lastwaspostgres015:1600:00:00postgres:walsenderprocessrep192.168.179.228(17668)streamingpostgres015:2100:00:00ps-postgres015:2100:00:00greppostgresnfspg_xlog$kill-930656 postgresnfs pg_xlog$postgresnfspg_xlog$ps-ef|grep29207013:1600:00:00su-29208013:1600:00:00-30817015

23、:2200:00:00ps-30818015:2200:00:00greppostgresguangdata$pg_ctlpromote server promotingpostgresguang postgresguangdata$ps-ef|grep013:1600:00:00su-013:1600:00:00-1015:16 015:1600:00:00postgres:logger015:1600:00:00 postgres: checkpointer 015:1600:00:00postgres:writer015:1600:00:00postgres:statscollector015:2400:00:00postgres:walwriter015:24 015:2400:00:00postgres: