On Fri, Jan 29, 2010 at 12:03 AM, Mason Hale <ma...@onespot.com> wrote: > Of course the best solution is to avoid this issue entirely. Something as > easy to miss as file permissions should not cause data corruption, > especially in the process meant to fail over from a crashing primary > database.
I believe that such a file permission problem does nothing but shut down the standby by a FATAL error, and wouldn't cause data corruption. So if you remove the trigger file with a wrong permission after the shutdown, you can restart a recovery well by just starting the standby postgres. Regards, -- Fujii Masao NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs