Le Vendredi 20 Décembre 2002 15:07, vous avez écrit :
> Where's the fault?
> I started Postgres with the -i option for tcp/ip sockets!
> Hope for answers!
1) Try modifying /var/lib/pgsql/data/postgresql.conf and set TCP_IP socket to
true. This will start PostgreSQL with -i option automatically.
2) Modify /var/lib/pgsql/data/pg_hba.conf and set the following line
# TYPE DATABASE IP_ADDRESS MASK AUTH_TYPE
AUTH_ARGUMENT
local all trust
host all 127.0.0.1 255.255.255.255 trust
host all client_ip 255.255.255.0 trust
repace client_ip with your client IP. This will accept all connections from
your client_ip.
3) Type "/etc/init.d/postgresql restart"
You should be able to connect using psql under Linux and pgAdmin under
Windows. Does it make it?
/Jean-Michel