[MLUG] Postgres Authentication On Fedora 7 - AMD64

David Lloyd lloy0076 at adam.com.au
Sat Nov 3 17:45:47 CST 2007


Piers,

http://www.postgresql.org/docs/8.2/interactive/auth-pg-hba-conf.html

* Explains the hba.conf file which Postgres uses to authenticate.

http://www.postgresql.org/docs/8.2/interactive/runtime-config-connection.html#GUC-LISTEN-ADDRESSES

* 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:

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

DSL

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