Received: from perio.unlp.edu.ar (IDENT:root@perio.unlp.edu.ar [163.10.16.2])
	by hub.org (8.9.3/8.9.3) with ESMTP id WAA18046
	for <pgsql-interfaces@postgreSQL.org>;
	Fri, 19 Nov 1999 22:39:10 -0500 (EST)
	(envelope-from ser@perio.unlp.edu.ar)
Received: from perio.unlp.edu.ar (modem82.way.com.ar [200.41.165.82])
	by perio.unlp.edu.ar (8.9.3/8.8.7) with ESMTP id AAA22099;
	Sat, 20 Nov 1999 00:12:54 GMT
Message-ID: <38361322.60590180@perio.unlp.edu.ar>
Date: Sat, 20 Nov 1999 00:18:58 -0300
From: "Sergio A. Kessler" <ser@perio.unlp.edu.ar>
X-Mailer: Mozilla 4.5 [en] (Win98; I)
X-Accept-Language: en
MIME-Version: 1.0
To: Tom Lane <tgl@sss.pgh.pa.us>
CC: Lamar Owen <lamar.owen@wgcr.org>,
	"pgsql-interfaces@postgreSQL.org" <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] pg_pwd
References: <3766.943051402@sss.pgh.pa.us>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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*.