| 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: | Whole Thread | Raw Message | 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
| 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. |