Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_upgrade and umask - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_upgrade and umask
Date
Msg-id 29253.1331306311@sss.pgh.pa.us
Whole thread Raw
In response to pg_upgrade and umask  (Bruce Momjian <bruce@momjian.us>)
Responses Re: pg_upgrade and umask  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
Tree view 
Bruce Momjian <bruce@momjian.us> writes:
> What do people think of pg_upgrade setting its umask to 0077 so the log
> and SQL files are only readable by the postgres user?

+1 for restricting the log files, but I'm dubious that you should alter
the existing permissions on copied files in any way.

IOW, umask seems like the wrong tool.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: pg_upgrade and umask
Next
From: Peter Eisentraut
Date:
Subject: Re: pg_upgrade and umask