# Install postgres
tar xvzf postgresql-7.2.2.tar.gz
 cd postgresql-7.2.2
./configure --enable-odbc --with-unixodbc 
gmake
gmake install
/usr/sbin/adduser postgres
mkdir /usr/local/pgsql/data
chown postgres /usr/local/pgsql/data
su - postgres
# create database
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data 
# start database server
/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data >logfile 2>&1 & 
/usr/local/pgsql/bin/createdb test
/usr/local/pgsql/bin/psql test
# Using ODBCConfig as root I have added to /etc/odbcinst.ini the lines
# [POSTGRES]
#Description             = PostGres ODBC dirver
#Driver          = /opt/unixODBC-2.2.3/lib/libodbcpsql.so
#Setup           = /opt/unixODBC-2.2.3/lib/libodbcpsqlS.so
#FileUsage               = 1
#CPTimeout               =
#CPReuse         =
# Using ODBCCOnfig as rover I have added to $HOME/.odbc.ini the lines
#[test]
#Description             = POSTGRES
#Driver          = POSTGRES
#Trace           = No
#TraceFile               =
#Database                = test
#Servername              = localhost
#UserName                = postgres
#Password                =
#Port            = 5432
#Protocol                = 6.4
#ReadOnly                = No
#RowVersioning           = No
#ShowSystemTables                = No
#ShowOidColumn           = No
#FakeOidIndex            = No
#ConnSettings            =
# If you want to launch postgres server authomatically at boot time, add
# the following line to /etc/rc.local
su -l postgres -c "/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data >logfile 2>&1 &"