Skip site navigation (1) Skip section navigation (2)

Re: Unable to set postmaster to accept TCP/IP Connection

From: "Abhishek MANDHANA" <abhishekrm(at)gmail(dot)com>
To: "Jose Esquivel" <josearesvi(at)yahoo(dot)com>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Unable to set postmaster to accept TCP/IP Connection
Date: 2008-05-25 08:06:27
Message-ID: 9f1c18890805250106q306e434p38aff57dcf40a02e@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-support
Hi,

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
file.

Save it and I hope you could get back to work..For me this worked.

Cheers,
Abhi






On Sat, May 24, 2008 at 10:21 PM, Jose Esquivel <josearesvi(at)yahoo(dot)com>
wrote:

> Hi,
>
> 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:
> http://www.postgresql.org/mailpref/pgadmin-support
>
>


-- 
Mandhana Abhishek R.
http://abhishekrm.googlepages.com

In response to

pgadmin-support by date

Next:From: Guillaume LelargeDate: 2008-05-25 08:46:04
Subject: Re: Unable to set postmaster to accept TCP/IP Connection
Previous:From: Jose EsquivelDate: 2008-05-24 20:21:09
Subject: Unable to set postmaster to accept TCP/IP Connection

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group