Re: [GENERAL] How to implement autostart of postgres?

2011-07-29 Thread Craig Ringer
On 28/07/11 18:06, Gavrina, Irina wrote: Yes, you are right, this is a question of database robustness. Honestly, this is the wrong approach to high availability. Don't try to make one machine unbreakable - you *cannot* do it. Use multi-machine failover between a master and a replica with

Re: [GENERAL] How to implement autostart of postgres?

2011-07-29 Thread Tom Lane
Craig Ringer cr...@postnewspapers.com.au writes: On 28/07/11 18:06, Gavrina, Irina wrote: Is there any risk of losing of data or data corruption in this case? Possibly, if you then remove postmaster.pid, thus bypassing the other safety, and start a new postmaster. I'm a bit alarmed to

[GENERAL] How to implement autostart of postgres?

2011-07-28 Thread Gavrina, Irina
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

Re: [GENERAL] How to implement autostart of postgres?

2011-07-28 Thread Merlin Moncure
On Thu, Jul 28, 2011 at 5:06 AM, Gavrina, Irina igavr...@mera.ru wrote: 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

Re: [GENERAL] How to implement autostart of postgres?

2011-07-21 Thread Tom Lane
Gavrina, Irina igavr...@mera.ru writes: I've faced with the following problem: I'm trying to implement the auto start of postgres. My way is to use inittab: pg:2345:respawn:/bin/su - postgres -c /usr/local/pgsql/bin/postmaster -D/usr/local/pgsql/data /usr/local/pgsql/server.log 21 /dev/null

[GENERAL] How to implement autostart of postgres?

2011-07-20 Thread Gavrina, Irina
Hello All, I've faced with the following problem: I'm trying to implement the auto start of postgres. My way is to use inittab: pg:2345:respawn:/bin/su - postgres -c /usr/local/pgsql/bin/postmaster -D/usr/local/pgsql/data /usr/local/pgsql/server.log 21 /dev/null But this approach does not

Re: [GENERAL] How to implement autostart of postgres?

2011-07-20 Thread John R Pierce
On 07/20/11 4:02 AM, Gavrina, Irina wrote: I’ve faced with the following problem: I’m trying to implement the auto start of postgres. My way is to use inittab: pg:2345:respawn:/bin/su - postgres -c /usr/local/pgsql/bin/postmaster -D/usr/local/pgsql/data /usr/local/pgsql/server.log 21 /dev/null

Re: [GENERAL] How to implement autostart of postgres?

2011-07-20 Thread Craig Ringer
On 20/07/11 19:02, Gavrina, Irina wrote: Hello All, I’ve faced with the following problem: I’m trying to implement the auto start of postgres. My way is to use inittab: pg:2345:respawn:/bin/su - postgres -c /usr/local/pgsql/bin/postmaster Are you working on some kind of