From:
Peter Eisentraut <peter_e(at)gmx(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>,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 02:12:05
Message-ID:
Pine.LNX.4.44.0301041202050.8249-100000@localhost.localdomain (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
Tom Lane writes:
> This would require a nontrivial amount of work (notably, we'd have to
> be able to get pg_dump to run against a standalone backend) but I don't
> think I'd trust pg_upgrade as a production-grade tool until its
> invocation method looks like the above.
I would recommend requiring users to do the schema dump before upgrading
the binaries, so they'd do
pg_dumpall -s > schemadump
pg_ctl stop
[upgrade binaries]
pg_upgrade --option=schemadump
pg_ctl start
--
Peter Eisentraut peter_e(at)gmx(dot)net
In response to
Responses
pgsql-hackers by date
Next :From: Tom LaneDate: 2003-01-05 02:21:40Subject : Re: Upgrading rant. Previous :From : Peter EisentrautDate : 2003-01-05 02:11:37Subject : Re: next set of SSL - ideas?
