Tuesday 7 October 2008

PostgreSQL ODBC installation

ODBC installation on CentOS for PostgreSQL DB

[root@localhost ~]# yum -y install unixODBC.i386 unixODBC-devel.i386

[root@localhost ~]# wget http://yum.pgsqlrpms.org/8.3/redhat/rhel-5-i386/postgresql-odbc-08.03.0100-1PGDG.rhel5.i686.rpm
[root@localhost ~]# rpm -i postgresql-odbc-08.03.0100-1PGDG.rhel5.i686.rpm
[root@localhost ~]# vi /etc/odbc.ini
...
[PSQL]
Description = My Database
Driver = PostgreSQL
Trace = No
TraceFil = /tmp/odbc.log
Database = postgres
Servername = postgresql-server
Username = postgres
Password = tunafish
Port = 5432
ReadOnly = No
...

[root@localhost ~]# vi /etc/odbcinst.ini
...
[PostgreSQL]
Description = ODBC for PostgreSQL
Driver = /usr/lib/libodbcpsql.so
Setup = /usr/lib/libodbcpsqlS.so
FileUsage = 1
...

[root@localhost ~]# isql PSQL
+---------------------------------------+
| Connected! |
+---------------------------------------+
SQL>
...

[root@localhost ~]#

1 comment:

sanjay parmar said...

there are some proplems
when i use command::::::::::
rpm -ivh postgresql-8.3.8-1PGDG.rhel5.i386.rpm


Error is :----
warning: postgresql-8.3.8-1PGDG.rhel5.i386.rpm: Header V3 DSA signature: NOKEY, key ID e8e345b8
error: Failed dependencies:
postgresql-libs = 8.3.8-1PGDG.rhel5 is needed by postgresql-8.3.8-1PGDG.rhel5.i386