Postgres Pro
Downloads
Home   >   mailing lists

Re: Allow user to connect to replicas only - Mailing list pgsql-general

From hubert depesz lubaczewski
Subject Re: Allow user to connect to replicas only
Date
Msg-id 20220804135653.GA6811@depesz.com
Whole thread Raw
In response to Allow user to connect to replicas only  (Wiwwo Staff <wiwwo@wiwwo.com>)
List pgsql-general
Tree view 
On Thu, Aug 04, 2022 at 03:42:00PM +0200, Wiwwo Staff wrote:
> Is there any way to create a user allowed to connect to a/any read replica
> only, as in "not allowed to connect to primary"?

Sure. Modify pg_hba.conf on primary to disallow connections as this
user.

Best regards,

depesz

pgsql-general by date:

Previous
From: Wiwwo Staff
Date:
Subject: Allow user to connect to replicas only
Next
From: Danny Shemesh
Date:
Subject: Re: Index only scans for expressional indices when querying for the expression