[HACKERS] ALTER SYSTEM for pg_hba.conf
От | Simon Riggs |
---|---|
Тема | [HACKERS] ALTER SYSTEM for pg_hba.conf |
Дата | |
Msg-id | CANP8+jL=ygWCrpiaCxNn9kjEwwF3XbyeQ27000zZh9945QiDoA@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: [HACKERS] ALTER SYSTEM for pg_hba.conf
|
Список | pgsql-hackers |
My next thought is ALTER SYSTEM support for pg_hba.conf, especially since that would make it easier to do a formal test of Haribabu's pg_hba view patch by adding each of the options one by one and then juggling them. ALTER SYSTEM ENABLE [LOCAL | REMOTE] ACCESS FOR [DATABASE <name> | REPLICATION ] [USER <name> ] [NETWORK {ADDRESS [NETMASK] | hostname] [options] USING <authentication-method> [WITH [[NO] ENCRYPTION] [PRIORITY n]] ....and we can then have a nice simple ALTER SYSTEM ENABLE REMOTE ACCESS FOR REPLICATION USING md5; into which we can tie any required parameters (i.e. one command to enable replication) Note that the keyword HOST would be replaced by REMOTE and SSL by ENCRYPTION to make it clearer. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
В списке pgsql-hackers по дате отправления: