[ZBXNEXT-5872] Using multiple IPs for postgres DB connection Created: 2020 Apr 06  Updated: 2020 Apr 07

Status: Open
Project: ZABBIX FEATURE REQUESTS
Component/s: Proxy (P), Server (S)
Affects Version/s: 4.4.7
Fix Version/s: None

Type: New Feature Request Priority: Trivial
Reporter: Oleksii Zagorskyi Assignee: Andris Zeila
Resolution: Unresolved Votes: 2
Labels: multiple, postgres, redundancy
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Duplicate

 Description   

Would be nice to use postgres' feature of having multiple servers in DB connection string as described here:

https://www.percona.com/blog/2019/10/23/seamless-application-failover-using-libpq-features-in-postgresql/



 Comments   
Comment by Guenther SOMMER [ 2020 Apr 07 ]

Hello, it would be especially about the functionality described in:

https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-PARAMKEYWORDS

with a connection URI

postgresql://host1:123,host2:456/somedb?target_session_attrs=read-write

as this would improve the usage of the cluster and we'd not need layer-2 bound virtual IPs anymore.

Generated at Fri Apr 04 21:52:18 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.