Re:[NOVICE] Couple of PostgreSQL Questions

[Adam Tauno Williams <adam@xxxxxxxxxxxxxxxx>]

>I posted out my message this morning to the Postgesql-novice list.
>Below is the actual message and it's reply. Basically in a nutshell:
>1. There is no way to "hide" PostgreSQL port 5432 from prying eyes. If
>I don't want the world to see it, move it to an internal network server.

Well, except ipchains or netfilter?

>2. I *CAN* set it up to accept local connections only and disallow all
>others! (I've done this)

Cool.
 
>3. If I really wanted to be brutal about security I can even force
>passwords on the psql command! (suggested as an option)

Hmmm, does that auth via PAM or a password stored in the engine itself?  I'm
quesssing itself (at least with 7.0.2) since it doesn't put a file in /etc/pam.d
 
> 4. the postgresql.conf file is new for version 7.1.0+

Ah ha! Thats a better name than "pg_hba.conf".

Systems and Network Administrator
Morrison Industries
1825 Monroe Ave NW.
Grand Rapids, MI. 49505