Thread: Streaming replication + pgpool-II tutorial
Hi, It seems there are some demand to seek how to deal with automated failover while using Streaming replication and Hot standby. I wrote a small tutorial how to implement this by using pgpool-II. Please visit: http://pgpool.projects.postgresql.org/contrib_docs/simple_sr_setting/index.html if you are interested. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp
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.
Probably this is not the right forum. You'd better to subscribe and post to pgpool-general list. http://www.pgpool.net/mailman/listinfo/pgpool-general -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp > 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. > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general