From: | gautammaji <gautammaji(at)sify(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Streaming replication + pgpool-II tutorial |
Date: | 2012-12-18 12:25:13 |
Message-ID: | 1355833513984-5737033.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Tatsuo Ishii,
I am very beginner at PostgreSQL. I am trying to create fail-over cluster
server (with replication and online recover) using pg-pool 3.1.
1. which prerequisite are needed for preparing failover server using
pgpool at linux environment (RHEL 6.1).
2. I am not able to configure pgpool.conf file and pool_hba.conf.
3. details information of my server are as follow (I am using 3 servers
one for cluster and other 2 for postgresql):
cluster server:
IP:192.168.1.21
HOST NAME: CLUST.pgsql.local
Port: 9999
node1 server:
IP: 192.168.1.30
HOST NAME: node1.pgsql.local
Port: 5432
username: postgres
Password: 123qwe
dbname: pg_new
backend_data_directory =
'/var/lib/pgsql/data'
node2 server:
IP:192.168.1.31
HOST NAME: node2.pgsql.local
Port: 5432
username: postgres
Password: 123qwe
dbname: pg_new
backend_data_directory =
'/var/lib/pgsql/data'
please help me.
Thanks
Gautam
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Streaming-replication-pgpool-II-tutorial-tp3250984p5737033.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Robert James | 2012-12-18 14:26:57 | Moving some of Postgres off a SSD |
Previous Message | hubert depesz lubaczewski | 2012-12-18 11:42:16 | Re: [COMMITTERS] pgsql: Allow a streaming replication standby to follow a timeline switc |