Resetting the Veeam builtin Postgre SQL Database password?

Hi ​@vAdmin while installing VBR software Postgre sql Database was installed as a built-in but why do we need to reset the password did you try to reset the password? Postgre SQL Database is installed as a built-in but why do we need to reset the password did you try to reset the password.

Hi ​@waqasali the password is required for the Entra ID backup since it uses the PostgreSQL as the repository.

You will get this error:

Hi ​@vAdmin so what is the best practice?  

Hi ​@vAdmin, you could try to add a specific account like mentioned in KB4542: "SSPI authentication failed for user". Maybe this would help you in this case.
 

let me check this ​@Dynamic 

This works for the config file mentioned.  Done it lots of times without issue.  Easiest way to get around the password issue.

Hi ​@vAdmin, perhaps you should take a look at this link for some vital information: https://www.atlassian.com/data/admin/how-to-set-the-default-user-password-in-postgresql 

FYI, the built-in Postgre SQL v15 that comes with Veeam Backup & Replication 12.3.0.310 only have this directory: 

C:\Program Files\PostgreSQL\15

Hence the steps described in KB4542: "SSPI authentication failed for user" may not work.

This is the evident from the C:\Program Files\PostgreSQL\15\installation_summary.log file.

Installation Directory: C:\Program Files\PostgreSQL\15

Server Installation Directory: C:\Program Files\PostgreSQL\15

Data Directory: C:\Program Files\PostgreSQL\15\data

Database Port: 5433

Database Superuser: postgres

Operating System Account: NT AUTHORITY\NetworkService

Database Service: postgresql-x64-15

Command Line Tools Installation Directory: C:\Program Files\PostgreSQL\15

Installation Log: ***unknown variable installationlogfile***

===== Installation completed at: 2024-12-05(YYYY-MM-DD) - 16:52:55(HH:MM:SS) =====

                            

​@Iams3le , ​@Chris.Childerhose & ​@Dynamic ,

I will use and download a separate Postgre SQL v15 from PostgreSQL: Windows installers page and let you know the progress.

FYI: The upgrade process has failed:

I would contact support in this case.

OK, it turns out to be there is already an existing Postgre SQL running in the Backup server as the default instance.

That would be why then. 😉

Glad you figured it out.

Since your initial question was on a specific use-case, it would have been difficult to figure out here. I am glad you could figure this out by digging deep into the log and for sharing the resolution with the community.