From: | "Thomas F(dot) O'Connell" <tf(at)o(dot)ptimized(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | pg_standby: Unremovable Trigger File |
Date: | 2007-04-11 22:18:06 |
Message-ID: | 22317D19-3721-44B1-9A87-EB5D1969D5AD@o.ptimized.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I've been testing pg_standby as a helper application for a warm
standby setup. So far, so good. When the environment is controlled
and everything happens as expected, I'm able to operate a basic
primary/standby setup. (This is all using 8.2.3 on Solaris x86, btw.)
One thing I noticed in early testing, though, was the scenario where
the trigger file can't be removed by pg_standby. I touched a trigger
file as root, which made it unremovable by postgres. So this tripped
the relevant error condition in pg_standby.
I had a little difficulty understanding in what state this left the
recovery process, and I'm not helping myself much by reading the
code. Doesn't the non-zero exit from CheckForExternalTrigger mean
that pg_standby will be signaling to the standby server a file-not-
found scenario?
--
Thomas F. O'Connell
optimizing modern web applications
: for search engines, for usability, and for performance :
http://o.ptimized.com/
615-260-0005
From | Date | Subject | |
---|---|---|---|
Next Message | SCassidy | 2007-04-11 22:22:50 | Re: SQL - finding next date |
Previous Message | Leon Mergen | 2007-04-11 22:00:20 | hashtext () and collisions |