PostgreSQL help

[Pierre Sahores]

See inside your windows PostgreSQL directory where to find the  
Pg_hba.conf file and just add your navicat host IP as a trusted host.

<http://www.mapbender.org/Pg_hba.conf>
<http://developer.postgresql.org/pgdocs/postgres/auth-pg-hba-conf.html>

The Pg_hba.conf file is, by default, set to accept localhost  
connexions only.

Best,

Le 14 janv. 10 à 19:17, Alex Adams a écrit :

> Pierre,
>
> Unknown.  How do I do that?
>
> Thanks,
> -- 
> Alex Adams
>
> hawkVision — tools for solving Wicked Problems
>
> (a)2 Technology Partners, Inc.
> 831-726-8013
> alex at a2tecnology.com
> www.a2technology.com
> www.promisstudio.com
> universalconnector.wordpress.com
>
>
>> From: Pierre Sahores <psahores at free.fr>
>> Reply-To: How to use Revolution <use-revolution at lists.runrev.com>
>> Date: Thu, 14 Jan 2010 19:08:25 +0100
>> To: How to use Revolution <use-revolution at lists.runrev.com>
>> Subject: Re: PostgreSQL help
>>
>> Hi,
>>
>> Did you set-up your remote PostgreSQL to accept non-localhost
>> connexions too (hba.conf) ?
>>
>> Best,
>>
>>
>> Le 14 janv. 10 à 18:56, Alex Adams a écrit :
>>
>>> I have successfully setup a runRev application to work with
>>> PosgreSQL on
>>> localhost of the same machine that is running the runRev app (OS X).
>>>
>>> Now I am ready to connect to a fresh PostgreSQL install on a Vista
>>> machine
>>> on the LAN.  I am trying to use Navicat to move the database from  
>>> the
>>> localhost to the new server installation.  I can’t make the
>>> connection.  I
>>> can ping from one machine to the other, but I can’t get a response
>>> from
>>> Postgres.  The services are running.  Any ideas as to what might be
>>> wrong?
>>>
>>> I know that this is a very basic question with a lot of variables to
>>> the
>>> specific installations here, but I need to learn how to do this
>>> smoothly and
>>> easily.  I expect to host many, many of these Postgres database on
>>> hosted
>>> installations, perhaps virtual servers, on the net.
>>>
>>> Any guidance would be appreciated and any reference works for my
>>> education
>>> would be appreciated also.  I am an experienced database user.  I am
>>> familiar with MS SQL Server, Openbase, Frontbase, and SQLite.  This
>>> is my
>>> first time with Postgres.
>>>
>>> Thanks,
>>> -- 
>>> Alex Adams
>>>
>>> hawkVision — tools for solving Wicked Problems
>>>
>>> (a)2 Technology Partners, Inc.
>>> 831-726-8013
>>> alex at a2tecnology.com
>>> www.a2technology.com
>>> www.promisstudio.com
>>> universalconnector.wordpress.com
>>>
>>> _______________________________________________
>>> use-revolution mailing list
>>> use-revolution at lists.runrev.com
>>> Please visit this url to subscribe, unsubscribe and manage your
>>> subscription preferences:
>>> http://lists.runrev.com/mailman/listinfo/use-revolution
>>>
>>
>> --
>> Pierre Sahores
>> mobile : (33) 6 03 95 77 70
>>
>> www.woooooooords.com
>> www.sahores-conseil.com
>>
>>
>>
>>
>>
>>
>> _______________________________________________
>> use-revolution mailing list
>> use-revolution at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your  
>> subscription
>> preferences:
>> http://lists.runrev.com/mailman/listinfo/use-revolution
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your  
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>

--
Pierre Sahores
mobile : (33) 6 03 95 77 70

www.woooooooords.com
www.sahores-conseil.com