[GENERAL] Tips on maintaining several pg_hba files - Mailing list pgsql-general

From Alfredo Palhares
Subject [GENERAL] Tips on maintaining several pg_hba files
Date
Msg-id CACrzeDGOyaVf7=RFO5CCgadikk8=zc94ziLeO9JGso3yKMZ3MA@mail.gmail.com
Whole thread Raw
Responses Re: [GENERAL] Tips on maintaining several pg_hba files
List pgsql-general
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 the admins
On the asynchronous node allow roles with read acess, and users to debug the system.


So I will probably bee templating the pg_hba.conf file since there are common roles between the systems.
Do you guys have any suggestions on this? Links? 

Does pg_hba support to include files?


Regards,
Alfredo Palhares

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] psql only works with -h (even localhost)
Next
From: Shailesh Singh
Date:
Subject: Re: [GENERAL] Fwd: I could not see any row in audit table