On Mar 20, 2006, at 4:48 PM, Tom Lane wrote:
"Thomas F. O'Connell" <[EMAIL PROTECTED]> writes:
A base backup taken from a running postmaster will still include a
postmaster.pid file, which will prevent a new postmaster from being
able to be started.
Usually not; only if the PID mentioned in the file belongs to an
existing process belonging to the postgres userid does Postgres
believe
that the pidfile is valid.
It might be worth mentioning this as you suggest, but I think it's a
sufficiently low-probability case that your failure was probably
due to
something else.
My test scenario involved setting up a new cluster on the same
machine as the base postgres I was attempting to recover. So you're
probably right about the rarity.
What about the larger suggested change of breaking that section into
three more granular subsections? I could see commentary being
slightly more helpful for each.
--
Thomas F. O'Connell
Database Architecture and Programming
Co-Founder
Sitening, LLC
http://www.sitening.com/
3004 B Poston Avenue
Nashville, TN 37203-1314
615-260-0005 (cell)
615-469-5150 (office)
615-469-5151 (fax)
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend