PowerShell script exchange
Post Reply
dali@iae.nl
Enthusiast
Posts: 81
Liked: 17 times
Joined: Jan 17, 2022 10:31 am
Full Name: Da Li
Contact:

Set-VBRPSQLDatabaseServerLimits : Unable to automatically configure remote PostgreSQL database on host

Post by dali@iae.nl »

Physical VBR host with local SQL Express VBR Database.
There was no Enterprise Manager installed.
Did a fresh install of Enterprise Manager for ISO 12.0.0.1420_20230413. This automatically installed PostgreSQL for the EM database.

Now want to migrate VBR MS SQL to Postgres.
Powershell: Set-VBRPSQLDatabaseServerLimits
First try was done with a MFA-enable Veeam Account: this gave a error.
Second try with non-MFA-enabled VBR Account this give the error:

PS C:\Users\sa_veeam> Set-VBRPSQLDatabaseServerLimits
Set-VBRPSQLDatabaseServerLimits : Unable to automatically configure remote PostgreSQL database on host <name of the locahost>
At line:1 char:1
+ Set-VBRPSQLDatabaseServerLimits
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [Set-VBRPSQLDatabaseServerLimits], Exception
+ FullyQualifiedErrorId : System.Exception,Veeam.Backup.PowerShell.Cmdlets.SetVBRPSQLDatabaseServerLimits


Any suggestions? Otherwise I will create a ticket.
dali@iae.nl
Enthusiast
Posts: 81
Liked: 17 times
Joined: Jan 17, 2022 10:31 am
Full Name: Da Li
Contact:

Re: Set-VBRPSQLDatabaseServerLimits : Unable to automatically configure remote PostgreSQL database on host

Post by dali@iae.nl »

Or do I first have to retore the database to Postgres and afterwards doing the Set-VBRPSQLDatabaseServerLimits?
Mildur
Product Manager
Posts: 9525
Liked: 2524 times
Joined: May 13, 2017 4:51 pm
Full Name: Fabian K.
Location: Switzerland
Contact:

Re: Set-VBRPSQLDatabaseServerLimits : Unable to automatically configure remote PostgreSQL database on host

Post by Mildur »

Hello Dali

Yes, please migrate the database first.
Let me know if the command works after that.

Best,
Fabian
Product Management Analyst @ Veeam Software
dali@iae.nl
Enthusiast
Posts: 81
Liked: 17 times
Joined: Jan 17, 2022 10:31 am
Full Name: Da Li
Contact:

Re: Set-VBRPSQLDatabaseServerLimits : Unable to automatically configure remote PostgreSQL database on host

Post by dali@iae.nl »

Yep, you first have to migrate the database.
But please, note the correct order in the manuals.
Also that you cannot migrate or run the cmdlet with MFA enabled.
And also that many times (read it more times) the connection with the hostname does not work, just fill in 127.0.0.1 in that case.
Mildur
Product Manager
Posts: 9525
Liked: 2524 times
Joined: May 13, 2017 4:51 pm
Full Name: Fabian K.
Location: Switzerland
Contact:

Re: Set-VBRPSQLDatabaseServerLimits : Unable to automatically configure remote PostgreSQL database on host

Post by Mildur »

Hi Dali

Thanks for the update.
wrote:But please, note the correct order in the manuals.
Will talk to the user guide team what we can do about.
Also that you cannot migrate or run the cmdlet with MFA enabled.
Our Powershell module requires a user without MFA.
And also that many times (read it more times) the connection with the hostname does not work, just fill in 127.0.0.1 in that case.
We are aware of it. I wrote a summary about the issue in our user community. It all depends on how you have configured the authentification settings on your PostgreSQL server. Our product doesn‘t configure those settings for you for a manually installed PostgreSQL server.
https://community.veeam.com/discussion- ... #post36043

Best,
Fabian
Product Management Analyst @ Veeam Software
Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests