Postgresql can't find postmaster.pid

Arvand

Well-Known Member
Jul 26, 2003
128
1
168
Hello,

I first tried /scripts/installpostgres but it said RPMs existed and the service wouldn't start. So I removed the rpms and tried the script again. It still wouldn't start ([Failed]). And of course just like everything else that doesn't work it writes nothing usefull to the logs so I had no idea why it wasn't working. When I used WHM to install the pgsql config file it gave this error:

Setting up Postgres Config...Done
Reloading Postgres...pg_ctl: cannot find /var/lib/pgsql/data/postmaster.pid
Is postmaster running?
Done

The Postgres config install has been completed.

If i understand correct. Postmaster comes with the pgsql server rpm. Why does it not go there on my server?

Thank you,

Arvand Sabetian

cPanel.net Support Ticket Number:
 

Arvand

Well-Known Member
Jul 26, 2003
128
1
168
no body even tried installing postgresql?

cPanel.net Support Ticket Number:
 

ahaley

Member
Oct 6, 2003
12
0
151
Hi
Hope this is not too late for any use for you, but I just had exactly the same problem and my hosting co helped me - this is what to do:

login to ssh as root:

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

then run the postgre install again under ssh:

/scripts/installpostgres

then log into your WHM admin and click on the Postgre Config and reconfig and then change your password and all should be working.

Regards
Andrew Haley


cPanel.net Support Ticket Number: :cool:

cPanel.net Support Ticket Number:
 

Website Rob

Well-Known Member
Mar 23, 2002
1,501
1
318
Alberta, Canada
cPanel Access Level
Root Administrator
In 'root' WHM >> Restart Services - one should see: Postgresql Server. If not there it is probably not installed. Easiest method is to use WHM >> Software >> Install an RPM >> postgresql

The big tip-off is, if it doesn't say (reinstall) then it is not installed.

Don't know why the reference made to /var/lib/pgsql as I have not found that path under any of the Servers I manage -- even though Postgrsql is installed and functional?


Edit: seems I jumped the gun a bit. A locate for postmaster.pid returned nothing and cannot log into phpPgAdmin. Seems a Search for more info is in order. ;)


Edit: easier than I thought. After the above one must go back and RPM install postgresql-server. All worked fine after that.
 
Last edited: