Re: Open 7.3 issues
Bruce Momjian <pgman@candle.pha.pa.us>
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Peter Eisentraut <peter_e@gmx.net>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2002-08-16T17:01:50Z
Lists: pgsql-hackers
OK, sounds reasonable. --------------------------------------------------------------------------- Tom Lane wrote: > Bruce Momjian <pgman@candle.pha.pa.us> writes: > > I hadn't looked at flags yet. Thomas's concern, and I think a valid > > one, is that if we move it from contrib into the main tree, people may > > accidentally run pg_resetxlog without understanding the issues involved. > > There's already an interlock to prevent you from running it against a > live installation (it won't run if it sees a postmaster lock file). > That should also prevent an accidental run against a crashed installation > (presumably a lockfile will still be there). And if you run it against > a cleanly-shut-down installation, it's harmless because you don't need > the old xlog. > > I don't think we need to be so paranoid as to insist that you say > pg_resetxlog --yes-i-read-the-manual > before it will do anything. > > regards, tom lane > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073