Postgre vbr location

[matteu]

Hello,

I would like to know when can I use the all in on installation with postgreSQL and when do I need a dedicated server for postgreSQL ?

I don t find any guide

[Mildur]

Hi Matteu

I don't think this is explicitly documented anywhere.
Are we talking about a few dozen, hundreds or thousands of protected workloads? For what size is your question?

We have our best practice guide which makes a sizing recommendation. I would say, if the postgresql database requires significant CPU/memory resources or you want to managed your PostgreSQL server (e.g.: security purposes), deploy a standalone PostgreSQL server.
Sizing Best practice: https://bp.veeam.com/vbr/2_Design_Struc ... abase.html

Best,
Fabian

[matteu]

I install veeam for several customer.
I just would like to know when I have to think about a dedicated server. When there is arround 150 workload ? 3000 ?

I would like to know more about it.

Yes, I saw this best practice guide but unfortunately there is nothing about it.

[tyler.jurgens]

I've been using the same general guidelines I used for a dedicated MSSQL installation. When I needed a database beyond a certain size, or requires enough performance to do so, I made it a dedicated server. Plus with Postgres you could then easily move that DB to a dedicated Linux box, or as a docker container. If you're at the point in your Veeam deployments when you're not doing an AIO Veeam install, it wouldn't be a bad idea to put Postgres on its own server, or at least consider it.

I know its not a hard and fast suggestion like: If you hit 200 workloads, go dedicated postgres, but its been a good rule of thumb for me. Plus as more Veeam services can start to consume postgres, it gives you an easy way to have one DB server for all of them again, just like you could do with full MSSQL.