From:
Greg Copeland <greg(at)CopelandConsulting(dot)Net>
To:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc:
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>,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>,PostgresSQL Hackers Mailing List <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: Upgrading rant.
Date:
2003-01-05 14:47:48
Message-ID:
1041778067.15932.238.camel@mouse.copelandconsulting.net (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
On Sat, 2003-01-04 at 22:37, Tom Lane wrote:
> 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.
> $
>
Well, first, let me say that the above just seems wrong. I can't think
of any valid reason why reserved shouldn't be allowed to equal max.
I also assumed that pg_update would be attempting to connect as the
superuser. Therefore, if you only allow a single connection from the
superuser and pg_upgrade is using it, that would seem fairly hard to
mess things up. On top of that, that's also the risk of someone being a
superuser. They will ALWAYS have the power to hose things. Period. As
such, I don't consider that to be a valid argument.
--
Greg Copeland <greg(at)copelandconsulting(dot)net>
Copeland Computer Consulting
In response to
Responses
pgsql-hackers by date
Next :From: Greg CopelandDate: 2003-01-05 14:53:25Subject : Re: [GENERAL] v7.3.1 Bundled and Released ...Previous :From : Justin CliftDate : 2003-01-05 13:21:51Subject : Re: New Portal in Place, DNS switched ...
