How to implement autostart of postgres?

Поиск
Список
Период
Сортировка
От Gavrina, Irina
Тема How to implement autostart of postgres?
Дата
Msg-id 1958F96A86875D4F8B605C0E8054A8F1018E7B9A@gmail.merann.ru
обсуждение исходный текст
Ответы Re: How to implement autostart of postgres?  (Merlin Moncure <mmoncure@gmail.com>)
Re: How to implement autostart of postgres?  (Craig Ringer <craig@postnewspapers.com.au>)
Список pgsql-general

Thank you all for your answers.

 

I’m using the Red Hat 5 OS. So I have no the ‘upstart’ utility at my disposal. Unfortunately.

 

Yes, you are right, this is a question of database robustness. You know, If any of postgres processes died the postmaster process will again start up it. The main worry is if the postmaster process dies (truth be told, I can reproduce it only using ‘kill –KILL’, which should be never done, I know) and all other processes are up and running. All created connections will go on with their work. And it means all db queries will be processed after the postmaster died. Am I correct?

Is there any risk of losing of data or data corruption in this case?

There is any way to configure the postgres db like ‘if the postmaster process died all child processes are stopped’?

Undoubtedly the case of postmaster process dies should be investigated to discover the root cause.

 

Best regards,

Irina

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

Предыдущее
От: "Maton, Brett"
Дата:
Сообщение: Fresh Restore - relation contains more than "max_fsm_pages"
Следующее
От: Andy Colson
Дата:
Сообщение: Re: using xmin in a query?