simple remote user access question - pg_hda.conf

From: tj <tj(at)getlostspammer(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: simple remote user access question - pg_hda.conf
Date: 2003-10-09 22:17:03
Message-ID: z7lhb.3716$av5.2517@newsread3.news.pas.earthlink.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I can't seem to get the file configured correctly.

This works:
montgomery(at)spudbox1: psql mydb

This does NOT work:
montgomery(at)spudbox1:> psql -h 10.10.10.70 mydb
psql: FATAL 1: No pg_hba.conf entry for host 10.10.10.70, user montgomery,
database mydb

This does NOT work either:
montgomery(at)spudbox1:> psql -h 10.10.10.70 mydb -U montgomery
psql: FATAL 1: No pg_hba.conf entry for host 10.10.10.70, user montgomery,
database mydb

Ok, here's my setup:
host: "spudbox1"; 10.10.10.70 (database server, web server)
database: mydb (7.2.2); postmaster running with "-i".
user: montgomery (user was created on system, and also in db)

pg_hda.conf:
# TYPE DATABASE IP_ADDRESS MASK AUTH_TYPE
local all trust
host all 127.0.0.1 255.255.255.255 trust
host mydb 10.10.10.* 255.255.255.0 trust

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2003-10-09 22:25:27 Re: question about a select
Previous Message Marc G. Fournier 2003-10-09 21:42:56 Re: Response from MySql AB (Re: Humor me: Postgresql vs.