Re: Security question UNIX Sockets vs CIDR style access

From: Chris Browne <cbbrowne(at)acm(dot)org>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Security question UNIX Sockets vs CIDR style access
Date: 2009-06-01 16:40:12
Message-ID: 87bpp7hpqr.fsf@dba2.int.libertyrms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

kevink(at)consistentstate(dot)com (Kevin Kempter) writes:
> I'm looking for thoughts/feedback on the use of UNIX Sockets vs standard CIDR style access (i,e, Ident, MD5, etc) to a Postgres Cluster. What are the
> pros/cons, which is more secure and why, etc...

There is no single answer, which is essentially why there is the whole
array of access methods.

Each has reasons to be preferable under particular circumstances, and
there is a fair bit of documentation on this in the standard
documentation.

Please see:
http://www.postgresql.org/docs/8.3/static/auth-methods.html
--
let name="cbbrowne" and tld="linuxdatabases.info" in String.concat "@" [name;tld];;
http://cbbrowne.com/info/sgml.html
"Over a hundred years ago, the German poet Heine
warned the French not to underestimate the power of ideas:
philosophical concepts nurtured in the stillness of a
professor's study could destroy a civilization."
--Isaiah Berlin in /The Power of Ideas/

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2009-06-01 17:58:37 Re: rotating log files and adding timestamps to postgres logs
Previous Message Kenny W Drobnack 2009-06-01 16:34:25 rotating log files and adding timestamps to postgres logs