Errors installing with Postgres

Published 17 days ago

Hi, just followed your guide to install the server with postgres bare metal on a fresh debian 13 machine but i am getting some erorrs during the phase Running the installation at point 1:

After running the commands i got those errors at the end:

1) "Update-DPSDatabase -ConnectionString $ConnectionString -InstallationPath $DVLSPath"

Update-DPSDatabase: 42501: permission denied for table pg_cast

WARNING: Update failed.

2) "New-DPSWorkspaceSettings -ConnectionString $ConnectionString"

New-DPSWorkspaceSettings: 42P01: relation "dbo.databaseinfo" does not exist

POSITION: 8

New-DPSWorkspaceSettings: Error while initializing database settings.

3) "New-DPSAdministrator -ConnectionString $ConnectionString -Name $DVLSAdminUsername -Password $DVLSAdminPassword -Email $DVLSAdminEmail"

New-DPSAdministrator: 42P01: relation "dbo.usersecurity" does not exist

POSITION: 15

New-DPSAdministrator: 42P01: relation "dbo.useraccount" does not exist

POSITION: 15

New-DPSAdministrator: This NpgsqlTransaction has completed; it is no longer usable.

I think there is something missing from the guide

All Comments (1)

Jeremie Perreault

Published 17 days ago

Hi nicolosantorso,

Thank you for the detailed report, and sorry for the trouble.

You were right that a step was missing: the first schema creation, done by Update-DPSDatabase, needs the Devolutions Server role to have the PostgreSQL SUPERUSER attribute. The other two errors (dbo.databaseinfo and dbo.useraccount / dbo.usersecurity do not exist) come from that first failure: the schema was never created.

The guide now covers this: https://docs.devolutions.net/server/kb/how-to-articles/devolutions-server-for-linux/

We have also opened an internal ticket to remove the superuser requirement during installation.

To fix your current install:

1. Drop the partially created database, then recreate it, keeping the same owner.

2. Give the role superuser rights:

ALTER ROLE <dvls_user> SUPERUSER;

3. Run Update-DPSDatabase, New-DPSWorkspaceSettings and New-DPSAdministrator again.

4. Once installation is complete, remove the superuser right:

ALTER ROLE <dvls_user> NOSUPERUSER;

Let us know if you run into anything else.

Best regards,

Jérémie Perreault