Re: [NOVICE] 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
clientsto 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
blockingit.  I’m sure I’m missing something.  pg_ident.conf is not being used, and is functionally blank. 
>
> Any advice appreciated.
>
>
> Cheers, Bee
>
>
>
>
>
>