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 "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.
datahook
 
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 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.
ChrisMH
 
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?
Shalex
Devart Team
 
Posts: 7774
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for PostgreSQL