From:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc:
Oliver Elphick <olly(at)lfix(dot)co(dot)uk>, 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-05 04:37:59
Message-ID:
6281.1041741479@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
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> Tom Lane wrote:
>> 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 was thinking about using GUC:
> #max_connections = 32
> #superuser_reserved_connections = 2
> Set both of those to 1, and you lock out everyone but the super-user.
You're missing the point: I don't want to lock out everyone but the
super-user, I want to lock out everyone, period. Superusers are just
as likely to screw up pg_upgrade as anyone else.
BTW:
$ postmaster -N 1 -c superuser_reserved_connections=1
postmaster: superuser_reserved_connections must be less than max_connections.
$
regards, tom lane
In response to
Responses
pgsql-hackers by date
Next :From: Reggie BurnettDate: 2003-01-05 06:23:18Subject : pgsql oid questionPrevious :From : Bruce MomjianDate : 2003-01-05 04:24:14Subject : Re: Upgrading rant.
