Postgresql

[ablenetdesign]

I may as well be the first to post in this forum.

Any way I installed postgresql via

yum install postgresql postgresql-server

everything went smoothly.

I go to start the service using

service postgresql start

I get the following error:

/var/lib/pgsql/data in missing. Use "service postgresql initdb" to initialize the cluster first [FAILED]

So I run "service postgresql initdb" and now I get the following error:

Initializing database: mkdir: cannot create directory `/var/lib/pgsql/data/pg_log': File exists
[FAILED]

Does anyone know how to get pgsql up and running.

Thanks in advance.

[Aaron]

I don't have much experience with Postgresql, but maybe try this:

rm /var/lib/pgsql/data/pg_log
pg_ctl --log /tmp/pg.log start

[ablenetdesign]

Thanks Aaron,

I removed the file and had to run checked out the pgstartup.log and this is what I found.

The program "postgres" is needed by initdb but was not found in the
same directory as "/usr/bin/initdb".

[Aaron]

Which version of postgresql are you attempting to install?

[gitto]

cPanel requires Postgresql 7.3.x or later. 7.2.x will not work.

===========================================
Step 1
===========================================
Upgrade to cPanel 7.4.0 build 45 or later
===========================================

===========================================
Step 1a (If you do not have 7.2.x or earlier installed skip this step)
===========================================
Login to a root shell via ssh or the console.

If you have Postgres 7.2.x installed, backup your databases using pg_dumpall or some other method.

Move the postgres data directory somewhere else. ie

mv /var/lib/pgsql /var/lib/pgsql.old
===========================================


===========================================
Step 2
===========================================
Login to a root shell via ssh or the console and run

/scripts/installpostgres
rm -rf /var/lib/pgsql/data/
su postgres
initdb /var/lib/pgsql/data/
logout
service postgresql restart

Run eassapache and enable postgres

/scripts/easyapache
===========================================

===========================================
Step 2a (skip this step if you are not upgrading from postgres 7.2 or earlier
===========================================
Restore your sql dump created with pg_dumpall or by some other method using psql or some other method
===========================================


===========================================
Step 3
===========================================
Login to Web Host Manager and choose "Postgres Config" under Server Setup.

Set a postgres password to anything of your choosing. You should avoid using any non-alpha numeric charaters as these cause problems.
===========================================


===========================================
Step 4
===========================================
Use the "Postgres Config" option in WHM to install a postgres pg_hba.conf file. You can skip this step if you would like to setup your pg_hba.conf file manually. cPanel should work fine with md5 passwords or plaintext passwords
===========================================


===========================================
Step 5
===========================================
Login to cPanel and click on Postgres .. Enjoy!
===========================================