Postgresql didn't start after power failure

Поиск
Список
Период
Сортировка
От Clodoaldo Pinto
Тема Postgresql didn't start after power failure
Дата
Msg-id 20050112200826.61769.qmail@web40913.mail.yahoo.com
обсуждение исходный текст
Ответы Re: Postgresql didn't start after power failure  ("Ed L." <pgsql@bluepolka.net>)
Re: Postgresql didn't start after power failure  (Lonni J Friedman <netllama@gmail.com>)
Список pgsql-general
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?

Regards, Clodoaldo Pinto





_______________________________________________________
Yahoo! Acesso Grátis - Instale o discador do Yahoo! agora. http://br.acesso.yahoo.com/ - Internet rápida e grátis

В списке pgsql-general по дате отправления:

Предыдущее
От: Terry Lee Tucker
Дата:
Сообщение: Re: Interval Question
Следующее
От: Jeff Davis
Дата:
Сообщение: index on user defined type