Re: Open 7.3 issues

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Peter Eisentraut <peter_e(at)gmx(dot)net>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Open 7.3 issues
Date: 2002-08-18 17:19:17
Message-ID: 24445.1029691157@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Nigel J. Andrews" <nandrews(at)investsystems(dot)co(dot)uk> writes:
> Daft question but isn't this an administrator's issue?

The feature wasn't going to change; the argument was just about whether
to change the factory-default permissions mask for the socket. An admin
could override the default in any case (and probably should, in many
cases).

The argument for 0700 was that it is "secure", the argument against
was that it's useless. No one sane runs their apps as the postgres
user, therefore you'd always be having to open it up anyway.

We thought a little about 0770 but the problem is that the actual
behavior is extremely context-dependent. On some Unixes this is
just what you want, on others it's little different from 0777.
In any case depending on group membership to control database access
means that the DBA *must* have root privileges, which is not an
assumption we like to make.

So unless someone comes up with a new idea, we're sticking with 0777
for backwards-compatibility reasons. But certainly socket permissions
ought to be on the short list of things to think about during every
database install.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Joe Conway 2002-08-18 19:02:43 Re: Remove implicit unique index creation on SERIAL columns?
Previous Message Vince Vielhaber 2002-08-18 17:13:17 Re: Open 7.3 items