1

I've just rebooted my server, but the PostgreSQL database server has not started.

I've tried the following command to see what's going on:

[root@p15179551 data]# service postgresql status
postgresql: unrecognized service

But as you can see, it says unrecognized service.

Any idea why it would be doing this?

1
  • 1
    I order to help we need to know what distribution you are running. And, if the file /etc/init.d/postgresql exists because that one is called when you issue "service postgresql status".
    – Fladi
    Nov 22, 2010 at 11:40

1 Answer 1

2

It seems postgresql isn't installed at all or at least its init scripts are missing.

Did your server crash? Did you (unintentionally) remove the postgresql package? Check if the postgresql package is installed. It can be doning in ubuntu/debian with this command:

aptitude search 'postgresql~i'

If there is any output postgresql should be installed. It that case try reinstalling it:

aptitude reinstall postgresql

If it isn't installed at all install it using:

aptitude install postgresql
3
  • Not sure if it crashed, but it wasn't working correctly. Could it be a problem with which user I am trying to issue the command from? All the postgresql files still seem to be on the server
    – Probocop
    Nov 22, 2010 at 10:11
  • At least with ubuntu it doesn't depend on the user issuing the command. What os are you using? If you are using ubuntu try aptitude search postgresql and check if there is an 'i' in front of the postgresql package.
    – joke
    Nov 22, 2010 at 10:28
  • The server is running Fedora Core 2. I got it restarted in the end by logging in as the postgres user. Thanks for your help.
    – Probocop
    Nov 22, 2010 at 14:48

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .