Maintain control of your Microsoft 365 data
Post Reply
Matt.Sharpe
Service Provider
Posts: 238
Liked: 20 times
Joined: Mar 29, 2016 3:37 pm
Full Name: Matt Sharpe
Contact:

Veeam 365 v8 - Pgbouncer

Post by Matt.Sharpe »

Hello All!

We are currently testing out the upgrade process to dedicated NATS and POSTGRES servers as per a recommendation document. Part of the document states "PgBouncer is highly recommended"

I am curious if anyone using Veeam 365 v8 with a dedicated DB server is also using Pgbouncer? I am having issues getting this working due to authentication on the upgrade wizard. I am curious how others have this configured if at all?
Polina
Veeam Software
Posts: 3567
Liked: 851 times
Joined: Oct 21, 2011 11:22 am
Full Name: Polina Vasileva
Contact:

Re: Veeam 365 v8 - Pgbouncer

Post by Polina »

Hi Matt,

We are working on the document with a detailed guidance how to set it up, which I hope to share quite soon.
Matt.Sharpe
Service Provider
Posts: 238
Liked: 20 times
Joined: Mar 29, 2016 3:37 pm
Full Name: Matt Sharpe
Contact:

Re: Veeam 365 v8 - Pgbouncer

Post by Matt.Sharpe »

Do you have an ETA on when this will be available?

We are being recommended to use pgbouncer, yet no documentation on how this should be configured?

I received confirmation from an engineer that this only supports md5 hashing. Yet md5 is considered deprecated?
Polina
Veeam Software
Posts: 3567
Liked: 851 times
Joined: Oct 21, 2011 11:22 am
Full Name: Polina Vasileva
Contact:

Re: Veeam 365 v8 - Pgbouncer

Post by Polina »

No ETA on the KB yet. You can subscribe to our KB updates to get notified once it's available.

You can also use a SCRAM secret instead of MD5.
Polina
Veeam Software
Posts: 3567
Liked: 851 times
Joined: Oct 21, 2011 11:22 am
Full Name: Polina Vasileva
Contact:

Re: Veeam 365 v8 - Pgbouncer

Post by Polina » 2 people like this post

Bjoern_ch
Service Provider
Posts: 54
Liked: 17 times
Joined: Sep 09, 2022 12:22 pm
Full Name: Bjoern
Location: Zurich
Contact:

Re: Veeam 365 v8 - Pgbouncer

Post by Bjoern_ch »

@Polina
the KB article says:
The PostgreSQL option max_connections should be configured based on the following formula:
max_connections = (max_user_connections + pool_size) * 1.10

In the .ini file followed by the instructions it says:
;;; Connection limits
;;;
; total number of clients that can connect
max_client_conn = 10000
max_user_connections = 800
default_pool_size = 20

I assume "max_connections" from the instructions refer to "max_client_conn" in the ini file (as there is no max_connections in the ini file).
If I now use the formula: (800+20)*1.1=902
Why is the number of max_client_conn = 10000 and not 902?

default_pool_size = 20 means number of proxy in my proxy pool?

So, what exactly do I need to adjust here?
Polina
Veeam Software
Posts: 3567
Liked: 851 times
Joined: Oct 21, 2011 11:22 am
Full Name: Polina Vasileva
Contact:

Re: Veeam 365 v8 - Pgbouncer

Post by Polina » 1 person likes this post

Hi Bjoern,

Apologies - there is (if not fixed already) a mistake in this formula, and the correct version would be:
max_connections(postgresql.auto.conf) = max_user_connections(pgbouncer.ini) *1.10
Post Reply

Who is online

Users browsing this forum: No registered users and 4 guests