Re: [cobalt-users] Postgres is not running and it will not restart

[Gerald Waugh <gwaugh@xxxxxxxxxxxxxxxxxxxxxxx>]

On Mon, 30 Jun 2003 rdkurth@xxxxxxxxxxxx wrote:

> I can not get postgres to start on my Raq4 server. I have rebooted
> and that did not  help, When I ssh into the server and su to root I
> then run
> [root init.d]# ./postgresql start
> I get this error
> Setting up PostgreSQL: bash: /var/log/postgresql: Permission denied
> failed!
>
> I also thought I would just rebuild that database but because
> postgresql is not  running I can't seam to be able to do that ether.
> This is what I get when I try to dump  the database.
> pg_dump cobalt > cobalt.dump psql: connectDBStart() -- connect()
> failed: Connection refused
>         Is the postmaster running at 'localhost'
>         and accepting connections on Unix socket '5432'?
>
> Can somebody tell me what I need to do to fix this problem

Check ownership/permissions;
RaQ4 (RaQ3 /home/pgsql)
ls -l /var/lib/pgsql
drwx------  2 postgres postgres 6 Mar 19  2002 backups
drwx------  2 postgres postgres 6 Mar 19  2002 data

If that's correct, then drill down and see if everything
is owned by the postgres user.

Just a guess, maybe permission are screwed up!
You are 'root' user when you tried starting it?

Also check /var/log/postgresql
I believe it should also be user.group postgres

Gerald
--
http://frontstreetnetworks.com | http://store.raqware.com
  Front Street Networks LLC, 229 Front Street, Ste.#C
  New Haven, CT 06513-3203 | phone: +1-203-785-0699