Re: Postgres authentication to multiple application servers

From: Wei Shan <weishan(dot)ang(at)gmail(dot)com>
To: padmini <sireesha(dot)padmini(at)gmail(dot)com>
Cc: pgsql novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Postgres authentication to multiple application servers
Date: 2017-01-25 08:39:08
Message-ID: CAFe9ZTopqw1ULBXN3=WyX23vQSpU0ExY8HB7oc3H3My4G3_0Bg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

It doesn't require restart. It requires reload only.

On 24 Jan 2017 23:36, "padmini" <sireesha(dot)padmini(at)gmail(dot)com> wrote:

> Hi All,
>
> We need to configure Postgres authentication for multiple application
> servers.The application servers are dynamic (Few will be brought down over
> a
> period and new servers will be added on adhoc basis).Also the servers IPs
> will be changed periodically.
>
> we cannot add/remove the application ips to pg_hba.conf file frequently as
> it requires restart of Postgres services.
>
> Please suggest the best authentication method in this case.We are planning
> to use trust in pg_hba.conf and control the access at db level using
> Username and password.
>
> Can we proceed with it?
>
> Regards,
> Padmini
>
>
>
>
>
> --
> View this message in context: http://postgresql.nabble.com/
> Postgres-authentication-to-multiple-application-servers-tp5940791.html
> Sent from the PostgreSQL - novice mailing list archive at Nabble.com.
>
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Moreno Andreo 2017-01-25 10:53:29 Re: Postgres authentication to multiple application servers
Previous Message Rita 2017-01-25 02:02:30 xpath query