Postgresql — access from remote location / OBDC

Edit pg_hba.conf

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

host    all         all          71.56.137.10/24      md5

Edit postgresql.conf

Uncomment listen_addresses line and set to ‘*’

Download Postgresql ODBC driver

http://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&ved=0CHEQFjAA&url=http%3A%2F%2Fwww.postgresql.org%2Fftp%2Fodbc%2Fversions%2F&ei=7x3ZT8eVB6qm6gGm19WGAw&usg=AFQjCNFnVfQTQ1A6VfcYuSkBfQ14cdCKyw

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:
http://stackoverflow.com/questions/1954128/how-do-i-connect-to-my-64-bit-sql-server-with-odbc