Search Postgresql Archives

Re: restarting after power outage

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Jon Lapham <lapham@xxxxxxxxx> writes:
> Tom Lane wrote:
>> It is.  We have been fooling with the postmaster startup logic to try to
>> eliminate this gotcha, but it's only very recently (8.0.2) that I think
>> we got it right.

> So, then it would be correct to change my init scripts to do the 
> following:  (if so, this patch can be applied to the 7.4 branch)

I would recommend strongly AGAINST that, because what you just did was
remove the defense against starting two postmasters concurrently in the
same data directory (which would be a disaster of the first magnitude).
This is not a problem for bootup of course, but if you ever use this
script to start the postmaster by hand, then you are playing with fire.

We would have put something like that in the standard init scripts
years ago if it were safe.

If you want a solution in the 7.4 branch, I have back-patched the
8.0.2 fix into the latest Fedora Core 3 RPMs (7.4.7-5.FC3.1).

			regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux