[Pgpool-general] streaming replication on two different servers

[Bharath Keshav]

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.
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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20110118/bbe0c560/attachment.html>