> Personally, I would make the configuration files 0644 by default.
> There's nothing in there that you can't get at in another way or which
> would matter to outsiders. I hope in the next release we make the
> unix_socket_permissions default to 0700 so the default setup is totally
> secure even if you messed up your pg_hba.conf.
I have an idea for the Unix socket file permissions and local 'trust'
permissoins as default. Right now we allow the socket permissions to be
set in postgresql.conf, but that seems like the wrong place for it.
Suppose we add an option to pg_hba.conf for 'local' connections called
'singleuser' and 'singlegroup' which set enable socket permissions only for the
postgres super-user or his group.
That way, we can ship the default pg_hba.conf file default as
'singleuser' and allow people to change it as they wish.
If people think this is a good idea, I will add it to the TODO list.
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026
