Re: problems connecting remote postgresql server

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.

In response to

Responses

Browse pgsql-novice by date

  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