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
