How to implement autostart of postgres?

From: "Gavrina, Irina" <igavrina(at)mera(dot)ru>
To: <pgsql-general(at)postgresql(dot)org>
Subject: How to implement autostart of postgres?
Date: 2011-07-28 10:06:33
Message-ID: 1958F96A86875D4F8B605C0E8054A8F1018E7B9A@gmail.merann.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Maton, Brett 2011-07-28 10:13:32 Fresh Restore - relation contains more than "max_fsm_pages"
Previous Message Nithya Rajendran 2011-07-28 06:45:04 Master/Slave Setup and Incremental Backup