Re: User management

From: "Deepak Pahuja (dot)" <deepakpahuja(at)hotmail(dot)com>
To: Fabio Pardi <f(dot)pardi(at)portavita(dot)eu>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: User management
Date: 2019-05-27 08:26:24
Message-ID: BN6PR10MB13305FCD0A6FAE31A7CBF686D61D0@BN6PR10MB1330.namprd10.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

You can also control the connectivity at application layer by using the tokens to connect to read only servers itself at the beginning. This can take care of failover scenerios as well

Thanks
Deepak

Get Outlook for Android<https://aka.ms/ghei36>

________________________________
From: Fabio Pardi <f(dot)pardi(at)portavita(dot)eu>
Sent: Monday, May 27, 2019 4:02:27 PM
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: User management

Hi Anjul,

while not handy in case of failovers, you can easily handle it from
pg_hba.conf

regards,

fabio pardi

On 5/27/19 9:58 AM, Anjul Tyagi wrote:
>
> Is there to block the user on primary server and only access to
> replication server?
>
> We want to move all the read-only individual users to replication
> server, so that primary server will be available for application only.
>
>
>
>
>
> Regards,
>
> Anjul *TYAGI*
>
> * *
>
> *ü** **Go Green*
>
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Alexandre hadjinlian guerra 2019-05-27 19:05:05 JDBC know issues migrating between PG 9.3 to 11
Previous Message Fabio Pardi 2019-05-27 08:02:27 Re: User management