postgresql replication with pgpool2 on ubuntu ~ darKonsole

--preparation--
next capter from may last post, now we'll make repication of postgreSQL with pgpool on ubuntu. assumtion, we have 2 server with postgresql installed ( n running well ) on each server.
--1--
first install pgpooll2, with

sudo apt-get install pgpool2

--2--
edit config file on /etc/pgpool.conf

# Host name or IP address to listen on: '*' for all, '' for no TCP/IP
# connections
listen_addresses = '*'

# Port number for pgpool
port = 5433

# Port number for pgpool communication manager
pcp_port = 9898

parallel_mode = false

# Replication mode
replication_mode = true

# Load balancing mode, i.e., all SELECTs are load balanced.
# This is ignored if replication_mode is false.
load_balance_mode = true

backend_hostname0 = '1.1.1.1'
backend_port0 = 5432
backend_weight0 = 1
backend_data_directory0 = ''
backend_hostname1 = '1.1.1.2'
backend_port1 = 5432
backend_weight1 = 1
backend_data_directory1 = ''

edit config file on /etc/pcp.conf Append the following line

postgres:ee26005a83e958c153b095a080b52d14
#postgres is user of your postgresql 
#and ee26005a83e958c15.. bla... bla... is postgres password in md5.

*Note:
to get/convert password in md5, you can use this ex command :
PG1:~$ pg_md5 your_pass
ee26005a83e958c153b095a080b52d14

--3--
restart the service

/etc/init.d/postgresql restart
 /etc/init.d/pgpool2 restart

--cek 'n jajal--
create database on pgpool port

createdb db_test –p 9898 –h 1.1.1.1 –U postgres

If replication is working properly, in both machines a new database called “db_test” should be created. use this command to check it up:

$ psql –l –p 5432 –h 1.1.1.1 –U postgres
$ psql –l –p 5432 –h 1.1.1.2 –U postgres

next chapter : .: here:.

source :
http://sameerajayalath.blogspot.com
google.com

darKonsole

postgresql replication with pgpool2 on ubuntu

Related Post