View Issue Details

IDProjectCategoryView StatusLast Update
0000661Pgpool-IIGeneralpublic2020-12-09 17:04
Reportersatish Assigned Topengbo  
PrioritynormalSeverityfeatureReproducibilityN/A
Status feedbackResolutionopen 
Summary0000661: connecting to Application with Virtual IP
DescriptionCan we connect the postgresql client like dbeaver,pgadmin with Vitual Ip which we we used in pgpool cluster setup?
How can we connect the application with Virtual IP ?
Tagsvirtual ip

Activities

pengbo

2020-11-24 13:21

developer   ~0003609

You can use "delegate_IP" to set a Virtual IP.

Documentation:
https://www.pgpool.net/docs/latest/en/html/runtime-watchdog-config.html#CONFIG-WATCHDOG-VIP-CONTROL

Below is a configuration example:
https://www.pgpool.net/docs/latest/en/html/example-cluster.html

satish

2020-11-24 14:08

reporter   ~0003610

actually i configured virtual IP and it is working fine. How i can pass the virtual IP to connect the Application.

pengbo

2020-11-24 14:38

developer   ~0003611

You need to specify the virtual IP and port of pgpool to connect DB.

satish

2020-11-27 00:47

reporter   ~0003614

Is it possible to connect to postgresql client like pgadmin and dbeaver with virtual IP?.Because,I tried but i am getting connection time out error.
i

pengbo

2020-12-09 17:04

developer   ~0003648

I think you need to specify the virtual IP and port of pgpool "9999".

Could you connection to Application using "psql" via pgpool?
For example:
  psql -h <virtual IP> -p 9999 -U postgres postgres

Issue History

Date Modified Username Field Change
2020-11-23 23:36 satish New Issue
2020-11-24 01:02 satish Tag Attached: virtual ip
2020-11-24 13:21 pengbo Note Added: 0003609
2020-11-24 13:22 pengbo Assigned To => pengbo
2020-11-24 13:22 pengbo Status new => feedback
2020-11-24 14:08 satish Note Added: 0003610
2020-11-24 14:08 satish Status feedback => assigned
2020-11-24 14:38 pengbo Note Added: 0003611
2020-11-24 14:38 pengbo Status assigned => feedback
2020-11-27 00:47 satish Note Added: 0003614
2020-11-27 00:47 satish Status feedback => assigned
2020-12-09 17:04 pengbo Note Added: 0003648
2020-12-09 17:04 pengbo Status assigned => feedback