-
- Enthusiast
- Posts: 43
- Liked: 1 time
- Joined: May 30, 2023 12:58 pm
- Contact:
Veeam v12 postgresql questions
Hello,
regarding postgresql for veeam I have a few questions as follows:
- Local-Binding possible?
- possibly an extra admin user (if that's not the "postgres" anyway)?
- Auto vacuum or schedule it manually?
- Should I refrain from using special names (spaces, etc.) during the installation because of scripting and working with escapes?
- Should that also be two instances (as with SQL Express) or one instance with two DBs?
- Is postgresql automatic updated by veeam or is it a manual task (patchmanagement)?
thank you
regarding postgresql for veeam I have a few questions as follows:
- Local-Binding possible?
- possibly an extra admin user (if that's not the "postgres" anyway)?
- Auto vacuum or schedule it manually?
- Should I refrain from using special names (spaces, etc.) during the installation because of scripting and working with escapes?
- Should that also be two instances (as with SQL Express) or one instance with two DBs?
- Is postgresql automatic updated by veeam or is it a manual task (patchmanagement)?
thank you
-
- Product Manager
- Posts: 10100
- Liked: 2696 times
- Joined: May 13, 2017 4:51 pm
- Full Name: Fabian K.
- Location: Switzerland
- Contact:
Re: Veeam v12 postgresql questions
Hello Joshima
Best,
Fabian
Are you asking about only allowing localhost to connect to PostgreSQL?- Local-Binding possible?
Yes. You can create additional admin users if you like.- possibly an extra admin user (if that's not the "postgres" anyway)?
It is disabled on an newly installed Veeam Backup & Replication server. I suggest you run the database with the default settings. Let me check internally if we can recommend and support it.- Auto vacuum or schedule it manually?
It's recommended to not use special characters when working with software.- Should I refrain from using special names (spaces, etc.) during the installation because of scripting and working with escapes?
Two instances for which products? Enterprise manager and Veeam backup & Replication?- Should that also be two instances (as with SQL Express) or one instance with two DBs?
As for MSSQL, it's a manual task.- Is postgresql automatic updated by veeam or is it a manual task (patchmanagement)?
Best,
Fabian
Product Management Analyst @ Veeam Software
-
- Enthusiast
- Posts: 43
- Liked: 1 time
- Joined: May 30, 2023 12:58 pm
- Contact:
Re: Veeam v12 postgresql questions
Are you asking about only allowing localhost to connect to PostgreSQL? Yes
Two instances for which products? Enterprise manager and Veeam backup & Replication? Yes Enterprise manager and Veeam backup & Replication
Two instances for which products? Enterprise manager and Veeam backup & Replication? Yes Enterprise manager and Veeam backup & Replication
-
- Enthusiast
- Posts: 43
- Liked: 1 time
- Joined: May 30, 2023 12:58 pm
- Contact:
Re: Veeam v12 postgresql questions
Mildur wrote: ↑Jul 24, 2023 1:36 pm Hello Joshima
Are you asking about only allowing localhost to connect to PostgreSQL?
Yes only allowing localhost.
Yes. You can create additional admin users if you like.
It is disabled on an newly installed Veeam Backup & Replication server. I suggest you run the database with the default settings. Let me check internally if we can recommend and support it.
Allright
It's recommended to not use special characters when working with software.
But is it possible to use special characters?
Two instances for which products? Enterprise manager and Veeam backup & Replication?
Yes Enterprise manager and Veeam backup & Replication
As for MSSQL, it's a manual task.
Allright
Best,
Fabian
-
- Enthusiast
- Posts: 43
- Liked: 1 time
- Joined: May 30, 2023 12:58 pm
- Contact:
Re: Veeam v12 postgresql questions
anyone else to help?
-
- Product Manager
- Posts: 10100
- Liked: 2696 times
- Joined: May 13, 2017 4:51 pm
- Full Name: Fabian K.
- Location: Switzerland
- Contact:
Re: Veeam v12 postgresql questions
Hi Joshima
Still checking on the questions about special chars and autovacuum.
You can configure allowed connections in the ph_bha.conf file.
Best,
Fabian
Still checking on the questions about special chars and autovacuum.
You can use the same instance.Yes Enterprise manager and Veeam backup & Replication
Default configuration with the PostgreSQL server installed by Veeam is to only allow local host connection.Yes only allowing localhost.
You can configure allowed connections in the ph_bha.conf file.
Best,
Fabian
Product Management Analyst @ Veeam Software
-
- Product Manager
- Posts: 10100
- Liked: 2696 times
- Joined: May 13, 2017 4:51 pm
- Full Name: Fabian K.
- Location: Switzerland
- Contact:
Re: Veeam v12 postgresql questions
Hello Joshima
But we still recommend to not use it.
No need to enable it.
Best,
Fabian
Special chars are supported as long they are supported by PostgreSQL.special chars
But we still recommend to not use it.
I checked again. While it is not set up in the config file, autovacuum is already enabled by default.autovacuum
No need to enable it.
Best,
Fabian
Product Management Analyst @ Veeam Software
-
- Enthusiast
- Posts: 43
- Liked: 1 time
- Joined: May 30, 2023 12:58 pm
- Contact:
Re: Veeam v12 postgresql questions
thank you very much
Who is online
Users browsing this forum: No registered users and 62 guests