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

Re: [INTERFACES] pg_pwd

From: "Sergio A(dot) Kessler" <ser(at)perio(dot)unlp(dot)edu(dot)ar>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>, "pgsql-interfaces(at)postgreSQL(dot)org" <pgsql-interfaces(at)postgreSQL(dot)org>
Subject: Re: [INTERFACES] pg_pwd
Date: 1999-11-20 03:18:58
Message-ID: 38361322.60590180@perio.unlp.edu.ar (view raw or flat)
Thread:
Lists: pgsql-interfaces
Tom Lane wrote:
> 
> > in rh6.1 /var/lib/pgsql is 755 (and no, I haven't changed anything)
> > can you spell "2_KM_DIAMETER_HOLE" ?
> 
> In a standard setup, pg_pwd is inside .../pgsql/data which is mode 700.
> Have the RH guys really blown it this badly?  (Lamar?)

.../pgsql/data !?
I don't know who blown it, but I have:

dir   /var/lib/pgsql             mode 755 (now 700 changed by me, hope
                                           I'm not breaking something)

dir   /var/lib/pgsql/base        mode 700 (there is no one file here,
                                           just db-directories)

files /var/lib/pgsql/pg_*        mode 600 or 400 except pg_pwd :(


wich seem pretty logical except the mode of pg_pwd
(and the _clear_ passwds inside)
(and that "base" should be called "data" :)

-- 
-=  Sergio A. Kessler     ==    http://sak.org.ar  =-
You can have it soon, cheap and working; choose *two*.

In response to

pgsql-interfaces by date

Next:From: Tom LaneDate: 1999-11-20 06:26:35
Subject: Re: [INTERFACES] Front end memory consumption in SELECT
Previous:From: Douglas ThomsonDate: 1999-11-20 01:10:27
Subject: Front end memory consumption in SELECT

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