<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
That is not correct, I never have to restart postGres when I put
changes in my pg_hba.conf.<br>
<br>
Here is a sample of my pg_hba.conf<br>
<br>
don't forget to use /32 at the end of the ip-address.<br>
<br>
<br>
Hope this snippet is of some help!<br>
<br>
# TYPE DATABASE USER CIDR-ADDRESS METHOD<br>
host all all 127.0.0.1/32 md5<br>
#(Allow everybody from the local machine to access the database)<br>
<br>
host thisone all 87.211.41.xxx/32 md5<br>
#(Allow everybody from 87.211.41.xxx to access the thisone database)<br>
<br>
host thistwo postgres 87.211.41.xxx/32 md5<br>
#(Allow user postgres to access database thistwo from 87.211.41.xxx)<br>
<br>
host thistwo marco 82.176.191.xxx/32 md5<br>
#(Allow user marco to access database thistwo from 82.176.191.xxx)<br>
<br>
<br>
Mark Cave-Ayland schreef:
<blockquote cite="mid:1198092384.5695.0.camel@mca-desktop" type="cite">
<pre wrap="">On Wed, 2007-12-19 at 15:15 +0100, Steven De Vriendt wrote:
</pre>
<blockquote type="cite">
<pre wrap="">thanks Guido, now I want to allow connection from all to this ip
192.168.102.100 How do I configure this in pg_hba ?
For now I have
host all all md5
but that doesn't seem to work... Can you help me out ?
thx
Steven
</pre>
</blockquote>
<pre wrap=""><!---->
Hi Steven,
Don't forget you need to restart PostgreSQL for the pg_hba.conf changes
to take effect.
Kind regards,
Mark.
</pre>
</blockquote>
<br>
<br>
<div class="moz-signature">-- <br>
<title>3DSite</title>
<meta http-equiv="Content-Type" content="text/html; ">
<style type="text/css">
<!--
body {
background-color: #FFFFFF;
margin-left: 5px;
margin-top: 5px;
margin-right: 5px;
margin-bottom: 5px;
}
body,td,th {
font-family: Arial, Helvetica, sans-serif;
font-size: 12px;
color: #333333;
}
.style4 {font-size: 9px; }
.style5 {font-size: 9px; color: #CCCCCC; }
-->
</style>
<meta content="MSHTML 6.00.2900.2912" name="GENERATOR">
<br>
<table border="0" cellpadding="0" cellspacing="0" width="400">
<tbody>
<tr>
<td rowspan="3" align="left" height="0" valign="bottom" width="15"><br>
</td>
<td colspan="2" align="left" height="78" valign="top" width="0">
<p class="style4">Milo van der Linden
<br>
<a href="skype:milovanderlinden?add">skype: milovanderlinden</a><br>
<a href="mailto:mlinden@zeelandnet.nl">mlinden@zeelandnet.nl</a><br>
<a href="mailto:milovanderlinden@gmail.com">milovanderlinden@gmail.com</a><br>
<a href="mailto:milo@3dsite.nl">milo@3dsite.nl</a><br>
<a href="http://www.3dsite.nl">http://www.3dsite.nl</a><br>
</p>
</td>
<td rowspan="3" align="left" height="0" valign="top" width="15"> </td>
<td valign="top" width="300">
<p class="style5"><span lang="NL">De informatie in dit bericht
reflecteert mijn persoonlijke mening en niet die van een bedrijf of
instantie. Aan de informatie kunnen geen rechten worden ontleend.
Indien dit bericht onderdeel is van een forum, mailing-list of
community dan gelden automatisch de bij het betreffende medium
behorende voorwaarden.</span>
<span lang="EN">The information in this message reflects my
personal opinion and not that of a company or public body. All rights
reserved.If this message is contained in a mailing-list or community,
the rights on the medium are automatically adapted.</span></p>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>