View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000661 | Pgpool-II | General | public | 2020-11-23 23:36 | 2020-12-09 17:04 |
| Reporter | satish | Assigned To | pengbo | ||
| Priority | normal | Severity | feature | Reproducibility | N/A |
| Status | feedback | Resolution | open | ||
| Summary | 0000661: connecting to Application with Virtual IP | ||||
| Description | Can 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 ? | ||||
| Tags | virtual ip | ||||
|
|
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 |
|
|
actually i configured virtual IP and it is working fine. How i can pass the virtual IP to connect the Application. |
|
|
You need to specify the virtual IP and port of pgpool to connect DB. |
|
|
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 |
|
|
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 |
| 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 |