Resolved Migrator - Unable to connect to the destination PostgreSQL database server.

[KDederichs]

Server operating system version

Ubuntu 20.04

Plesk version and microupdate number

18.0.62#2

Hey,

I wanted to run a migration from one Plesk Obsidian Server to another one (both Linux).

I'm having an issue though where the Pre Migration Check gives me this error:

Unable to connect to the destination PostgreSQL database server. Databases will not be transferred unless you restore the connection.
The following subscriptions are affected by the issue:

• foo.de

Please check the connection settings on the destination database server.

First time I ran the check that was OK (since I forgot to install Postgres) but after I installed it via the Plesk Installer and re-ran the check the error doesn't go away.

I checked with pg_isready is it says Postgres is running on the target server.

Anyone know what's up with that and how I can fix it?

Best regards,

 

[KDederichs]

Ok turns out you had to manually set a PG admin password for Plesk to recognise Postgres...

 

[Kaspar@Plesk]

Ok turns out you had to manually set a PG admin password for Plesk to recognise Postgres...

Good to read you where able to solve the issue. And thank you for sharing your solution.

 

[BigBlock]

I am having a very similar issue - but the database is created as is the user and tables but it appears that the user has no access to the tables!
It is a moodle installation - when going to the page it defaults to the install screen - indicating moodle either can't find the tables or database.

I can log in as the database user but get that no relations error trying to \d or \dt - I can switch to the database but still cannot describe tables or list data!
I can also connect using pgadmin - there I can list the tables in the user database but cannot access them or query data.

Furthermore - I cannot connect to the postgres server using the admin credentials (that I set in the pgsql setup) It also just gives me an either an authentication error or database does not exist!

 

[BigBlock]

update = ERROR: role "admin" cannot be dropped because some objects depend on itDETAIL: owner of database domain_moodle5 objects in database domain_moodle5