Postgres Pro
Downloads
Home   >   mailing lists

Problem with connection to host (wrong host) - Mailing list pgsql-general

From Mike Martin
Subject Problem with connection to host (wrong host)
Date
Msg-id CAOwYNKZ7LB0SV-U7avdJ2T6rRpTv5KZJ4VSJccgcF+r4VxWg8A@mail.gmail.com
Whole thread Raw
Responses Re: Problem with connection to host (wrong host)  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Re: Problem with connection to host (wrong host)  (Melvin Davidson <melvin6925@gmail.com>)
List pgsql-general
Tree view
Hi
I am just setting up a postgres server, details
Host 192.168.0.3
pg_hba.conf
# TYPE  DATABASE        USER            ADDRESS                 METHOD

# "local" is for Unix domain socket connections only
local   all             all                                     peer
# IPv4 local connections:
host    all             all             192.168.0.0/32            ident
# IPv6 local connections:
host    all             all             127.0.0.1/32            ident

host    all             all             ::1/128                 ident

postgresql.conf
listen_addresses-'*'

however when I try to connect from my laptop (ip 192.168.0.2) I get

psql -h 192.168.0.3 -U usevideo -W
Password for user usevideo:
psql: FATAL:  no pg_hba.conf entry for host "192.168.0.2", user "usevideo", database "usevideo", SSL off

So a bit confused, is psql ignoring the host parameter

thanks


pgsql-general by date:

Previous
From: Vijaykumar Jain
Date:
Subject: Re: Redacting params in PostgreSQL logs
Next
From: Peter Eisentraut
Date:
Subject: Re: Problem with connection to host (wrong host)