[MLUG] Postgres Authentication On Fedora 7 - AMD64

David Lloyd 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 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:

* http://linux.die.net/man/1/pg_ctl


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 mailing list