Database

PostgreSQL Database Server Configuration

Tagged:

When you try to connect to a postgresql server from a fresh install(no configuration was changed) you will encounter the following error.

Access to database denied

The server doesn't grant access to the database: the server reports

FATAL: no pg_hba.conf entry for host "192.168.1.123", user "postgres", database "postgres", SSL off

I'm JR Galia, a JEE programmer, a web developer, a certified PhilNITS IT professional, a FOSS advocate and a proud alumnus of MSU-IIT and VSU.