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

[rdkurth@xxxxxxxxxxxx]

> > 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

I checked all of the permissions and everything is set correctly.

I don't seam to have a postgresql log file in /var/log/postgresql or 
anywhere else on the server which is very strange.
Yes I was root when I tried starting it.
Anybody know what else I can do about this.