Re: Login from Remote Client

Hello.

You need to modify the parameter listen_addresses on postgresql.conf, it
can be something like this:

listen_addresses = 'localhost, PrivateIPOfMachine'

If the IP of the machine is 192.168.1.3 then the parameter should be like this:

listen_addresses = 'localhost, 192.168.1.3'

Restart the server and after that PostgreSQL is going to start listening for petitions on that IP and you can connect clients to it.

Cheers!

El 09/08/2017 a las 04:43 p. m., Bee.Lists escribió:
> Hi folks.
>
> Using a LAN tool, I can’t seem to see my LAN server sharing psql. It works on the machine (I can ssh and use it just fine) but the port 5432 isn’t open.
>
> I’ve modified the pg_hba.conf as such:
>
> host all user1 192.168.1.9 md5
> host all user2 192.168.1.9 md5
>
> The postgresql.conf file was also edited:
>
> listen_addresses = 'localhost' # what IP address(es) to listen on;
> port = 5432 # (change requires restart)
> max_connections = 100 # (change requires restart)
> superuser_reserved_connections = 3 # (change requires restart)
>
> password_encryption = on
>
> I’m not sure why I can’t even see the port open, and there is no firewall. It’s on the LAN, and the router isn’t blocking it. I’m sure I’m missing something. pg_ident.conf is not being used, and is functionally blank.
>
> Any advice appreciated.
>
>
> Cheers, Bee
>
>
>
>
>
>