Hello
I'm running postgres-6.4.2 on one machine, and want to access it from
another, but get the error message
% psql -h vsop rndprojectdb
Connection to database 'rndprojectdb' failed.
User authentication failed
vsop is remote host
rndprojectdb is database
(above command run as user postgres, database rndprojectdb owned by user
postgres.)
I have edited the /usr/local/pgsql/data/pg_hba.conf with:
local all trust
host all 10.123.10.0 255.255.255.255 trust
host all 192.168.10.0 255.255.255.255 trust
I know it's using the correct port 5432, and that the postmaster is
listening, and reading pg_hba.conf.
(running on Irix 6.2)
Any help would be appreciated.............thanks
Jean
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Jean Lee
Software Developer mailto:jean@cinesite.co.uk
Cinesite (Europe) Ltd. Telephone: 0171 973 4000
9 Carlisle Street Direct: 0171 973 4077
London W1V 5RG Fax: 0171 973 4040