On Wed, 12 Jan 2005 17:08:26 -0300 (ART), Clodoaldo Pinto <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] LlamaLand http://netllama.linux-sxs.org ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
