Hi, How is setting the pg_hba.conf and postgresql.conf?
Regards, ----------- At.Mitani -- original message -- From: Sunitha S<[EMAIL PROTECTED]> To: <[email protected]> Sent: Mon, 9 Jun 2008 14:18:31 +0530 Subject: [Pgcluster-general] connecting to load balancer - help > > >Hi Mitani, > >I changed the receiving ports for load balancer, ClusterDB 1 and >ClusterDB 2 to 5432, 5001 and 5001 respectively > >Restarted the cluster setup > >I tried connecting to load balancer on Tstmach1 as >$psql -h Tstmach1 -p 5432 > >And we were successfully able to connect to the DB. But we are not able >to connect to load balancer from Tstmach2 or another machine [PGAdmin >III] using the above command. > >Regards, >Sunitha > >------------------------------------------------------------------------ >---- > >Date: Mon, 9 Jun 2008 12:33:08 +0900 (JST) >From: <[EMAIL PROTECTED]> >Subject: Re: [Pgcluster-general] connecting to load balancer - help >To: [email protected] >Message-ID: <[EMAIL PROTECTED]> >Content-Type: text/plain; charset=ISO-2022-JP > >Hi, > >When you wanto to use loadbalancer which is installed in same machine >with clusterDB, >You should specified unique port numbers in the loadbalancer and the >clusterDB. > >EX. >server receive port >---------------------------- >load balancer: 5432 >cluster db1 : 5001 >cluster db2 : 5002 > >On above sample, client can access cluster DB through loadbalancer with >port 5432 using. > >Regards, >------------ >At.Mitani > >-- original message -- >From: Sunitha S<[EMAIL PROTECTED]> >To: <[email protected]> >Sent: Sat, 7 Jun 2008 19:22:28 +0530 >Subject: [Pgcluster-general] connecting to load balancer - help > >> >>Hi All, >> >> >> >> >>We have following setup >> >> >> >> >>Tstmach1: >> >>ClusterDB1 >> >>Replication server1 >> >>Load Balancer >> >> >> >> >>Tstmach2 >> >>ClusterDB2 >> >>Replication server2 >> >> >> >> >>And the nodes are started in the following order >> >>ClusterDBs on Tstmach1 and 2 >> >>Pgrelicates on Tstmach1 and 2 >> >>Pglb on Tstmach1 >> >>And log for pglb is as follows >> >> >> >> >>2008-06-08 00:11:14 [30653] >>DEBUG:PGRset_status_on_cluster_tbl():host:a3-cybertst1 port:5432 max:32 >>use:0 status1 >> >>2008-06-08 00:11:14 [30653] >>DEBUG:PGRset_status_on_cluster_tbl():host:a3-cybertst5 port:5432 max:32 >>use:0 status1 >> >>2008-06-08 00:11:14 [30653] DEBUG:init_pglb():Child_Tbl size is[49536] >> >> >> >> >>and the cluster works fine. >> >> >> >> >>But How do connect to the load balancer and test fail scenarios with a >>load balancer >> >> >> >> >>Thanks in advance >> >> >> >> >>Regards, >> >>Sunitha S >> >> >> >>This email message and its attachments may contain CONFIDENTIAL AND >PRIVILEGED INFORMATION intended for the sole use of the addressee(s). If >you have received it in error, please contact the sender by return >email, notify your system manager and destroy the original message and >any copies thereof. Any review, use, disclosure or distribution is >unlawful. Please check this email and any attachments for the presence >of viruses. The Company accepts no liability for any damage caused by >any virus transmitted by this email. The views or opinions presented in >this e-mail are solely those of the author and do not necessarily >represent those of the company. >>The Company reserves the right to monitor, review and store the content >of all messages sent to or from this e-mail address. >> >> >>www.aztecsoft.com >>_______________________________________________ >>Pgcluster-general mailing list >>[email protected] >>http://pgfoundry.org/mailman/listinfo/pgcluster-general >> > > > >This email message and its attachments may contain CONFIDENTIAL AND PRIVILEGED >INFORMATION intended for the sole use of the addressee(s). If you have >received it in error, please contact the sender by return email, notify your >system manager and destroy the original message and any copies thereof. Any >review, use, disclosure or distribution is unlawful. Please check this email >and any attachments for the presence of viruses. The Company accepts no >liability for any damage caused by any virus transmitted by this email. The >views or opinions presented in this e-mail are solely those of the author and >do not necessarily represent those of the company. >The Company reserves the right to monitor, review and store the content of all >messages sent to or from this e-mail address. > >www.aztecsoft.com >_______________________________________________ >Pgcluster-general mailing list >[email protected] >http://pgfoundry.org/mailman/listinfo/pgcluster-general > _______________________________________________ Pgcluster-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgcluster-general
