pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Azimuddin Mohammed <azimeiu@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: whitelist ip for postgres
Date: Wed, 14 Mar 2018 07:00:17 +0100
Message-ID: <1521007217.2368.6.camel@cybertec.at> (raw)
In-Reply-To: <CAKUuFd4Bv_Z1Vb-OwC6R9YygJ-TcGBCTNqmEaZS0Q7frDFDmiA@mail.gmail.com>
References: <CAKUuFd4Bv_Z1Vb-OwC6R9YygJ-TcGBCTNqmEaZS0Q7frDFDmiA@mail.gmail.com>

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

view thread (2+ messages)

Message-ID: <1521007217.2368.6.camel@cybertec.at>
Permalink:  ../1521007217.2368.6.camel@cybertec.at/
Also on:    postgresql.org/message-id/1521007217.2368.6.camel@cybertec.at

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: laurenz.albe@cybertec.at, azimeiu@gmail.com, pgsql-admin@lists.postgresql.org
  Subject: Re: whitelist ip for postgres
  In-Reply-To: <1521007217.2368.6.camel@cybertec.at>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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