I am also a beginner and faced more or less similar type of problem using
PgAdmin III and did the following..
Chk out the path where your pg_hba.conf and other files where you wish to do
settings are located..
Go to this path and open it using text editor..You might have set the
configuration file a lot of times and with different possibilities to get it
work before you posted here and while you tried this configurations , they
get all stored in this configuration files ,Please remove all of them and
keeep only the one which you neeed..REmove also blank lines if any in this
Save it and I hope you could get back to work..For me this worked.
On Sat, May 24, 2008 at 10:21 PM, Jose Esquivel <josearesvi(at)yahoo(dot)com>
> My name is Jose Esquivel I'm form Costa Rica, I have been using PostgreSQL
> since my first steps as a system engineer. A few days ago one of the
> applications I developed stopped working, is a Java stand-alone application
> that uses the postgresql-8.0-311.jdbc3.jar driver to connect to a PostgreSQL
> 8.0 database. I installed the DB in a Windows XP in order to function as a
> server. These are the steps I executed in order to make the postmaster
> accept TCP/IP connection:
> 1- Log as the posgresql user.
> 2- Include the Ips of the computers that are going to connect to the server
> via TCP/IP in the pg_hba.conf file as follows:
> host all all 192.168.16.0/24 md5
> I used 192.168.16.0/24 because the computers that could ask for
> connections are: 192.168.16.1, 192.168.16.2, and 192.168.16.3.
> 3- Set the listen_addresses = '*' in the postgresql.conf
> 4- Stop the postmaster using the following command:
> pg_ctl -stop -D "C:\Program Files\PostgreSQL\8.0\data"
> 5- Start the postmaster using the following commad:
> pg_ctl -o -i -D "C:\Program Files\PostgreSQL\8.0\data"
> I attached the .conf files in case I missed something. The problem is that
> these steps used to work but now I have not been able to make it work again,
> I checked the network and I could ping all of the other computers. Could
> you please tell me if I am missing something or what am I doing wrong?
> Thanks a lot for your time.
> Yahoo! Deportes Beta
> ¡No te pierdas lo último sobre el torneo clausura 2008!
> Entérate aquí http://deportes.yahoo.com
> Sent via pgadmin-support mailing list (pgadmin-support(at)postgresql(dot)org)
> To make changes to your subscription:
Mandhana Abhishek R.
In response to
pgadmin-support by date
|Next:||From: Guillaume Lelarge||Date: 2008-05-25 08:46:04|
|Subject: Re: Unable to set postmaster to accept TCP/IP Connection|
|Previous:||From: Jose Esquivel||Date: 2008-05-24 20:21:09|
|Subject: Unable to set postmaster to accept TCP/IP Connection|