Re: [GENERAL] Allow login on slave only - Mailing list pgsql-general

From Tom Lane
Subject Re: [GENERAL] Allow login on slave only
Date
Msg-id 13245.1481905709@sss.pgh.pa.us
Whole thread Raw
In response to [GENERAL] Allow login on slave only  ("Andomar" <andomar@aule.net>)
List pgsql-general
"Andomar" <andomar@aule.net> writes:
> We run a master server and a hot standby server. Reporting users login to
> the standby server to run long queries. However, their login is also valid
> on the master server. Is it possible to prevent a user from logging in to
> the master server?

You could use different pg_hba.conf files on master and slave.  Or there's
always packet filtering...

            regards, tom lane


pgsql-general by date:

Previous
From: Sherrylyn Branchaw
Date:
Subject: Re: [GENERAL] Allow login on slave only
Next
From: Tom DalPozzo
Date:
Subject: Re: [GENERAL] tuple data size and compression