pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedSetting wild card IP's on postgres
4+ messages / 3 participants
[nested] [flat]
* Setting wild card IP's on postgres
@ 2017-05-04 19:02 Gone, Sajan <SGone@lb.com>
2017-05-04 19:06 ` Re: Setting wild card IP's on postgres Samed YILDIRIM <samed@reddoc.net>
0 siblings, 1 reply; 4+ messages in thread
From: Gone, Sajan @ 2017-05-04 19:02 UTC (permalink / raw)
To: pgsql-admin
Hi,
I am trying to allow application connections from all the hosts starting with IP addresses 10.4.***
Is adding the following line on pg_hba.conf is appropriate to do so?
host xuser xdatabase 10.4.*.*/32 password
Are would I have to set the IP address in a different way?
Thank You,
Sajan Gone
Database Administrator
L Brands
Mobile #: 517-990-5282
Office #: 614-577-7622
________________________________
Notice: This communication may contain privileged and/or confidential information. If you are not the intended recipient, please notify the sender by email, and immediately delete the message and any attachments without copying or disclosing them. LB may, for any reason, intercept, access, use, and disclose any information that is communicated by or through, or which is stored on, its networks, applications, services, and devices.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Setting wild card IP's on postgres
2017-05-04 19:02 Setting wild card IP's on postgres Gone, Sajan <SGone@lb.com>
@ 2017-05-04 19:06 ` Samed YILDIRIM <samed@reddoc.net>
2017-05-04 19:10 ` Re: Setting wild card IP's on postgres Gone, Sajan <SGone@lb.com>
0 siblings, 1 reply; 4+ messages in thread
From: Samed YILDIRIM @ 2017-05-04 19:06 UTC (permalink / raw)
To: Gone, Sajan <sgone@lb.com>; pgsql-admin
<div>Hi Sajan,</div><div> </div><div>Please try 10.4.0.0/16</div><div> </div><div>Best regards.</div><div><br /></div><div><br /></div><div>İyi çalışmalar.</div><div>Samed YILDIRIM</div><div><br /></div><div><br /></div><div><br /></div><div>04.05.2017, 22:04, "Gone, Sajan" <sgone@lb.com>:</div><blockquote type="cite">
<div style="color:rgb(0,0,0);font-family:Calibri,sans-serif;">
<div><span style="font-size:16px;">Hi,</span></div>
<div><span style="font-size:16px;"><br />
</span></div>
<div><span style="font-size:16px;"><br />
</span></div>
<div><span style="font-size:16px;"> I am trying to allow application connections from all the hosts starting with IP addresses 10.4.***</span></div>
<div><span style="font-size:16px;"><br />
</span></div>
<div><span style="font-size:16px;">Is adding the following line on pg_hba.conf is appropriate to do so?</span></div>
<div><span style="font-size:16px;"><br />
</span></div>
<div>
<div><span style="font-size:16px;">host xuser xdatabase 10.4.*.*/32 password</span></div>
<div><span style="font-size:16px;"><br />
</span></div>
<div><span style="font-size:16px;">Are would I have to set the IP address in a different way?</span></div>
<div><span style="font-size:16px;"><br />
</span></div>
<div>
<div>
<div>
<div><span style="font-size:16px;">Thank You,</span></div>
<div><span style="font-size:16px;">Sajan Gone</span></div>
<div><span style="font-size:16px;">Database Administrator</span></div>
<div><span style="font-size:16px;">L Brands</span></div>
<div><span style="font-size:16px;">Mobile #: <span>517-990-5282</span></span></div>
</div>
<div><span style="font-size:16px;">Office #: <span>614-577-7622</span></span></div>
</div>
</div>
<en-clipboard></div>
<br />
<hr />
<font face="Arial" color="Gray" size="1"><br />
Notice: This communication may contain privileged and/or confidential information. If you are not the intended recipient, please notify the sender by email, and immediately delete the message and any attachments without copying or disclosing them. LB may, for
any reason, intercept, access, use, and disclose any information that is communicated by or through, or which is stored on, its networks, applications, services, and devices.<br />
</font>
</div>
</blockquote>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Setting wild card IP's on postgres
2017-05-04 19:02 Setting wild card IP's on postgres Gone, Sajan <SGone@lb.com>
2017-05-04 19:06 ` Re: Setting wild card IP's on postgres Samed YILDIRIM <samed@reddoc.net>
@ 2017-05-04 19:10 ` Gone, Sajan <SGone@lb.com>
2017-05-05 01:57 ` Re: Setting wild card IP's on postgres Stéphane KANSCHINE <stephane@hexack.fr>
0 siblings, 1 reply; 4+ messages in thread
From: Gone, Sajan @ 2017-05-04 19:10 UTC (permalink / raw)
To: Samed YILDIRIM <samed@reddoc.net>; pgsql-admin
Thanks Samed. That works perfectly.
Thanks,
Sajan Gone.
From: Samed YILDIRIM <samed@reddoc.net<mailto:samed@reddoc.net>>
Date: Thursday, May 4, 2017 at 3:06 PM
To: Sajan Gone <sgone@lb.com<mailto:sgone@lb.com>>, "pgsql-admin@postgresql.org<mailto:pgsql-admin@postgresql.org>" <pgsql-admin@postgresql.org<mailto:pgsql-admin@postgresql.org>>
Subject: Re: [ADMIN] Setting wild card IP's on postgres
Hi Sajan,
Please try 10.4.0.0/16
Best regards.
İyi çalışmalar.
Samed YILDIRIM
04.05.2017, 22:04, "Gone, Sajan" <sgone@lb.com<mailto:sgone@lb.com>>:
Hi,
I am trying to allow application connections from all the hosts starting with IP addresses 10.4.***
Is adding the following line on pg_hba.conf is appropriate to do so?
host xuser xdatabase 10.4.*.*/32 password
Are would I have to set the IP address in a different way?
Thank You,
Sajan Gone
Database Administrator
L Brands
Mobile #: 517-990-5282
Office #: 614-577-7622
<en-clipboard>
________________________________
Notice: This communication may contain privileged and/or confidential information. If you are not the intended recipient, please notify the sender by email, and immediately delete the message and any attachments without copying or disclosing them. LB may, for any reason, intercept, access, use, and disclose any information that is communicated by or through, or which is stored on, its networks, applications, services, and devices.
________________________________
Notice: This communication may contain privileged and/or confidential information. If you are not the intended recipient, please notify the sender by email, and immediately delete the message and any attachments without copying or disclosing them. LB may, for any reason, intercept, access, use, and disclose any information that is communicated by or through, or which is stored on, its networks, applications, services, and devices.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Setting wild card IP's on postgres
2017-05-04 19:02 Setting wild card IP's on postgres Gone, Sajan <SGone@lb.com>
2017-05-04 19:06 ` Re: Setting wild card IP's on postgres Samed YILDIRIM <samed@reddoc.net>
2017-05-04 19:10 ` Re: Setting wild card IP's on postgres Gone, Sajan <SGone@lb.com>
@ 2017-05-05 01:57 ` Stéphane KANSCHINE <stephane@hexack.fr>
0 siblings, 0 replies; 4+ messages in thread
From: Stéphane KANSCHINE @ 2017-05-05 01:57 UTC (permalink / raw)
To: Gone, Sajan <SGone@lb.com>; pgsql-admin
Le jeu. 4 mai, vers 19:10, Gone, Sajan exprimait :
> Thanks Samed. That works perfectly.
It work because it respects CIDR notation, as explained in the
documentation.
CIDR : https://en.wikipedia.org/wiki/Classless_Inter-Domain_Routing
Documentation : https://www.postgresql.org/docs/9.6/static/auth-pg-hba-conf.html
--
Stéphane KANSCHINE - http://www.hexack.fr./ - http://www.nuajik.com./
＠ stephane@hexack.fr
+33 6 64 31 72 52
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2017-05-05 01:57 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-05-04 19:02 Setting wild card IP's on postgres Gone, Sajan <SGone@lb.com>
2017-05-04 19:06 ` Samed YILDIRIM <samed@reddoc.net>
2017-05-04 19:10 ` Gone, Sajan <SGone@lb.com>
2017-05-05 01:57 ` Stéphane KANSCHINE <stephane@hexack.fr>
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