| From: | Manfred Koizar <mkoi-pg(at)aon(dot)at> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>, Lamar Owen <lowen(at)pari(dot)edu>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, Dennis Gearon <gearond(at)fireserve(dot)net>, Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>, PgSQL General ML <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: State of Beta 2 |
| Date: | 2003-09-20 00:27:41 |
| Message-ID: | 307nmvoirdqm4h9gc1a5bh9gldd9ah5d15@email.aon.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, 19 Sep 2003 18:51:00 -0400, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
wrote:
>transfer the schema into the new installation using "pg_dump -s" and
>then push the user tables and indexes physically into place.
I'm more in favour of in-place upgrade. This might seem risky, but I
think we can expect users to backup their PGDATA directory before they
start the upgrade.
I don't trust pg_dump because
. it doesn't help when the old postmaster binaries are not longer
available
. it does not always produce scripts that can be loaded without manual
intervention. Sometimes you create a dump and cannot restore it with
the same Postmaster version. RTA.
Servus
Manfred
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Manfred Koizar | 2003-09-20 01:06:44 | Re: State of Beta 2 |
| Previous Message | Tom Lane | 2003-09-20 00:06:39 | Re: State of Beta 2 |