Re: [HACKERS] postmaster crash and .s.pgsql file

>
> On Thu, 29 Jan 1998, The Hermit Hacker wrote:
>
> > On Thu, 29 Jan 1998, Brook Milligan wrote:
> >
> > > No, "normal" users shouldn't be allowed to do so, obviously. But, are
> > > there real systems in which a database maintainer (i.e., user
> > > postgres) cannot cooperate with the system admin (i.e., user root) to
> > > accomplish this? In practice, is it really envisioned that postgres
> > > should be _so_ distinct from the system? For example, don't most
> > > people run the postmaster from the system startup scripts, and isn't
> > > that the same thing? How did those commands get inserted into the
> > > startup scripts if not by root?
> >
> > I do not feel that it is appropriate for a non-root program (which
> > PostgreSQL is) to require a systems administrator to make permissions
> > related changed to a directory for it to run, period.
> >
> >
> >
> Speaking of feelings, I'm not especially happy about allowing any old
> user to trash a key file because it's located in a globally writable
> directory.
>
> Would setting the sticky bit on the permissions of the /tmp directory
> help?

Most OS's or good administrators already have the sticky bit set on
/tmp, or they should. If they don't, the PostgreSQL socket file is the
least of their worries.

--
Bruce Momjian
maillist(at)candle(dot)pha(dot)pa(dot)us