That is not correct, I never have to restart postGres when I put changes
in my pg_hba.conf.
Here is a sample of my pg_hba.conf
don't forget to use /32 at the end of the ip-address.
Hope this snippet is of some help!
# TYPE DATABASE USER CIDR-ADDRESS METHOD
host all all 127.0.0.1/32 md5
#(Allow everybody from the local machine to access the database)
host thisone all 87.211.41.xxx/32 md5
#(Allow everybody from 87.211.41.xxx to access the thisone database)
host thistwo postgres 87.211.41.xxx/32 md5
#(Allow user postgres to access database thistwo from 87.211.41.xxx)
host thistwo marco 82.176.191.xxx/32 md5
#(Allow user marco to access database thistwo from 82.176.191.xxx)
Mark Cave-Ayland schreef:
On Wed, 2007-12-19 at 15:15 +0100, Steven De Vriendt wrote:
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
Hi Steven,
Don't forget you need to restart PostgreSQL for the pg_hba.conf changes
to take effect.
Kind regards,
Mark.
--
Milo van der Linden
skype: milovanderlinden <skype:milovanderlinden?add>
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
http://www.3dsite.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. 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.
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
