Обсуждение: 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