Trying to connect to remote postgres w/ dotConnect

datahook · Post by **datahook** » Fri 15 Jul 2011 14:33

I get this error:

TITLE: SQL Server Import and Export Wizard

The operation could not be completed.

no pg_hba.conf entry for host "10.16.10.60", user "postgres", database "GX2", SSL off (Devart.Data.PostgreSql)

Property grid destination screen I filled out all params. The postgres database is on a different server than where I am running the SSMS from.

ChrisMH · Post by **ChrisMH** » Fri 15 Jul 2011 20:20

A default Postgres installation only allows connections from localhost. If you look at the server's pg_hba.conf file, you will see an entry for 127.0.0.1. Copy that entry and replace 127.0.0.1 with 10.16.10.60 (the IP address of the machine you are connection from), restart the postgres service and you should be able to connect.

Shalex · Post by **Shalex** » Mon 18 Jul 2011 07:03

ChrisMH, thank you for posting.

Datahook, have you resolved the problem?