Trying to connect to remote postgres w/ dotConnect

Trying to connect to remote postgres w/ dotConnect

Postby 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 "", 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.
Posts: 1
Joined: Fri 01 Oct 2010 17:05

Postby 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 Copy that entry and replace with (the IP address of the machine you are connection from), restart the postgres service and you should be able to connect.
Posts: 14
Joined: Tue 15 Mar 2011 18:11

Postby Shalex » Mon 18 Jul 2011 07:03

ChrisMH, thank you for posting.

Datahook, have you resolved the problem?
Devart Team
Posts: 7654
Joined: Thu 14 Aug 2008 12:44

Return to dotConnect for PostgreSQL