[Pgcluster-general] connecting to load balancer - help

[Sunitha S]

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: <mitani at sraw.co.jp>
Subject: Re: [Pgcluster-general] connecting to load balancer - help
To: pgcluster-general at pgfoundry.org
Message-ID: <27717291.1212982388316.JavaMail.mitani at sraw.co.jp>
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<sunithas at aztecsoft.com>
To: <pgcluster-general at pgfoundry.org>
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
>Pgcluster-general at pgfoundry.org
>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