Re: [GENERAL] Localhost vs. Unix Domain Sockets?

2014-08-18 Thread Matt S
> To put it another way, keeping the two sets of names distinct is incrementally more complex to manage. Which might be worth it if there really is any gain. Is this a "best practice," or is it really a manifestation of its closely-related cousin, the "silly practice?" :) It's ultimately up to y

Re: [GENERAL] Localhost vs. Unix Domain Sockets?

2014-08-18 Thread Matt S
I went through the same process a little while ago - worth reading is the pg_hba.conf documentation: http://www.postgresql.org/docs/9.1/static/auth-pg-hba-conf.html Specifically: * Don't enable "trust" auth (i.e. any OS user as any DB user) - that's rarely what you want on a multi-user machine. *