pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedUser Management
5+ messages / 5 participants
[nested] [flat]
* User Management
@ 2003-01-07 12:34 Alan Gutierrez <ajglist@izzy.net>
0 siblings, 0 replies; 5+ messages in thread
From: Alan Gutierrez @ 2003-01-07 12:34 UTC (permalink / raw)
To: pgsql-admin
What user management applications are available to work with PostgreSQL. I'd
like to have users and and groups for my PostgreSQL based application.
^ permalink raw reply [nested|flat] 5+ messages in thread
* User management
@ 2019-05-27 07:58 Anjul Tyagi <anjul@ibosstech-us.com>
2019-05-27 08:01 ` Re: User management Flavio Henrique Araque Gurgel <fhagur@gmail.com>
2019-05-27 08:02 ` Re: User management Fabio Pardi <f.pardi@portavita.eu>
0 siblings, 2 replies; 5+ messages in thread
From: Anjul Tyagi @ 2019-05-27 07:58 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: User management
2019-05-27 07:58 User management Anjul Tyagi <anjul@ibosstech-us.com>
@ 2019-05-27 08:01 ` Flavio Henrique Araque Gurgel <fhagur@gmail.com>
1 sibling, 0 replies; 5+ messages in thread
From: Flavio Henrique Araque Gurgel @ 2019-05-27 08:01 UTC (permalink / raw)
To: Anjul Tyagi <anjul@ibosstech-us.com>; +Cc: pgsql-admin
> 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.
Yes, use a specific pg_hba.conf for each server.
Flavio Gurgel
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: User management
2019-05-27 07:58 User management Anjul Tyagi <anjul@ibosstech-us.com>
@ 2019-05-27 08:02 ` Fabio Pardi <f.pardi@portavita.eu>
2019-05-27 08:26 ` Re: User management Deepak Pahuja . <deepakpahuja@hotmail.com>
1 sibling, 1 reply; 5+ messages in thread
From: Fabio Pardi @ 2019-05-27 08:02 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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*
>
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: User management
2019-05-27 07:58 User management Anjul Tyagi <anjul@ibosstech-us.com>
2019-05-27 08:02 ` Re: User management Fabio Pardi <f.pardi@portavita.eu>
@ 2019-05-27 08:26 ` Deepak Pahuja . <deepakpahuja@hotmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: Deepak Pahuja . @ 2019-05-27 08:26 UTC (permalink / raw)
To: Fabio Pardi <f.pardi@portavita.eu>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
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.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*
>
>
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2019-05-27 08:26 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-01-07 12:34 User Management Alan Gutierrez <ajglist@izzy.net>
2019-05-27 07:58 User management Anjul Tyagi <anjul@ibosstech-us.com>
2019-05-27 08:01 ` Re: User management Flavio Henrique Araque Gurgel <fhagur@gmail.com>
2019-05-27 08:02 ` Re: User management Fabio Pardi <f.pardi@portavita.eu>
2019-05-27 08:26 ` Re: User management Deepak Pahuja . <deepakpahuja@hotmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox