Regarding "Installing PostgreSQL on Windows"

[ChrisLang83]

Summary

Cannot connect to the database

Where did you see the problem?

https://github.com/EnterpriseDB/docs/blob/2cef36012173c522a9ee9972cd99d14203bf9690/advocacy_docs/supported-open-source/postgresql/installing/windows.mdx

Hi,

Downloaded and installed postgres version 18.2 on Thursday 12th Feb, however after installing postgres we could not connect to the database via PgAdmin locally on a virtual server or from our client devices using teh postgres superuser account. The error message stated the user was not authorised to connect to the database, however the credentials were correct and the hba_conf file untouched. A full uninstallation and then reinstallation of 18.2 did not remedy the issue. Uninstalled 18.2 again and installed 18.1 and was able to establish a connection successfully.

connection failed: connection to server at "xx", port 5433 failed: FATAL: no pg_hba.conf entry for host "xx", user "postgres", database "postgres", no encryption

Expected behavior

Able to login to the database successfully

Screenshots

No response

Browser / Platform

Windows Server 2019

Additional notes

No response