ALTER SYSTEM for pg_hba.conf

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: ALTER SYSTEM for pg_hba.conf
Date: 2017-01-04 20:17:37
Message-ID: CANP8+jL=ygWCrpiaCxNn9kjEwwF3XbyeQ27000zZh9945QiDoA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Pantelis Theodosiou 2017-01-04 20:22:50 Re: BUG #14486: Inserting and selecting interval have different constraints
Previous Message Simon Riggs 2017-01-04 20:10:45 Re: pg_hba_file_settings view patch