Devart Forums

Posted: **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.

Posted: **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.

Posted: **Mon 18 Jul 2011 07:03**

ChrisMH, thank you for posting.

Datahook, have you resolved the problem?

Devart Forums

Trying to connect to remote postgres w/ dotConnect

Trying to connect to remote postgres w/ dotConnect