From:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:
Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
Cc:
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>,Hannu Krosing <hannu(at)tm(dot)ee>, mlw <pgsql(at)mohawksoft(dot)com>,Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>, pgsql-hackers(at)postgresql(dot)org
Subject:
Re: Upgrading rant.
Date:
2003-01-04 15:53:41
Message-ID:
27263.1041695621@sss.pgh.pa.us (view raw or flat )
Thread:
2003-01-02 23:18:23 from Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>
2003-01-03 00:26:06 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2003-01-03 00:42:09 from "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu>
2003-01-03 13:45:13 from mlw <pgsql(at)mohawksoft(dot)com>
2003-01-03 16:33:12 from Hannu Krosing <hannu(at)tm(dot)ee>
2003-01-03 19:19:28 from mlw <pgsql(at)mohawksoft(dot)com>
2003-01-03 20:37:56 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2003-01-03 23:31:41 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2003-01-04 00:14:17 from "Serguei Mokhov" <mokhov(at)cs(dot)concordia(dot)ca>
2003-01-04 00:37:43 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2003-01-04 01:19:20 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2003-01-04 01:31:08 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2003-01-04 01:32:15 from Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>
2003-01-04 01:36:42 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2003-01-04 01:47:14 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2003-01-06 03:25:21 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2003-01-06 03:30:41 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2003-01-04 02:17:39 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2003-01-04 04:02:28 from Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
2003-01-04 15:53:41 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2003-01-04 18:23:46 from Greg Copeland <greg(at)CopelandConsulting(dot)Net>
2003-01-05 04:24:14 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2003-01-05 04:37:59 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2003-01-05 14:47:48 from Greg Copeland <greg(at)CopelandConsulting(dot)Net>
2003-01-06 03:22:32 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2003-01-06 03:56:13 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2003-01-05 02:12:05 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2003-01-05 02:21:40 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2003-01-06 04:04:59 from Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>
2003-01-06 04:10:08 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2003-01-06 04:41:30 from Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>
2003-01-04 04:16:26 from Dan Langille <dan(at)langille(dot)org>
2003-01-04 05:39:37 from Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
2003-01-05 16:36:16 from mlw <pgsql(at)mohawksoft(dot)com>
2003-01-06 03:21:10 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2003-01-06 18:06:51 from Thomas O'Connell <tfo(at)monsterlabs(dot)com>
2003-01-06 18:36:04 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2003-01-06 18:56:04 from Thomas O'Connell <tfo(at)monsterlabs(dot)com>
2003-01-07 10:18:15 from Manfred Koizar <mkoi-pg(at)aon(dot)at>
2003-01-07 10:39:58 from Manfred Koizar <mkoi-pg(at)aon(dot)at>
2003-01-03 20:16:34 from Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>
2003-01-03 22:54:00 from Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>
Lists:
pgsql-hackers
Oliver Elphick <olly(at)lfix(dot)co(dot)uk> writes:
> On Sat, 2003-01-04 at 02:17, Tom Lane wrote:
>> There isn't any simple way to lock *everyone* out of the DB and still
>> allow pg_upgrade to connect via the postmaster, and even if there were,
>> the DBA could too easily forget to do it.
> I tackled this issue in the Debian upgrade scripts.
> I close the running postmaster and open a new postmaster using a
> different port, so that normal connection attempts will fail because
> there is no postmaster running on the normal port.
That's a good kluge, but still a kluge: it doesn't completely guarantee
that no one else connects while pg_upgrade is trying to do its thing.
I am also concerned about the consequences of automatic background
activities. Even the periodic auto-CHECKPOINT done by current code
is not obviously safe to run behind pg_upgrade's back (it does make
WAL entries). And the auto-VACUUM that we are currently thinking of
is even less obviously safe. I think that someday, running pg_upgrade
standalone will become *necessary*, not just a good safety feature.
regards, tom lane
In response to
Responses
pgsql-hackers by date
Next :From: Tom LaneDate: 2003-01-04 16:02:01Subject : Re: pg_dump.options.diff Previous :From : Kaare RasmussenDate : 2003-01-04 12:59:35Subject : Re: Threads
