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 <[email protected]> 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 >
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
