-
- Service Provider
- Posts: 238
- Liked: 20 times
- Joined: Mar 29, 2016 3:37 pm
- Full Name: Matt Sharpe
- Contact:
Veeam 365 v8 - Pgbouncer
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?
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?
-
- Veeam Software
- Posts: 3567
- Liked: 851 times
- Joined: Oct 21, 2011 11:22 am
- Full Name: Polina Vasileva
- Contact:
Re: Veeam 365 v8 - Pgbouncer
Hi Matt,
We are working on the document with a detailed guidance how to set it up, which I hope to share quite soon.
We are working on the document with a detailed guidance how to set it up, which I hope to share quite soon.
-
- Service Provider
- Posts: 238
- Liked: 20 times
- Joined: Mar 29, 2016 3:37 pm
- Full Name: Matt Sharpe
- Contact:
Re: Veeam 365 v8 - Pgbouncer
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?
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?
-
- Veeam Software
- Posts: 3567
- Liked: 851 times
- Joined: Oct 21, 2011 11:22 am
- Full Name: Polina Vasileva
- Contact:
Re: Veeam 365 v8 - Pgbouncer
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.
You can also use a SCRAM secret instead of MD5.
-
- Veeam Software
- Posts: 3567
- Liked: 851 times
- Joined: Oct 21, 2011 11:22 am
- Full Name: Polina Vasileva
- Contact:
Re: Veeam 365 v8 - Pgbouncer
KB is now live https://www.veeam.com/kb4728
-
- 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
@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?
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?
-
- Veeam Software
- Posts: 3567
- Liked: 851 times
- Joined: Oct 21, 2011 11:22 am
- Full Name: Polina Vasileva
- Contact:
Re: Veeam 365 v8 - Pgbouncer
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
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
Who is online
Users browsing this forum: No registered users and 4 guests