You'll want to make sure that after you modified the pg_hba.conf you reloaded PostgreSQL (either through pg_ctl reload, SIGHUP or by restarting the service entirely), plus there is a setting in the postgresql.conf file named 'listen_addresses' that must be uncommented and set appropriately for tcp/ip access to work. Read the header on the postgresql.conf file, it will explain a little bit about what to do when changing contents of that file, and note that modifying the 'listen_addresses' configuration option will require a full restart of the service. You'll also want to make sure to read and understand the relevant sections in the manual: http://www.postgresql.org/docs/8.1/interactive/client-authentication.htm l Good luck! Jason Minion ________________________________ From: pgsql-admin-owner@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of German Raul Hoyos Parravicino Sent: Wednesday, March 29, 2006 8:24 PM To: pgsql-admin@xxxxxxxxxxxxxx Subject: [ADMIN] Client Connection - PGAdmin Hello Everydoy.. I need help.... I have installed PostgreSQL in my LinuX -SUSE "postgresql-8.1.3.tar.gz" I start Postgre using "pg_ctl start -D/usr/local/database " After that I can connect PostgreSQL using psql DataBase. >psql DataBase ==> The problem occur when I tried to connect to the DataBase using Pg-Admin III . I have proved using "telnet IP 5432" and I get Connectio refused... I don't know what is wrong ?? I also modified the file pg_hba.conf , I write the IP of my PC, but nothing happend.. Is it possible that there is another process in PostgreSQL that I have to start Thanks for your help !!! -- Raul Hoyos Parravicino
