microsoftlearning / mslearn-postgresql

PostgreSQL Exercises

This repository contains the instructions and files to support PostgreSQL exercises in Microsoft Learn modules.

mslearn-postgresql's Issues

Lab 11: Connect to source issue - Online Migration Wizard

Module: 00

Lab/Demo: 11

Task: Create a Database Migration Project

Step: 04

Description of issue

When trying to connect to the local server I receive an error message:

Error type

    Failed to connect, please check error details

Error Detail
    Connection failed.
    Exception while connecting
    No connection could be made because the target machine actively refused it

I have created a Firewall outbound rule for the used port (5433 in this case because the default 5432 is being used by PostgreSQL 16 while I'm doing this lab with PostgreSQL 14) and enabled TLS security protocol in the postgresql.conf file, but I still can't establish a connection. I have also managed to import the database schema from the source database to the flexible server.

Repro steps:

Lab 10: Connect to source issue

Module: 00

Lab/Demo: 10

Task: Create Database Migration Project in Azure Database for PostgreSQL Flexible Server

Step: 04

Description of issue

After importing the users and roles from the local server to the flexible server, I could not connect to source when creating the Migration project in the Azure Portal. I tried using both the postgres superuser and the pgadmin user created without a superuser role but both options return an error Failed to connect to server : Authentication failed. The provided password is incorrect. Please confirm it and try again. I've triple checked the passwords and they both work when connecting locally to the database, so I'm sure they're correctly typed in the configuration step.

Repro steps: