pg_hba.conf error with PostgreSQL

[pablogosse]

Hi all. I'm getting the following error when attempting to connect to a PostgreSQL db:

Warning: pg_connect() unable to connect to PostgreSQL server: FATAL 1: No pg_hba.conf entry for host 142.207.144.126, user unbc, database unbc in /u1/trng/gateway/_upload/file_upload_test.php on line 10

I thought that it might be a problem with the user 'unbc' but I dropped the user and recreated it with the following:

create user unbc encrypted password 'unbc' nocreatedb nocreateuser;

but I'm still getting the error whenever I try to connect. Here's the connection string:

$dbh = pg_connect("host=waddington.unbc.ca dbname=unbc user=unbc password=****");

Does anyone know why there is no entry for this info in the pg_hba.conf file?

Thanks in advance,
Pablo

[ultraslacker]

By default, postgres will not allow remote conntections. You have to specify them. Add lines to pg_hba.conf to suit your security preference and send hangup signal to postmaster.

This line will use encrypted password check for users coming from any ip (rather lax).
host all 0.0.0.0 0.0.0.0 md5

Read the notes in pg_hba.conf for more info.