How To Install and Configure the Lite Edition ODBC Drivers for PostgreSQL (Linux)

This guide is currently Unavailable

This HTML5 document contains 199 embedded RDF statements represented using HTML+Microdata notation.

The embedded RDF content will be recognized by any processor of HTML5 Microdata.

Namespace Prefixes

Prefix	IRI
n22	http://data.openlinksw.com/oplweb/uda/howto/GenericLinuxLitePostgreSQLDataSourceNameConfigurationGuideStep2#
n42	http://data.openlinksw.com/oplweb/uda/howto/GenericLinuxLiteODBCDriverInstallerInstallationGuideStep1#
n13	http://data.openlinksw.com/oplweb/uda/howto/GenericLinuxLitePostgreSQLPre-installationGuideStep3#
oplsoft	http://www.openlinksw.com/ontology/software#
n14	http://data.openlinksw.com/oplweb/uda/howto/GenericLinuxLitePostgreSQLPre-installationGuideStep6#
n21	http://data.openlinksw.com/oplweb/uda/howto/GenericLinuxLitePostgreSQLPre-installationGuideStep9#
n43	http://data.openlinksw.com/oplweb/uda/howto/GenericLinuxLiteODBCDriverInstallerInstallationGuideStep6#
n37	http://data.openlinksw.com/oplweb/product/odbc-postgresql-st#
schema	http://schema.org/
n41	http://wikis.openlinksw.com/UdaWikiWeb/
n44	http://data.openlinksw.com/oplweb/uda/howto/GenericLinuxLiteODBCDriverInstallerInstallationGuideStep5#
n2	http://data.openlinksw.com/oplweb/uda/howto/GenericLinuxLiteODBCDriverInstallerInstallationGuideStep10#
n33	http://data.openlinksw.com/oplweb/uda/howto/GenericLinuxLitePostgreSQLDataSourceNameConfigurationGuideStep7#
n46	http://data.openlinksw.com/oplweb/
n12	http://data.openlinksw.com/oplweb/uda/howto/GenericLinuxLitePostgreSQLPre-installationGuideStep1#
n16	http://data.openlinksw.com/oplweb/uda/howto/GenericLinuxLitePostgreSQLPre-installationGuideStep4#
rdf	http://www.w3.org/1999/02/22-rdf-syntax-ns#
n26	http://data.openlinksw.com/oplweb/uda/howto/GenericLinuxLitePostgreSQLDataSourceNameConfigurationGuideStep3#
n15	http://data.openlinksw.com/oplweb/uda/howto/GenericLinuxLitePostgreSQLPre-installationGuideStep7#
n34	http://www.openlinksw.com/
n39	http://data.openlinksw.com/oplweb/opsys_family/
xsdh	http://www.w3.org/2001/XMLSchema#
n8	http://data.openlinksw.com/oplweb/uda/howto/GenericLinuxLiteODBCDriverInstallerInstallationGuideStep9#
n19	http://data.openlinksw.com/oplweb/uda/howto/GenericLinuxLitePostgreSQLPre-installationGuideStep10#
n32	http://data.openlinksw.com/oplweb/uda/howto/GenericLinuxLiteODBCDriverInstallerInstallationGuide#
n11	http://data.openlinksw.com/oplweb/uda/howto/GenericLinuxLitePostgreSQLPre-installationGuideStep2#
n18	http://data.openlinksw.com/oplweb/uda/howto/GenericLinuxLitePostgreSQLPre-installationGuideStep5#
n9	http://data.openlinksw.com/oplweb/uda/howto/GenericLinuxLitePostgreSQLDataSourceNameConfigurationGuide#
n29	http://data.openlinksw.com/oplweb/uda/howto/GenericLinuxLitePostgreSQLDataSourceNameConfigurationGuideStep8#
n31	http://data.openlinksw.com/oplweb/uda/howto/GenericLinuxLiteODBCDriverInstallerInstallationGuideStep4#
n28	http://data.openlinksw.com/oplweb/uda/howto/GenericLinuxLitePostgreSQLDataSourceNameConfigurationGuideStep4#
n23	http://data.openlinksw.com/oplweb/uda/howto/GenericLinuxLiteODBCDriverInstallerInstallationGuideStep3#
n35	http://data.openlinksw.com/oplweb/uda/howto/GenericLinuxLitePostgreSQLDataSourceNameConfigurationGuideStep5#
n40	http://uda.openlinksw.com/
n45	https://uda.openlinksw.com/odbc/driver/PostgreSQL/
n30	http://data.openlinksw.com/oplweb/uda/howto/GenericLinuxLitePostgreSQLDataSourceNameConfigurationGuideStep1#
n17	http://data.openlinksw.com/oplweb/uda/howto/GenericLinuxLiteODBCDriverInstallerInstallationGuideStep8#
n6	https://www.openlinksw.com/about/id/entity/urn/howto:
n4	https://uda.openlinksw.com/howto/lite/odbc/postgresql/linux/
n20	http://data.openlinksw.com/oplweb/uda/howto/GenericLinuxLitePostgreSQLPre-installationGuideStep8#
n27	http://data.openlinksw.com/oplweb/uda/howto/GenericLinuxLiteODBCDriverInstallerInstallationGuideStep7#
n7	http://data.openlinksw.com/oplweb/uda/howto/GenericLinuxLitePostgreSQLDataSourceNameConfigurationGuideStep9#
wdrs	http://www.w3.org/2007/05/powder-s#
n24	http://data.openlinksw.com/oplweb/uda/howto/GenericLinuxLitePostgreSQLDataSourceNameConfigurationGuideStep10#
n36	http://data.openlinksw.com/oplweb/uda/howto/GenericLinuxLitePostgreSQLDataSourceNameConfigurationGuideStep6#
n10	http://data.openlinksw.com/oplweb/uda/howto/GenericLinuxLitePostgreSQLPre-installationGuide#
n25	http://data.openlinksw.com/oplweb/uda/howto/GenericLinuxLiteODBCDriverInstallerInstallationGuideStep2#

Statements

Subject Item: n44:this
wdrs:describedby: n6:island
schema:name: Step 5
rdf:type: schema:HowToStep
schema:position: 5

Subject Item: n43:this
wdrs:describedby: n6:island
schema:name: Step 6
rdf:type: schema:HowToStep
schema:position: 6

Subject Item: n27:this
wdrs:describedby: n6:island
schema:name: Step 7
rdf:type: schema:HowToStep
schema:position: 7

Subject Item: n42:this
schema:description: The installation files ship as an installation shell script, a driver and admin .taz file, and a license .lic file. The installation shell script should be ftp'd in ascii. The rest of the files should be ftp'd in binary, where applicable. Downloads these documents, and place them in your desired installation folder.
wdrs:describedby: n6:island
schema:name: Step 1
rdf:type: schema:HowToStep
schema:position: 1

Subject Item: n25:this
schema:description: Start the installation process by opening the installation directory using cd, and running sh install.sh
wdrs:describedby: n6:island
schema:name: Step 2
rdf:type: schema:HowToStep
schema:position: 2

Subject Item: n23:this
schema:description: You must choose a TCP port on which to run your HTTP-based iODBC Data Sources Administrator. The default is 8000. You will need to know this port number and your local machine's IP address or hostname to access your Admistrator in a Web browser. This is how you call it: http://machine:portnumber Log File? enables you to rename and relocate your Administrative Assistant's log file. It is best to go with the default. You can choose to log all requests. This is not diagnostic-level odbc tracing or connection logging. The default is no. You can change the iODBC Data Source Administrator's default username from "admin." This is the name that you will need to login to OpenLink's HTTP-based iODBC Data Sources Administrator. You can change the iODBC Data Source Administrator's default password from "admin."
wdrs:describedby: n6:island
schema:name: Step 3
rdf:type: schema:HowToStep
schema:position: 3

Subject Item: n31:this
schema:description: The installation is complete.
wdrs:describedby: n6:island
schema:name: Step 4
rdf:type: schema:HowToStep
schema:position: 4

Subject Item: n17:this
wdrs:describedby: n6:island
schema:name: Step 8
rdf:type: schema:HowToStep
schema:position: 8

Subject Item: n8:this
wdrs:describedby: n6:island
schema:name: Step 9
rdf:type: schema:HowToStep
schema:position: 9

Subject Item: n2:this
wdrs:describedby: n6:island
schema:name: Step 10
rdf:type: schema:HowToStep
schema:position: 10

Subject Item: n10:this
schema:description: Pre-Installation Requirements for the Single-Tier (Lite Edition) ODBC Driver for PostgreSQL, Linux or Unix-like OS
wdrs:describedby: n6:island
schema:name: Pre-Installation Requirements for the Single-Tier (Lite Edition) ODBC Driver for PostgreSQL, Linux or Unix-like OS
oplsoft:hasDatabaseFamily: n46:PostgreSQL
oplsoft:hasOperatingSystemFamily: n39:GenericLinux
schema:category: Pre-installation Guide
schema:relatedLink: n32:this n41:PreinstallPostgreSQLLiteUnix
schema:text: <ol> <li>You need to know a variety of information pertaining to your PostgreSQL Server: <ul> <li>PostgreSQL TCP port: Specify the TCP port number used for communication with the PostgreSQL database.</li> <li>Hostname or IP address of the PostgreSQL database server: Provide the hostname or IP address of the server where your PostgreSQL database is located.</li> </ul> </li> </ol>
rdf:type: schema:HowTo
schema:step: n11:this n13:this n12:this n14:this n15:this n16:this n18:this n19:this n20:this n21:this

Subject Item: n9:this
schema:description: OpenLink ODBC Driver for PostgreSQL (Lite Edition) Configuration
wdrs:describedby: n6:island
schema:name: OpenLink ODBC Driver for PostgreSQL (Lite Edition) Configuration
oplsoft:hasDatabaseFamily: n46:PostgreSQL
oplsoft:hasOperatingSystemFamily: n39:GenericLinux
schema:category: Data Source Name Configuration Guide
schema:relatedLink: n41:InstallPostgreSQLLiteUnix
schema:text: <ol> <li> Prerequisites: <ul> <li>You MUST be proficient in using a Unix shell.</li> <li>You MUST be proficient in using a Unix editor such as vi.</li> <li>You MUST be in possession of relevant database connectivity details such as Database name, Username, password, etc.</li> </ul> </li> <li> Open the file <code><OPENLINK_INSTALL>/bin/odbc.ini</code> with a suitable text editor such as vi. </li> <li> Locate and edit the sample OpenLink PostgreSQL ODBC data source (DSN) created during the installation process and edit as follows: <pre> [postgres] Driver = <OPENLINK_INSTALL>/lib/pgr7_mt_lt.so ServerType = PostgreSQL Options = -H postgres.hostname Database = database Username = postgres Password = FetchBufferSize = 99 ReadOnly = no DeferLongFetch = no JetFix = no Description = Sample PostgreSQL Lite Connection </pre> </li> <li> To test your data source, use the <code>iodbctest</code> tool which is packaged with the HTTP-based OpenLink ODBC Administrator as follows: <pre> # cd <OPENLINK_INSTALL> # . ./openLink.sh # iodbctest postgres </pre> <blockquote> iODBC Demonstration program This program shows an interactive SQL processor Driver Manager: 03.52.0507.0105 Driver: 06.02.1217 OpenLink Generic ODBC Driver (pgr7_mt_lt.so) SQL> </blockquote> </li> <li> You should now be able to issue SQL statements directly against the target database. </li> </ol> Additional Notes: The bitness of the ODBC Driver for PostgreSQL is determined by the bitness of your ODBC client application. That is, if your ODBC client application is 32-bit then the Generic ODBC Driver component MUST also be 32-bit.
rdf:type: schema:HowTo
schema:step: n7:this n24:this n26:this n28:this n30:this n22:this n33:this n29:this n35:this n36:this

Subject Item: n12:this
schema:description: You need to know a variety of information pertaining to your PostgreSQL Server: PostgreSQL TCP port Hostname or IP address of the PostgreSQL database server
wdrs:describedby: n6:island
schema:name: Step 1
rdf:type: schema:HowToStep
schema:position: 1

Subject Item: n11:this
wdrs:describedby: n6:island
schema:name: Step 2
rdf:type: schema:HowToStep
schema:position: 2

Subject Item: n13:this
wdrs:describedby: n6:island
schema:name: Step 3
rdf:type: schema:HowToStep
schema:position: 3

Subject Item: n16:this
wdrs:describedby: n6:island
schema:name: Step 4
rdf:type: schema:HowToStep
schema:position: 4

Subject Item: n18:this
wdrs:describedby: n6:island
schema:name: Step 5
rdf:type: schema:HowToStep
schema:position: 5

Subject Item: n14:this
wdrs:describedby: n6:island
schema:name: Step 6
rdf:type: schema:HowToStep
schema:position: 6

Subject Item: n15:this
wdrs:describedby: n6:island
schema:name: Step 7
rdf:type: schema:HowToStep
schema:position: 7

Subject Item: n20:this
wdrs:describedby: n6:island
schema:name: Step 8
rdf:type: schema:HowToStep
schema:position: 8

Subject Item: n21:this
wdrs:describedby: n6:island
schema:name: Step 9
rdf:type: schema:HowToStep
schema:position: 9

Subject Item: n19:this
wdrs:describedby: n6:island
schema:name: Step 10
rdf:type: schema:HowToStep
schema:position: 10

Subject Item: n30:this
schema:description: Prerequisites: You MUST be proficient in using a Unix shell. You MUST be proficient in using a Unix editor such as vi You MUST be in possession of relevant database connectivity details such as Database name, Username, password, etc.
wdrs:describedby: n6:island
schema:name: Step 1
rdf:type: schema:HowToStep
schema:position: 1

Subject Item: n22:this
schema:description: Open the file <OPENLINK_INSTALL>/bin/odbc.ini with a suitable text editor such as vi. Locate and edit the sample OpenLink PostgreSQL ODBC data source (DSN) created during the installation process and edit as follows-- [postgres] Driver = <OPENLINK_INSTALL>/lib/pgr7_mt_lt.so ServerType = PostgreSQL Options = -H postgres.hostname Database = database Username = postgres Password = FetchBufferSize = 99 ReadOnly = no DeferLongFetch = no JetFix = no Description = Sample PostgreSQL Lite Connection
wdrs:describedby: n6:island
schema:name: Step 2
rdf:type: schema:HowToStep
schema:position: 2

Subject Item: n26:this
schema:description: To test your data source, use the iodbctest tool which is packaged with the HTTP-based OpenLink ODBC Administrator as follows -- #cd <OPENLINK_INSTALL> #. ./openLink.sh # iodbctest postgres iODBC Demonstration program This program shows an interactive SQL processor Driver Manager: 03.52.0507.0105 Driver: 06.02.1217 OpenLink Generic ODBC Driver (pgr7_mt_lt.so) SQL> You should now be able to issue SQL statements directly against the target database.
wdrs:describedby: n6:island
schema:name: Step 3
rdf:type: schema:HowToStep
schema:position: 3

Subject Item: n28:this
schema:description: Aditional Notes: The bitness of the ODBC Driver for PostgreSQL is determined by the bitness of your ODBC client application. That is, if your ODBC client application is 32-bit then the Generic ODBC Driver component MUST also be 32-bit.
wdrs:describedby: n6:island
schema:name: Step 4
rdf:type: schema:HowToStep
schema:position: 4

Subject Item: n35:this
wdrs:describedby: n6:island
schema:name: Step 5
rdf:type: schema:HowToStep
schema:position: 5

Subject Item: n36:this
wdrs:describedby: n6:island
schema:name: Step 6
rdf:type: schema:HowToStep
schema:position: 6

Subject Item: n33:this
wdrs:describedby: n6:island
schema:name: Step 7
rdf:type: schema:HowToStep
schema:position: 7

Subject Item: n29:this
wdrs:describedby: n6:island
schema:name: Step 8
rdf:type: schema:HowToStep
schema:position: 8

Subject Item: n7:this
wdrs:describedby: n6:island
schema:name: Step 9
rdf:type: schema:HowToStep
schema:position: 9

Subject Item: n24:this
wdrs:describedby: n6:island
schema:name: Step 10
rdf:type: schema:HowToStep
schema:position: 10

Subject Item: n32:this
schema:description: OpenLink ODBC Driver Installation for Linux
wdrs:describedby: n6:island
schema:name: OpenLink ODBC Driver Installation for Linux
oplsoft:hasOperatingSystemFamily: n39:GenericLinux
schema:category: Installation Guide
schema:relatedLink: n41:InstallOracle89LiteUnix
schema:text: <ol> <li> The installation files ship as an installation shell script, a driver and admin <code>.taz</code> file, and a license <code>.lic</code> file. The installation shell script should be ftp'd in ascii. The rest of the files should be ftp'd in binary, where applicable. </li> <li> Downloads these documents, and place them in your desired installation folder. </li> <li> Start the installation process by opening the installation directory using <code>cd</code>, and running <code>sh install.sh</code>. </li> <li> You must choose a TCP port on which to run your HTTP-based iODBC Data Sources Administrator. The default is 8000. You will need to know this port number and your local machine's IP address or hostname to access your Admistrator in a Web browser. This is how you call it: <code>http://machine:portnumber</code> </li> <li> Log File? enables you to rename and relocate your Administrative Assistant's log file. It is best to go with the default. </li> <li> You can choose to log all requests. This is not diagnostic-level odbc tracing or connection logging. The default is no. </li> <li> You can change the iODBC Data Source Administrator's default username from "<code>admin</code>." This is the name that you will need to login to OpenLink's HTTP-based iODBC Data Sources Administrator. </li> <li> You can change the iODBC Data Source Administrator's default password from "<code>admin</code>." </li> <li> The installation is complete. </li> </ol>
rdf:type: schema:HowTo
schema:step: n8:this n2:this n31:this n17:this n25:this n23:this n27:this n42:this n44:this n43:this

Subject Item: n4:
schema:description: A guide for installing the Lite Edition ODBC Driver for PostgreSQL data sources, on Linux.
wdrs:describedby: n6:island
schema:name: OpenLink Software Ã¢ÂÂ How to Install and Configure the Lite Edition ODBC Driver for PostgreSQL, on Linux
schema:relatedLink: n45:
schema:isPartOf: n34: n40:
schema:about: n37: n32:this n9:this n10:this
schema:dateModified: 2023-10-18T11:16:00
rdf:type: schema:CreativeWork schema:WebPage