Now, that we have our configuration complete, we can check to see if we can connect.

ĭescription = PostgreSQL connection to SallyDBĬonnSettings = Connect to PostgreSQL with ODBC isql Command This is a security feature that allows you to allow connections for only those users that merit it. If we configure the $HOME/.odbc.ini file, it will be configured for our specific user only. If you configure the /etc/odbc.ini file, it will work for all users on this machine. Next, we configure the connection information specfic to our PostgreSQL database. Configure Our ODBC Connections in /etc/odbc.ini The above example shows us that we have ODBC drivers installed on this machine for connecting to both MySQL and PostgreSQL. Now that your driver is installed, we can test that the driver is installed using this command: # odbcinst -q -d The following is the portion of my /etc/odbcinst.ini file. This tells unixODBC where it can find the files specific to connecting to PostgreSQL database servers. Our next task is to edit the /etc/odbcinst.ini file to configure the PostgreSQL driver. Postgresql93-odbc.x86_64 : PostgreSQL ODBC driverĬonfigure the PostgreSQL ODBC Driver in the Odbcinst.ini File Postgresql-odbc.x86_64 : PostgreSQL ODBC driver If your repository is for a slightly different version of PostgreSQL, then you can use yum search to find the exact rpm to install: # yum search postgre | grep odbc yum install postgresql93-odbc.x86_64 postgresql93-odbc-debuginfo.x86_64 unixODBC You should now be able to install your unixODBC rpm and PostgreSQL drivers with yum. That will install the PostgreSQL repository which will make it easier to install the ODBC drivers. Download the Postgres 9.3 repository and install it using rpm using the following steps: # wget The repository for postgresql makes installing their database much easier. Installing PostgreSQL isn’t required for installing the PostgreSQL ODBC drivers, but you will want to begin by installing the PostgreSQL repository. If you need instructions on installing PostgreSQL on a CentOS, Fedora, or Redhat server, you can find instructions in this earlier article: CentOS Install Postgres. The client was a CentOS 6 box, which already had PostgreSQL 9.3 installed on it.

One of our statisticians needed to be able to connect to his PostgreSQL database using ODBC. We had an interesting little project the other day.

Redhat install postgres