Skip site navigation (1) Skip section navigation (2)

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

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: brook(at)trillium(dot)NMSU(dot)Edu (Brook Milligan)
Cc: hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] postmaster crash and .s.pgsql file
Date: 1998-01-29 21:23:41
Message-ID: 199801292123.QAA22040@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
> 
> > No.  Make /var/run writable by some group (e.g., group pidlog) and put
> > postgres (and other things like root or daemon or ..., whatever needs
> > to log pid files) in that group.
> 
>    We can't expect the user to be able to change /var/run permissions. 
>    Must be in pgsql/ or /tmp.
> 
> 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?

Well, we have to weigh the value of moving it to /var/run vs. the
hardship for people who don't have root access.  Even if only 5% don't
have root access, that is a lot of people.

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

In response to

pgsql-hackers by date

Next:From: Bruce MomjianDate: 1998-01-29 21:26:41
Subject: Re: [HACKERS] postmaster crash and .s.pgsql file
Previous:From: The Hermit HackerDate: 1998-01-29 21:20:53
Subject: Re: [HACKERS] postmaster crash and .s.pgsql file

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group