[postgis-users] Failing to connect to Postgis

[Milo van der Linden]

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>
mlinden at zeelandnet.nl <mailto:mlinden at zeelandnet.nl>
milovanderlinden at gmail.com <mailto:milovanderlinden at gmail.com>
milo at 3dsite.nl <mailto:milo at 3dsite.nl>
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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20071219/b1d158bd/attachment.html>