From: | developer_student <juamagb1(at)gmail(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: problems connecting remote postgresql server |
Date: | 2006-09-16 10:51:16 |
Message-ID: | 6338797.post@talk.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | developer_student | 2006-09-16 10:54:41 | Re: problems connecting remote postgresql server |
Previous Message | ajay kamath | 2006-09-15 18:55:35 | Help needed - error while adding geometry |