[MLUG] Postgres Authentication On Fedora 7 - AMD64
lloy0076 at adam.com.au
Sat Nov 3 17:45:47 CST 2007
* Explains the hba.conf file which Postgres uses to authenticate.
* Discusses how to get Postgres to listen on a TCP/IP socket (although I
note that you've already worked that out; this is just so that someone
finding this on a search engine doesn't need to do two lookups)
Here's what the first link indicates as a template:
host database user CIDR-address auth-method [auth-option]
host all all 0.0.0.0/0 password
You'll need to get Postgresql to re-read its config (given you probably
have no users of it at the moment, you could just evilly restart it).
That's not really "good" advice, you probably want:
NOTE: Consider using md5 or crypt, and consider the implications of SSL
vs unencrypted connections.
NOTE 2: pg_hba.conf is in your pgsql/data directory
More information about the linuxsa