I am trying to install Postgresql on my Redhat Ent. VPS. I have used the following steps to install it:
COPIED FROM ANOTHER SITE:
**************************************************************************************************
rpm -qa | grep postgres | tee /root/rpm_pgsql
The above will list all the installed postgresql rpm packages and store the output to /root/rpm_pgsql. You can use this list to remove all the postgresql related rpm later.
Remove the old rpms using rpm -e, you can use the previously stored /root/rpm_pgsql to remove the postgresql rpm and its dependancies
For example:
rpm -e rh-postgresql-server
rpm -e rh-postgresql
rpm -e rh-postgresql-devel
rpm -e rh-postgresql-python
rpm -e rh-postgresql-libs
Download the following postgreSQL RPMs from the Postgresql download site into any directory you prefer.
(version numbers will vary)
postgresql-8.1.0-2PGDG.i686.rpm
postgresql-contrib-8.1.0-2PGDG.i686.rpm
postgresql-devel-8.1.0-2PGDG.i686.rpm
postgresql-docs-8.1.0-2PGDG.i686.rpm
postgresql-libs-8.1.0-2PGDG.i686.rpm
postgresql-python-8.1.0-2PGDG.i686.rpm
postgresql-server-8.1.0-2PGDG.i686.rpm
Now install the RPMs:
rpm -Uhv postgresql*.rpm
After you have installed the new postgreSQL rpms login to WHM:
under the SQL service Menu
Postgres Config
Install new configuration and change the password
**********************************************************************************************************
After the last step I log into Cpanel and try to create users and DBs but nothing gets created (although it says it did). Also, I noticed the pg_hba.conf file is updated during the configuration (time stamp changes) but the only thing in it is:
local all all md5
host all all 127.0.0.1 255.255.255.255 md5
It seems based on what I have read that this file is incomplete however I don’t know what is *supposed* to be in it and I don’t know why it’s hosed.
Can someone please shed some light on this for me or point me toward some information that might help?