>
> On Wed, 25 Feb 1998, Bruce Momjian wrote:
>
> > Now there is a bigger problem. pg_pwd is mode rw-rw-rw- because a COPY
> > is used to create it. Any ideas how to fix this? Copy sets the
> > permissions to this before it creates the file. It temporarily changes
> > the umask to create the file. If pg_pwd ever has data in it and it is
> > world-readable, it is unsecure.
> >
> > Anyone have a brilliant idea on a fix?
>
> Why, again, is COPY creating files 666? 600, IMHO, sounds more
> appropriate, but I imagine there has to be a reason why it is 666...
Because the owner is postgres, not the user running the psql copy
command.
--
Bruce Momjian | 830 Blythe Avenue
maillist@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026
+ If your life is a hard drive, | (610) 353-9879(w)
+ Christ can be your backup. | (610) 853-3000(h)