PostgreSQL: error with pg_hba.conf

Question

I am trying to connect with Django to a PostgreSQL database I set up on a remote machine.

I get the following error:

django.db.utils.OperationalError: FATAL:  no pg_hba.conf entry for host "::1", user "user1", database "ttio", SSL off

Here is my pg_hba.conf file:

 local samerole all        md5
 host samerole all  127.0.0.200   255.255.255.255   pam     pamservice=postgresql_cpses
 host samerole all  127.0.0.1   255.255.255.255   md5
 local all postgres        md5
 host all postgres  127.0.0.1   255.255.255.255   md5

I am running the database(Postgres 8.4) and my OS flavor is Centos.In my Ubuntu 15.04 local machine it works perfectly. Any solutions for this ?

Please, read the [documentation for `pg_hba.conf`](http://www.postgresql.org/docs/9.1/static/auth-pg-hba-conf.html) — Burhan Khalid, Jun 23 '15 at 07:57

score 2 · Accepted Answer · answered Jun 23 '15 at 08:04

You obviously do not have connection profile for user "user1" against database "ttio" on the machine. The only remote access that your pg_hba.conf currently specifies is for any user to the database with the same name as the user from address 127.0.0.200.

You need an entry like:

host ttio user1 <ip_address> <netmask>

The <ip_address> <netmask> combination is specific to your network configuration and refers to the IP address of the client.

PostgreSQL: error with pg_hba.conf

1 Answers1