Postgresql — access from remote location / OBDC

Edit pg_hba.conf

add a line to allow a connection from your IP address:

host    all         all      md5

Edit postgresql.conf

Uncomment listen_addresses line and set to ‘*’

Download Postgresql ODBC driver

Set up ODBC connection

This is the confusing part. If you downloaded a 64 bit driver, you need to launch the ODBC panel that lives in C:/windows/sysWOW64/odbcad32.exe

It looks identical to the other admin panel, and connections will even succeed, but in my case Endicia would only be able to connect if the connection was set up through sysWOW64/

Details here:

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s