pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Kris Deugau <kdeugau@vianet.ca>
To: pgsql-admin@postgresql.org
Subject: Need reference doc on precedence/ordering for pg_hba.conf
Date: Wed, 01 Mar 2006 17:14:27 -0500
Message-ID: <44061CC3.1070300@vianet.ca> (raw)

In particular, something quite a bit more verbose than the offical docs 
on www.postgresql.org/docs (which are good, but not quite detailed 
enough for me to unravel which entry in one particular pg_hba.conf is 
taking precedence, and how to add several new entries that won't break 
anything else).  Every experiment I've tried has *almost* worked in the 
manner I'm understanding from every bit of documentation I've found, but 
something always breaks.  :(

Failing that, a diagnostic poke to the head to tell me where in this 
config I should put entries that refer to both local socket connections 
and remote TCP/IP connections for one specific database that I want MD5 
(or crypt, for the old 6.x client :/  ) authentication on:

=========
# From Debian Sarge stock install
local   all         postgres       ident sameuser
local   all         all            ident sameuser

# Added for local software using PG
local   template1   all            ident
local   sameuser    all            md5
local   all         root           trust

# More entries from stock Debian package
host    all   all   127.0.0.1   255.255.255.255   ident sameuser
host    all   all   ::1  ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff 
ident sameuser
host    all   all   ::ffff:127.0.0.1/128         ident sameuser

# another local config - the real entry contains a real IP
host    all   all   [host IP]    255.255.255.255   trust

# Last stock entry
host    all   all   0.0.0.0      0.0.0.0           reject
=========

(Comments trimmed out, whitespace mostly compacted;  linewraps are not 
present in the real file - but my new entries don't function as expected 
when I put them where I *think* they should go.)

-kgd



view thread (3+ messages)  latest in thread

Message-ID: <44061CC3.1070300@vianet.ca>
Permalink:  ../44061CC3.1070300@vianet.ca/
Also on:    postgresql.org/message-id/44061CC3.1070300@vianet.ca

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: kdeugau@vianet.ca
  Subject: Re: Need reference doc on precedence/ordering for pg_hba.conf
  In-Reply-To: <44061CC3.1070300@vianet.ca>
  References: <44061CC3.1070300@vianet.ca>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox