Not able to connect to postgresql database from other application

[snehalasarode]

I deployed the postgres HA. using the same manifest file ha.yml. provided vip as elastic ip. When i am trying to use this postgresql database for othe application i used database host IP as vip of postgresql. In this case i am getting issue that the application could not connect to database using vip. Any extra setting i have to do or what is exact issue?

[snehalasarode]

Hi @jhunt I set the value of vip is elastic ip but when i was tring to use this postgresql as database for other application i am providing value of vip to connect external application to this postgresql database at that time i am getting issue cannot connect to database. Here my question is which ip i have to pass to connect to this postgres from other application and why it is not able to connect to vip?

[jhunt]

What IaaS are you on?

[snehalasarode]

Hi @jhunt I am using AWS as IaaS. need to do some extra settings for vip? or which ip i have to use to connect to postgres from external application.

[jhunt]

Check your AWS security groups and or NACLs to ensure that you have allowed for traffic to/from the database VIP / VMs.

[snehalasarode]

Hi @jhunt I used VIP as elastic ip and done the entry of that elastic ip with port 5432 in security group of application and database. still facing issue: failed to connect to tcp://xx.x.x.x:5432

[snehalasarode]

what value we can pass for vip other than elastic ip? or Elastic ip is only correct option.

[snehalasarode]

Hi @jhunt any update on this??

[jhunt]

When you say

I set the value of vip is elastic ip

Are you saying that you told haproxy, in EC2, to use an elastic IP as the VRRP VIP to trade between the postgres instances? I don't believe VRRP is going to work on any IaaS except vSphere, since you don't generally get to muck about with networking at L2/L3 on cloud providers like AWS.

Can you post the manifest you are deploying?