Postgres Pro
Downloads
Home   >   mailing lists

[NOVICE] Postgres authentication to multiple application servers - Mailing list pgsql-novice

From padmini
Subject [NOVICE] Postgres authentication to multiple application servers
Date
Msg-id 1485300924227-5940791.post@n3.nabble.com
Whole thread Raw
Responses Re: [NOVICE] Postgres authentication to multiple application servers  (Wei Shan <weishan.ang@gmail.com>)
Re: [NOVICE] Postgres authentication to multiple application servers  (Moreno Andreo <moreno.andreo@evolu-s.it>)
List pgsql-novice
Tree view 
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.

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: [NOVICE] get error message of COPY command after using PQputCopyEnd
Next
From: Rita
Date:
Subject: [NOVICE] xpath query