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.