[Pgpool-general] streaming replication on two different servers

[Tatsuo Ishii]

> Hello Tatsuo,
> 
> I will try fiddling with this. Currently, my Trigger file is empty and I am
> trying to figure out things from there. I assume pgpool installation is
> required only on the primary server, please let me know if I am wrong.

No, it's not required. pgpoolAdmin and pgpool must be running on the
same server though.

> However, I am waiting for the tutorials for two separate servers'
> configuration to get released, that would be the best. Thanks a lot for your
> reply.
> 
> -Bharath
> 
> On Tue, Jan 18, 2011 at 12:32 PM, Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
> 
>> > Has anybody tried installing streaming replication mentioned in the URL :
>> >
>> http://pgpool.projects.postgresql.org/contrib_docs/simple_sr_setting/index.html
>> >  on
>> > two different postgresql db servers?  The tutorial assumes the
>> replication
>> > is done on the same server. I have got pgpool admin running already on
>> one
>> > one server. However, using the same tutorial I tried configuring for two
>> db
>> > servers by changing few settings on pgpool.conf on  the admin page and
>> the
>> > replication doesnt seem to happen. Can someone please tell me the main
>> > highlights of the changes on configuration settings required as compared
>> to
>> > the  above tutorial, to get it working on two different servers?
>>
>> What immediaty comes to my mind is "trigger file". The trigger file
>> needs to be visibile to standby PostgreSQL. Failover.sh needs to be
>> changed so that it creates the trigger file on the appropreate server,
>> maybe using ssh or some such.
>>
>> I'm going to write a new version of tutrial suitable for
>> the case pgpool-II/Primary/Standby are on separate servers.
>> --
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
>> Japanese: http://www.sraoss.co.jp
>>