pg_upgrade and umask
От | Bruce Momjian |
---|---|
Тема | pg_upgrade and umask |
Дата | |
Msg-id | 20120309151010.GA5630@momjian.us обсуждение исходный текст |
Ответы |
Re: pg_upgrade and umask
Re: pg_upgrade and umask |
Список | pgsql-hackers |
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? -rwx------ 1 postgres postgres 41 Mar 9 09:59 delete_old_cluster.sh* -rw------- 1 postgres postgres 6411 Mar 8 21:56pg_upgrade_dump_all.sql -rw------- 1 postgres postgres 5651 Mar 8 21:56 pg_upgrade_dump_db.sql -rw------- 1 postgrespostgres 738 Mar 8 21:56 pg_upgrade_dump_globals.sql -rw------- 1 postgres postgres 1669 Mar 8 21:56 pg_upgrade_internal.log-rw------- 1 postgres postgres 1667 Mar 8 21:56 pg_upgrade_restore.log -rw------- 1 postgres postgres1397 Mar 8 21:56 pg_upgrade_server.log -rw------- 1 postgres postgres 385 Mar 8 21:56 pg_upgrade_utility.log The umask would also affect files it copies like clog and the data files, but those already have only postgres permissions. The downside is that users running pg_upgrade with 'su' or 'RUNAS' would need to use those to inspect the log files for errors. FYI, delete_old_cluster.sh probably has to be run as root, but root seems able to run an executable that it doesn't own. I am thinking it isn't worth the complexity of using umask and restricting those files, but wanted opinions. -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. +
В списке pgsql-hackers по дате отправления: