PostgreSQL drivers
Kiran Kumar <[email protected]> Mon, 30 Mar 2015 19:57:47 -0400
| Newsgroups | gmane.comp.db.postgresql.interfaces |
|---|---|
| Message-ID | <CAC2xtS8B+8-j581gFORc_dSBD_aJVNgnaArhRP24qakUrG2GUg@mail.gmail.com> |
--047d7ba97e4eebdebf05128a40ae Content-Type: text/plain; charset=ISO-8859-1 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 - --047d7ba97e4eebdebf05128a40ae Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable <div><span style=3D"BACKGROUND-COLOR:rgb(255,255,255)"><font color=3D"#4581= 8e" size=3D"4" face=3D"times new roman, serif">Hi,</font></span></div> <div><span style=3D"BACKGROUND-COLOR:rgb(255,255,255)"><font color=3D"#4581= 8e" size=3D"4" face=3D"times new roman, serif">I want to access Data locate= d in HAWQ into SAS using PostgreSQL driver.</font></span></div> <div><span style=3D"BACKGROUND-COLOR:rgb(255,255,255)"><font color=3D"#4581= 8e" size=3D"4" face=3D"times new roman, serif">If I want to try using the P= ostgreSQL driver to get to HAWQ using SAS/ACCESS Interface to ODBC I need 2= things.</font></span></div> <div><span style=3D"BACKGROUND-COLOR:rgb(255,255,255)"><font color=3D"#4581= 8e" size=3D"4" face=3D"times new roman, serif">1.=A0 A driver manager</font= ></span></div> <div><span style=3D"BACKGROUND-COLOR:rgb(255,255,255)"><font color=3D"#4581= 8e" size=3D"4" face=3D"times new roman, serif">2.=A0 A PostgreSQL driver</f= ont></span></div><span style=3D"BACKGROUND-COLOR:rgb(255,255,255)"><font co= lor=3D"#45818e" size=3D"4" face=3D"times new roman, serif"> <div><br>I found the url to download the drivers but am not sure whether th= ese drivers support for my current environment.</div> <div>Right now am using SAS 9.2 on Unix(Solaris 5.10) Sparc,please let me k= now whether it supports or not.</div> <div>If it supports can you tell whether it comes with both the driver mana= ger and PostgreSQL drivers and also Which download I need to go is it binar= y or source code from the below link provided.</div> <div>=A0</div> <div><a href=3D"http://www.postgresql.org/ftp/odbc/versions/">http://www.po= stgresql.org/ftp/odbc/versions/</a></div> <div><br>When am clicking on Source-->v9.4.1</div> <div>below are the drivers am getting to download, but not sure which once = to select</div> <div><br>Files<br>postgresql-9.4.1.tar.bz2 Feb. 2, 2015, 8:53 p.m. 16.7 MB = <br>postgresql-9.4.1.tar.bz2.md5 Feb. 2, 2015, 8:53 p.m. 59 bytes <br>postg= resql-9.4.1.tar.bz2.sha256 Feb. 2, 2015, 8:53 p.m. 91 bytes <br>postgresql-= 9.4.1.tar.gz Feb. 2, 2015, 8:53 p.m. 21.9 MB <br>postgresql-9.4.1.tar.gz.md= 5 Feb. 2, 2015, 8:53 p.m. 58 bytes <br>postgresql-9.4.1.tar.gz.sha256 Feb. = 2, 2015, 8:53 p.m. 90 bytes </div> <div><br>When am clicking on Binary-->Solaris-->File browser-->v9.= 4.1-->Solaris-->solaris10-->sparc</div> <div>below are the files am getting to download, but not sure which once to= select</div> <div>Files<br>README Feb. 4, 2015, 10:12 p.m. 1.5 KB <br>postgresql-9.4.1-S= 10.sparc-32.tar.bz2 Feb. 4, 2015, 10:12 p.m. 11.5 MB <br>postgresql-9.4.1-S= 10.sparc-32.tar.bz2.md5 Feb. 4, 2015, 10:12 p.m. 77 bytes <br>postgresql-9.= 4.1-S10.sparc-64.tar.bz2 Feb. 4, 2015, 10:12 p.m. 12.0 MB <br>postgresql-9.= 4.1-S10.sparc-64.tar.bz2.md5 Feb. 4, 2015, 10:12 p.m. 77 bytes </div> <div>=A0<br>Please help me with the exact drivers and necessary steps to do= wnload and install drivers in my environment.</div> <div>I would really appreciate if you can please guide me with the steps.</= div> <div>=A0</div> <div>Thanks a lot in Advance</div> <div>Kiran=A0</div></font></span><br> <div> <div class=3D"gmail_signature"> <div dir=3D"ltr"> <div dir=3D"ltr"><font color=3D"#45818e"><br></font> <div style=3D"FONT-SIZE:10px" dir=3D"ltr"><font color=3D"#45818e">-</font><= br></div></div></div></div></div> --047d7ba97e4eebdebf05128a40ae--