Re: [GENERAL] Tips on maintaining several pg_hba files

2017-01-25 Thread Michael Paquier
On Thu, Jan 26, 2017 at 2:36 AM, Alfredo Palhares wrote: > I have a PostgreSQL cluster with several ROLES that access the node > according to his state. > > On the master node, I only want the roles that need to write and the admins. > On the synchronous node i would want only roles with read a

[GENERAL] Tips on maintaining several pg_hba files

2017-01-25 Thread Alfredo Palhares
Hello everyone, I have a PostgreSQL cluster with several ROLES that access the node according to his state. On the master node, I only want the roles that need to write and the admins. On the synchronous node i would want only roles with read access that require the most up to date data, and t