Problem with connection to host (wrong host)

On 3/31/18 11:44, Mike Martin wrote:

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
<http://192.168.0.0/32&gt;            ident

This entry should probably be something like

192.168.0.0/24

Writing .0/32 doesn't make much sense.

# IPv6 local connections:
host    all             all             127.0.0.1/32
<http://127.0.0.1/32&gt;            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

.3 is the host you are connecting to, as seen from the client.

.2 is the host your connection is coming from, as seen from the server.

--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

On Sat, Mar 31, 2018 at 11:44 AM, Mike Martin <redtux1@gmail.com> wrote:

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

*>So a bit confused, is psql ignoring the host parameter It is not ignoring
your entry, you simply have not entry for the laptop you are connecting
from,So simply add the following:*
*host all all 192.168.0.2/32
ident * <- note, you may have to change the authentication
method depending on your environment

--
*Melvin Davidson*
*Maj. Database & Exploration Specialist*
*Universe Exploration Command – UXC*
Employment by invitation only!