Postgres authentication to multiple application servers

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.