PostgreSQL Stream Mode Setup

Source: Internet
Author: User
Tags bz2 curl openssl readline openldap


650) this.width=650; "alt=" postgresql-9.2.1.tar.bz2 "class=" editor-attachment "src="/e/u261/themes/default/images/ Spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid # ddd; "/>


1. Compile and install

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 bison 
TAR–JXVF postgresql-9.2.1.tar.bz2 cd postgresql-9.2.1./configure--prefix=/usr/local/pgsql gmake worldgmake Install-world

2. New user, authorized

#创建数据库目录 mkdir/data# Create a user postgres and authorize Useradd Postgreschown Postgres.postgres/data

3. Configure Environment variables

#切换到 postgres user su postgres #为其配置环境变量: Vim ~postgres/.bash_profilepglib=/usr/local/pgsql/libpgdata=/datapath= $PATH:/ Usr/local/pgsql/binmanpath= $MANPATH:/usr/local/pgsql/manexport pglib PGDATA PATH manpathexport pgdata=/data

4. Initialize the database

Initdb-d $PGDATA

5, Master configuration file modification


Vim pg_hba.conf

Host All 192.168.2.4/32 Trust

Host all Postgres 192.168.2.4/32 Trust



Vim postgres.conflisten_addresses= ' * ' wal_level = ' hot_standby ' max_wal_senders = 3wal_keep_segments = +-GB required On Pg_xlogcp/usr/local/pgsql/share/recovery.conf.sample/data/recovery.conevim Reconver.confstandby_mode = Onprimary_conninfo = ' host=master port=5433 user=postgres ' #从节点信息


6. Create a Standby instance

[[email protected] data] $pg _ctl–d $PGDATA-P 5432

Transferring data files to slave

In the Standby library execution

[[email protected] data] $PG _basebackup-d $PGDATA-fp-xs-v-H master-p 5432-u Postgres

7. Slave Configuration File Modification


[Email protected] data]$ vim postgresql.conf

Note Delete "#"

Hot_standby = on vim Reconver.confstandby_mode = Onprimary_conninfo = ' host=master port=5432 user=postgres ' #主节点信息

8. Start the master-slave database

Pg_ctl–d $PGDATA

Master

[[email protected] data]$ ps-ef |grep postgres |grep senderpostgres 12021 10924 0 14:37? 00:00:00 Postgres:wal Sender Process Postgres 172.16.0.132 (33427) streaming 0/3036838

Slave

[[email protected] data]$ ps-ef |grep postgres |grep recover postgres 5479 5471 0 17:24? 00:00:00 Postgres:startup Process Recovering 00000002000000000000000D


Note: This time slave synchronizes data from master, but slave is read-only.


This article is from the "World" blog, make sure to keep this source http://xiajie.blog.51cto.com/6044823/1662222

PostgreSQL Stream Mode Setup

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.