PostgreSQL

[Guest xaav]

HelioHost is in the process of upgrading it's PostgreSQL server on stevie, user's may experience some downtime on the PostgreSQL server.

[jje]

We apologise for the delay in this, but PostgreSQL is back online.

 

@admins - djbob has emailed me with an SSH command to fix this. His command didn't work, but a similar one did. Here you go incase this happens again:

[root@stevie]~ /scripts/restartsrv_postgres
[root@stevie]~ /scripts/restartsrv_postgresql

It doesn't have any output, and finished rather quick.

[Krydos]

I was curious about there being two different commands; it seems the first command

/scripts/restartsrv_postgres

just calls the second command and passes in it any arguments

/scripts/restartsrv_postgresql

So I guess it's just there to save you 2 keystrokes? I should stop questioning cPanel...

[jje]

Well, djbob told me to do the first command and I tried that but it didn't work.

 

Then I tried finding any similar scripts on the server, and it succeeded:

[root@stevie]~ locate restartsrv_postgres
2 results found
/scripts/restartsrv_postgres
/scripts/restartsrv_postgresql

 

I tried the second command and it fixed it.

[Guest xaav]

The problem was that PostgreSQL 9.0 was running, but WHM was configured for PostgreSQL 8.3. You just started PostgreSQL 8.3, what I would have preferred to do was update the settings in WHM, so we can use the new version. However, this is a good temporary fix.

[Ashoat]

I'm not sure that there is a setting in WHM to change the version...

[Guest xaav]

Refer to cPanel's website, step 5.

[Ashoat]

Okay, I reset the password. I did not click "Install Config", as we aren't installing for the first time.