Re: Postgresql didn't start after power failure

On Wed, 12 Jan 2005 17:08:26 -0300 (ART), Clodoaldo Pinto
<clodoaldo_pinto(at)yahoo(dot)com(dot)br> wrote:
> There was a power failure and then the postgresql service didn't start on
> system restart:
>
> System restart after power failure:
> Jan 12 16:49:06 s1 syslogd 1.4.1: restart.
> Jan 12 16:49:18 s1 su(pam_unix)[2098]: session opened for user postgres by
> (uid=0)
> Jan 12 16:49:18 s1 su(pam_unix)[2098]: session closed for user postgres
> Jan 12 16:49:19 s1 postgresql: Iniciando serviço postgresql : failed
>
> When I manually rebooted the system postgres restarted:
> Jan 12 18:40:42 s1 su(pam_unix)[2083]: session opened for user postgres by
> (uid=0)
> Jan 12 18:40:43 s1 su(pam_unix)[2083]: session closed for user postgres
> Jan 12 18:40:44 s1 postgresql: Iniciando serviço postgresql : succeeded
>
> /var/log/pgsql is empty and is chmoded as executable (?). It is an Anaconda
> install in FC2. Now up to 7.4.6.
>
> The last activity before power failure was a vacuum full and after that nothing
> at all for more than one hour.
> Is there anyway to know why did it not start and prevent it to happen again?
> How to configure it to write a log at system boot?

So its silently failing without logging anything? Is it configured to
log to /var/log/pgsql in /etc/init.d/postgresql ? Perhaps it left a
stale pid file behind? Did you try running a 'postgresql service
stop' ?

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman netllama(at)gmail(dot)com
LlamaLand http://netllama.linux-sxs.org