Connecting harbor to postgres via pgpool. about harbor HOT 10 CLOSED

Hi @snoop2048 ,

Thanks for connecting with us, and yes, we are currently only support single hostname for Postgres server.
If we can only use a single IP must we manually repoint harbor if the DB switches its active node?

I am not recommend to do so even you have tools to handle this 'ip' changes. Since there's might be some concerned with the data inconsistent during the transit.

But if you have handy experience on this, welcome to sharing with the community!

from harbor.

Hey, thanks for coming back to me. pgpool negates the need to an external LB for the postgres cluster as it handles loadbalancing itself (amongst other things). Adding another LB (HAproxy or whatever) in front of is probably going to just cause issues. Admittedly getting slightly out of my depth here given I am not a DB engineer but I will try and get one to comment.

from harbor.

So harbor does not support any sort of HA Postgres backend?

from harbor.

Not exactly, I will take a look later

from harbor.

I am not sure how your pgpool is configured. But theoretically, if you set up a load balancer in front of your pg service, I think one single hostname for pg is enough. And you don't need to worry about fail over handle and synchronization of the db.

from harbor.

Thanks @snoop2048 ,

I am not familiar with the pgpool usage as well. All this LB things is just based on my assumption.
So If you have any progress or experience here, please share with users who have the same doubt.
I will keep this issue open for further discussion and references.

Best,
Miner

from harbor.

In terms of HA, I'm running Postgresql in HA with Patroni (using k8s operator) with no issues for the past year

from harbor.

@snoop2048

Regarding High Availability (HA), pgpool appears to function similarly to other PostgreSQL balancers such as pgbouncer. It's recommended to deploy a standalone pgpool for managing multiple databases. Clients can then connect to a single pgpool instance, which distributes the load across all databases it serves.

You might find valuable insights in this discussion: Postgres with pgpool Architecture.

Thanks.

from harbor.

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.

from harbor.

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.

from harbor.