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

From: Andrew Martin <martin(at)biochemistry(dot)ucl(dot)ac(dot)uk>
To: The Hermit Hacker <scrappy(at)hub(dot)org>
Cc: hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] postmaster crash and .s.pgsql file
Date: 1998-01-29 14:29:46
Message-ID: 199801291429.OAA15708@bsmir06.biochem.ucl.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> On Thu, 29 Jan 1998, Andrew Martin wrote:
>
> > > > I would opt for /var/run to store the pid files and have the name set to
> > >
> > > That would assume that postmaster runs as root, which is not
> > > allowed...has to be in /tmp somewhere
> > >
> > > Maybe both should be under /usr/local/pgsql
> > I assume you mean the root of the installation rather than specifically
> > /usr/local/pgsql.
> >
> > > somewhere, so they will not be removed by any
> > > '/tmp'-clean-up-scripts.
> > >
> > In $PGDATA would seem as good as anywhere (maybe $PGDATA/.run or some such)
> >
> > /usr/local is mounted r/o on my system - $PGDATA lives elsewhere and is
> > writable.
>
> $PGDATA is created 700...general users need to be able to read the
> directory in order to connect to the socket, so we'd have to lax up
> security in order to accomplish this...
>
OK, no problem, a subdirectory of $PGDATA which has world read permission

Andrew

----------------------------------------------------------------------------
Dr. Andrew C.R. Martin University College London
EMAIL: (Work) martin(at)biochem(dot)ucl(dot)ac(dot)uk (Home) andrew(at)stagleys(dot)demon(dot)co(dot)uk
URL: http://www.biochem.ucl.ac.uk/~martin
Tel: (Work) +44(0)171 419 3890 (Home) +44(0)1372 275775

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1998-01-29 14:47:06 Re: [HACKERS] Profiling the backend (gprof output) [current devel]
Previous Message Darren King 1998-01-29 13:37:53 Re: [HACKERS] No: implied sort with group by