Thread: User management

User management

From

"Anjul Tyagi"

Date:

27 May 2019, 10:58:34

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

Re: User management

From

Flavio Henrique Araque Gurgel

Date:

27 May 2019, 11:01:13

> 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
forapplication only.
 

Yes, use a specific pg_hba.conf for each server.

Flavio Gurgel

Re: User management

From

Fabio Pardi

Date:

27 May 2019, 11:02:27

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*
> 
>

Re: User management

From

"Deepak Pahuja ."

Date:

27 May 2019, 11:26:24

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

From: Fabio Pardi <f.pardi@portavita.eu>
Sent: Monday, May 27, 2019 4:02:27 PM
To: pgsql-admin@lists.postgresql.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*
>
>