Re: Connecting to Postgres under Linux in VMWare from WindowsXP!!! (fwd)

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