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@yahoo.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.
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
--
Mandhana Abhishek R.
http://abhishekrm.googlepages.com
