Обсуждение: User management
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
> 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
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* > >
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
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
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*
>
>
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*
>
>