Trying to connect to remote postgres w/ dotConnect

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
datahook
Posts: 1
Joined: Fri 01 Oct 2010 17:05

Trying to connect to remote postgres w/ dotConnect

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
Posts: 14
Joined: Tue 15 Mar 2011 18:11

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
Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Mon 18 Jul 2011 07:03

ChrisMH, thank you for posting.

Datahook, have you resolved the problem?

Post Reply