Re: [INTERFACES] pg_pwd

On Sat, 20 Nov 1999, Tom Lane wrote:
> As I commented earlier in this thread, I think COPY ought not create
> files with looser permissions than 644 (does anyone know why that's
> not true already?).  But that still wouldn't be good enough for pg_pwd.
> Maybe it would be worthwhile to try to force pg_pwd in particular
> to be written with just mode 600.  In the standard configuration that
> shouldn't make any difference ... 

Hmmm... Can a parameter be passed to COPY giving the file create mode?  A
one-time hack to make pg_pwd only do something special sounds inelegant.

>but if people are going to use
> hacked-up initdb code, as you evidently are doing, we probably should
> not rely on the data directory to be locked up tightly...

Just 'initdb --pglib=/usr/lib/pgsql --pgdata=/var/lib/pgsql'  /var/lib/pgsql is
created during the rpm installation of the server rpm -- and I can force that
to create mode 0700.  HOWEVER, that just fixes the symptom -- not the problem.

--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11