> 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 <[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
