Re: problems connecting remote postgresql server - Mailing list pgsql-novice

From developer_student
Subject Re: problems connecting remote postgresql server
Date
Msg-id 6338797.post@talk.nabble.com
Whole thread Raw
In response to problems connecting remote postgresql server  (developer_student <juamagb1@gmail.com>)
Responses Re: problems connecting remote postgresql server
List pgsql-novice
Yes, you were right at beginning.

Two files must be edited: pg_hba.conf and potgresql.conf

In pg_hba.conf , you must append a line like this:
host          all          all          123.123.123.123/32          md5

Remember to change 123.123.123.123 to the IP which must connect to the
database server.

In postgresql.conf, you can see at first a commented line like this:
#listen_addresses = 'localhost'        # what IP address(es) to listen on;
Then I changed it to:
#listen_addresses = '*'
This means every IP can connect to the database server.


An happily, everything worked!

P.D.: I want to thank the developers group and the forum people because of
their fantastic work and help.

Bye!
--
View this message in context:
http://www.nabble.com/problems-connecting-remote-postgresql-server-tf2264760.html#a6338797
Sent from the PostgreSQL - novice forum at Nabble.com.


pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Problem with template1 database
Next
From: developer_student
Date:
Subject: Re: problems connecting remote postgresql server