Postgres server not listening

Question

I'm trying to connect with my client (Macbook Pro) to a Postgres Database located in another PC in the same network (Ubuntu) I can see the database from the host with pgAdmin, connecting to localhost, but I can't see from the client.

I've allowed all the connections in pg_hba.conf and postgresql.conf

I'm trying to connect from the client through pgAdmin to the IP server where the database is stored (192.168.1.34) and port 5432

And I get this error What do I'm doing wrong?

Am I missing something

After reading suggestions, I can say: On the ubuntu machine (home test server) I have no firewall. Postgres is running.

I've tried from the ubuntu console to access to the database: psql -h 127.0.0.1 mydatabase postgres and can connect (which means that the server is running and username is ok) But if I try to access the same database, from the same machine, changing localhost with the IP, I can not connect. Should not be psql -h 127.0.0.1 mydatabase postgres the same as psql -h 192.168.1.34 mydatabase postgres when I connect from the server?

Maybe is in loopback, as Alain suggested?

Answer 1

You have allow postgresql to accept request from outside network. To do that you have to change two files located at /etc/postgresql/{version_code}/main First one is pg_hba.conf, open and

change host all all ::1/128 md5 to host all all 0.0.0.0/0 md5

Second one is postgresql.conf, open and

change listen_address = 'localhost' to listen_address = '*'

Now restart the postgre server.