tag:blogger.com,1999:blog-25918198540273454642011-07-07T23:00:31.111-07:00duduhttp://www.blogger.com/profile/07640220666785289980noreply@blogger.comBlogger41100tag:blogger.com,1999:blog-2591819854027345464.post-49680134445083796942009-01-27T06:29:00.000-08:002009-01-27T06:30:53.552-08:00DB2 ODBC installation can be found here: <a href="http://db2-sql.blogspot.com">DB DB2 ODBC</a><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/2591819854027345464-4968013444508379694?l=postgre-sql.blogspot.com' alt='' /></div>duduhttp://www.blogger.com/profile/07640220666785289980noreply@blogger.com0tag:blogger.com,1999:blog-2591819854027345464.post-49417946622472754672008-10-07T06:49:00.000-07:002008-10-07T06:52:40.534-07:00<span style="font-weight: bold;">Installation of ODBC drivers</span><br /><br />[root@localhost ~]# wget http://downloads.sourceforge.net/iodbc/libiodbc-3.52.6-1.i386.rpm<br />[root@localhost ~]# wget http://downloads.sourceforge.net/iodbc/libiodbc-devel-3.52.6-1.i386.rpm<br />[root@localhost ~]# rpm -i libiodbc-3.52.6-1.i386.rpm<br />[root@localhost ~]# rpm -i libiodbc-devel-3.52.6-1.i386.rpm<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/2591819854027345464-4941794662247275467?l=postgre-sql.blogspot.com' alt='' /></div>duduhttp://www.blogger.com/profile/07640220666785289980noreply@blogger.com0tag:blogger.com,1999:blog-2591819854027345464.post-78193171308173737012008-10-07T01:01:00.000-07:002008-10-07T01:03:27.859-07:00<span style="font-weight: bold;">ODBC installation on CentOS for PostgreSQL DB</span><br /><br />[root@localhost ~]# yum -y install unixODBC.i386 unixODBC-devel.i386<br /><br />[root@localhost ~]# wget http://yum.pgsqlrpms.org/8.3/redhat/rhel-5-i386/postgresql-odbc-08.03.0100-1PGDG.rhel5.i686.rpm<br />[root@localhost ~]# rpm -i postgresql-odbc-08.03.0100-1PGDG.rhel5.i686.rpm<br />[root@localhost ~]# vi /etc/odbc.ini<br />...<br />[PSQL]<br />Description = My Database<br />Driver = PostgreSQL<br />Trace = No<br />TraceFil = /tmp/odbc.log<br />Database = postgres<br />Servername = postgresql-server<br />Username = postgres<br />Password = tunafish<br />Port = 5432<br />ReadOnly = No<br />...<br /><br />[root@localhost ~]# vi /etc/odbcinst.ini<br />...<br />[PostgreSQL]<br />Description = ODBC for PostgreSQL<br />Driver = /usr/lib/libodbcpsql.so<br />Setup = /usr/lib/libodbcpsqlS.so<br />FileUsage = 1<br />...<br /><br />[root@localhost ~]# isql PSQL<br />+---------------------------------------+<br />| Connected! |<br />+---------------------------------------+<br />SQL><br />...<br /><br />[root@localhost ~]#<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/2591819854027345464-7819317130817373701?l=postgre-sql.blogspot.com' alt='' /></div>duduhttp://www.blogger.com/profile/07640220666785289980noreply@blogger.com1tag:blogger.com,1999:blog-2591819854027345464.post-53912885276754598082008-10-07T00:23:00.000-07:002008-10-07T00:35:11.304-07:00<span style="font-weight: bold;">PostgreSQL Installation on CentOS (Linux i386)</span><br /><br />[root@localhost ~]# mkdir postgreSQL<br /><br />[root@localhost ~]# cd postgreSQL<br /><br />[root@localhost postgreSQL]# wget http://yum.pgsqlrpms.org/8.3/redhat/rhel-5-i386/postgresql-libs-8.3.4-1PGDG.rhel5.i386.rpm<br /><br />[root@localhost postgreSQL]# wget http://yum.pgsqlrpms.org/8.3/redhat/rhel-5-i386/postgresql-8.3.4-1PGDG.rhel5.i386.rpm<br /><br />[root@localhost postgreSQL]# wget http://yum.pgsqlrpms.org/8.3/redhat/rhel-5-i386/postgresql-server-8.3.4-1PGDG.rhel5.i386.rpm<br /><br />[root@localhost postgreSQL]# rpm -i postgresql-libs-8.3.4-1PGDG.rhel5.i386.rpm<br /><br />[root@localhost postgreSQL]# rpm -i postgresql-8.3.4-1PGDG.rhel5.i386.rpm<br /><br />[root@localhost postgreSQL]# rpm -i postgresql-server-8.3.4-1PGDG.rhel5.i386.rpm<br /><br />[root@localhost postgreSQL]# service postgresql initdb<br />Initializing database: [ OK ]<br /><br />[root@localhost postgreSQL]# su - postgres<br /><br />-bash-3.2$ vi /var/lib/pgsql/data/pg_hba.conf<br />...<br />local all all trust<br />host all all 127.0.0.1/32 trust<br />host all all 192.168.10.0/24 md5<br />...<br /><br />-bash-3.2$ psql<br />Welcome to psql 8.2.9, the PostgreSQL interactive terminal.<br />...<br />postgres=# alter user postgres with password '<the>';<br />...<br /><br />-bash-3.2$ vi /var/lib/pgsql/data/pg_hba.conf<br />...<br />local all all md5<br />host all all 127.0.0.1/32 md5<br />host all all 192.168.10.0/24 md5<br />...<br /><br />-bash-3.2$ vi /var/lib/pgsql/data/postgresql.conf<br />...<br />listen_addresses = '*'<br />...<br /><br />-bash-3.2$ exit<br /><br />[root@localhost postgreSQL]# /etc/init.d/postgresql start<br />Starting postgresql service: [ OK ]<br /><br /><br /></the><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/2591819854027345464-5391288527675459808?l=postgre-sql.blogspot.com' alt='' /></div>duduhttp://www.blogger.com/profile/07640220666785289980noreply@blogger.com3