[Pgcluster-general] connecting to load balancer - help

Mon Jun 9 15:33:43 UTC 2008

Hi Mitani

Thanks a lot and we figured the problem, port 5432 was binding to
loopback address so I changed the /etc/hosts file to bind to the IP
address and it is binding to IP now and available from the client and
application.

Now we are proceeding with testing with high availability. Our test
scenario is as follows
1. Stop the cluster instance on Tstmach2 through kill (but pgreplicate
is still running)
2. We tried to insert into the table through a java application from a
remote machine and were successful in updating through load balancer
3. Now we bring up the cluster instance on Tstmach2 with "-R" option and
successfully synchronizes with MasterDB(Tstmach1)
4. Next we bring down the cluster instance on Tstmach1 through kill
(while pgreplicate and pglb running)
5. When we try to insert through our java application, it hangs from
remote machine (no recode is inserted)
6. If we try to insert through psql client, upon issuing the insert
command it hangs but the record is inserted.

Please let us know how to overcome this.

Thanks in advance

Regards,
Sunitha

----------------------------------------------------------------------

Hi,

How is setting the pg_hba.conf and postgresql.conf?

Regards,
-----------
At.Mitani

-- original message --
From: Sunitha S<sunithas at aztecsoft.com>
To: <pgcluster-general at pgfoundry.org>
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
>
----------------------------------------------------------------------

Message: 1
Date: Mon, 9 Jun 2008 14:18:31 +0530
From: "Sunitha S" <sunithas at aztecsoft.com>
Subject: [Pgcluster-general]  connecting to load balancer - help
To: <pgcluster-general at pgfoundry.org>
Message-ID:

<A1286843C9B74E46B0063D92B7844C28054A2E1D at azindbaex01.aztec.soft>
Content-Type: text/plain;	charset=us-ascii

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

------------------------------

Message: 2
Date: Mon, 9 Jun 2008 17:58:54 +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: <19416380.1213001934955.JavaMail.mitani at sraw.co.jp>
Content-Type: text/plain; charset=ISO-2022-JP

Hi,

How is setting the pg_hba.conf and postgresql.conf?

Regards,
-----------
At.Mitani

-- original message --
From: Sunitha S<sunithas at aztecsoft.com>
To: <pgcluster-general at pgfoundry.org>
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: <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
>_______________________________________________
>Pgcluster-general mailing list
>Pgcluster-general at pgfoundry.org
>http://pgfoundry.org/mailman/listinfo/pgcluster-general
>

------------------------------

_______________________________________________
Pgcluster-general mailing list
Pgcluster-general at pgfoundry.org
http://pgfoundry.org/mailman/listinfo/pgcluster-general

End of Pgcluster-general Digest, Vol 41, Issue 5
************************************************

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