[SOLVED] PostgreSQL Server isn't starting

[Dr Small]

I had the same problem:

root@mycroft:/home/drsmall# /etc/init.d/postgresql-8.2 status
Use of uninitialized value in getpwuid at /usr/bin/pg_lsclusters line 28.
Version Cluster   Port Status Owner    Data directory                     Log file
8.2     main      5432 down   root     /var/lib/postgresql/8.2/main       /var/log/postgresql/postgresql-8.2-main.log

It's basically saying it can't find the default PGDATA directory /var/lib/postgresql/8.2/main. It may be easier to just create the default PGDATA directory and then initdb /var/lib/postgresql/8.2/main. This would mean you wouldn't have to rewrite the init.d script too.

Ah well. I'm not that smart. Thanks for sharing that though!

[Hashimi]

Hi

When i run:

$ sudo /etc/init.d/postgresql-8.3 start

I have face with this message:

* Starting PostgreSQL 8.3 database server Error: /var/lib/postgresql/8.3/main is not accessible or does not exist
[fail]

What can i do?

I also installed postgresql-8.4.0 but in init.d it is 8.3.

[Hashimi]

After i replace my init.d/postgresql-8.3 with Dr Small s modified version from first page; i get this message:

pg_ctl: another server might be running; trying to start server anyway
pg_ctl: could not start server
Examine the log output.

[PrivateLifeOfPlants]

Hi, The problem seems to be a broken dependency issue. I posted a solution to this issue in the following thread:

http://ubuntuforums.org/showthread.p...=1#post8389411