Re: whitelist ip for postgres

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Azimuddin Mohammed <azimeiu(at)gmail(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: whitelist ip for postgres
Date: 2018-03-14 06:00:17
Message-ID: 1521007217.2368.6.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Azimuddin Mohammed wrote:
> How can I whitelist few ip's in postgres. I have create a VIP with SNAT.
> The SNAT has 4 ips and no hostname and my VIP has a ip and a DNS name.

If "whitelist" means "allow connections from", you should configure pg_hba.conf:
https://www.postgresql.org/docs/current/static/auth-pg-hba-conf.html

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ricardo Martin Gomez 2018-03-14 10:32:18 RE: Permission issues. Please help
Previous Message Azimuddin Mohammed 2018-03-14 05:39:07 whitelist ip for postgres