Re: Cannot (re)start PostgreSQL

Thank you, this was it.

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.

<-----Original Message----->
>
> From: tulasi
> Sent: 5/6/2002 12:02:45 AM
> To: otisg(at)iVillage(dot)com
> Subject: Re: [ADMIN] Cannot (re)start PostgreSQL
>
>
> hi,
> Just remove the postmaster.pid file from your data and then try to
restart postgresql server...
> hope this can work out for you.
> all the best
> Tulasi
> otisg wrote: 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.
> From health and pregnancy to shopping and relationships, iVillage
> has the scoop on what matters most to you. Just
>
> Do You Yahoo!?
> Yahoo! Health - your guide to health and wellness