Postgresql

How to install Postgres 8

This howto are created with information extracted from forums. Proceed at your own risk. Work for me.

Enable centosplus repository and install postgres (at the time writen this howto is 8.1.9 version)

yum --enablerepo=centosplus install postgresql postgresql-contrib postgresql-devel postgresql-docs postgresql-pl postgresql-python postgresql-test

The above command install postgres and update postgres-libs, and install for dependency tcl and mx from base repository. If you see other packages, such as perl or php, abort the installation now!. This ocur because maybe you have installed perl-CGI-Session or perl-DBD-Pg. These two packages are in your system because you have installed otrs oe other aplication. In my case I have remove these two packages (because I not need otrs), and run again the installation.

The make the necesary custom templates:

/etc/init.d/postgresql start
mkdir -p /etc/e-smith/templates/var/lib/pgsql/data
mkdir -p /etc/e-smith/templates-custom/var/lib/pgsql/data
cp /var/lib/pgsql/data/postgresql.conf /etc/e-smith/templates/var/lib/pgsql/data
cp /var/lib/pgsql/data/pg_hba.conf /etc/e-smith/templates/var/lib/pgsql/data
cp /var/lib/pgsql/data/postgresql.conf /etc/e-smith/templates-custom/var/lib/pgsql/data
cp /var/lib/pgsql/data/pg_hba.conf /etc/e-smith/templates-custom/var/lib/pgsql/data