Re: PostgreSQL drivers

Hi,

I want to access Data located in HAWQ into SAS using PostgreSQL driver.

If I want to try using the PostgreSQL driver to get to HAWQ using SAS/ACCESS Interface to ODBC I need 2 things.

1.  A driver manager

2.  A PostgreSQL driver

I found the url to download the drivers but am not sure whether these drivers support for my current environment.

Right now am using SAS 9.2 on Unix(Solaris 5.10) Sparc,please let me know whether it supports or not.

If it supports can you tell whether it comes with both the driver manager and PostgreSQL drivers and also Which download I need to go is it binary or source code from the below link provided.

 

http://www.postgresql.org/ftp/odbc/versions/

When am clicking on Source-->v9.4.1

below are the drivers am getting to download, but not sure which once to select

Files
postgresql-9.4.1.tar.bz2 Feb. 2, 2015, 8:53 p.m. 16.7 MB
postgresql-9.4.1.tar.bz2.md5 Feb. 2, 2015, 8:53 p.m. 59 bytes
postgresql-9.4.1.tar.bz2.sha256 Feb. 2, 2015, 8:53 p.m. 91 bytes
postgresql-9.4.1.tar.gz Feb. 2, 2015, 8:53 p.m. 21.9 MB
postgresql-9.4.1.tar.gz.md5 Feb. 2, 2015, 8:53 p.m. 58 bytes
postgresql-9.4.1.tar.gz.sha256 Feb. 2, 2015, 8:53 p.m. 90 bytes

When am clicking on Binary-->Solaris-->File browser-->v9.4.1-->Solaris-->solaris10-->sparc

below are the files am getting to download, but not sure which once to select

Files
README Feb. 4, 2015, 10:12 p.m. 1.5 KB
postgresql-9.4.1-S10.sparc-32.tar.bz2 Feb. 4, 2015, 10:12 p.m. 11.5 MB
postgresql-9.4.1-S10.sparc-32.tar.bz2.md5 Feb. 4, 2015, 10:12 p.m. 77 bytes
postgresql-9.4.1-S10.sparc-64.tar.bz2 Feb. 4, 2015, 10:12 p.m. 12.0 MB
postgresql-9.4.1-S10.sparc-64.tar.bz2.md5 Feb. 4, 2015, 10:12 p.m. 77 bytes

 
Please help me with the exact drivers and necessary steps to download and install drivers in my environment.

I would really appreciate if you can please guide me with the steps.

 

Thanks a lot in Advance

Kiran 

-