Cannot (re)start PostgreSQL

From: "otisg" <otisg(at)iVillage(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Cannot (re)start PostgreSQL
Date: 2002-05-06 03:38:21
Message-ID: 002101c1f4af$782688d0$6ac8010a@mail2world.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

A few minutes ago I had to cold reboot my machine (Red Hat 7.2) that was
running PostgreSQL 7.2, as it (the machine) was hung (which is another
PostgreSQL story that I'll explain separately).

My attempt:
[root(at)linux2 root]# /etc/rc.d/init.d/postgresql restart
Stopping postgresql service: [FAILED]
Starting postgresql service: [FAILED]

The only thing I see in /var/log/messages:
May 5 23:19:26 localhost postgresql: Starting postgresql service: failed

I cannot figure out what is causing this problem.
These are logging-related lines from my ~postgres/data/postgresql.conf
file:

log_connections = true
syslog = 2 # range 0-2

What else can I do to figure out what is going on?
Because of how I had to reboot the machine it is possible that something
got corrupted, but I can't find a way to figure out whether that is the
problem, and if it is, how to fix it (I just searched the 7.2.1 docs and
this list's archives and couldn't find anything related to corruption
and repair).

Is there a way to get a more verbose error message from PostgreSQL that
will tell me why I can't start the DB?

Thank you,
Otis
_______________________________________________________________
Sign up for FREE iVillage newsletters <http://s.ivillage.com/rd/16705> .
>From health and pregnancy to shopping and relationships, iVillage
has the scoop on what matters most to you.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Lamar Owen 2002-05-06 04:03:28 Re: Cannot (re)start PostgreSQL
Previous Message Aaron Spiteri 2002-05-05 22:29:10 Re: Trigger problem