Support client-side HA with External HA Postgres setups

[MnrGreg]

The Harbor Core Postgres client library github.com/lib/pq does not support client-side HA and cannot transparently fail over across multiple hosts of a HA Postgres cluster.

Example of Postgres client-side HA connection string below:
postgres://host1:5001,host2:5001/postgres?target_session_attrs=read-write&sslmode=prefer

PR 714 to enable client-side HA has not been merged in 2 years and it seems the project is in maintenance mode: grafana/grafana#3676 (comment).

The Harbor project should consider adopting a maintained Postgres client library such as github.com/jackc/pgx

[github-actions]

This issue is being marked stale due to a period of inactivity. If this issue is still relevant, please comment or remove the stale label. Otherwise, this issue will close in 30 days.

[github-actions]

This issue was closed because it has been stalled for 30 days with no activity. If this issue is still relevant, please re-open a new issue.