From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org> |
Subject: | Re: [HACKERS] pg_upgrade |
Date: | 2002-01-10 06:09:58 |
Message-ID: | 200201100609.g0A69wu04045@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
Bruce Momjian wrote:
> Tom asked about pg_upgrade as part of our initdb for timezone.
>
> I have made some improvements to pg_upgrade in CVS and have successfully
> migrated a regression database from a 7.2 to another 7.2 database using
> it. (At least the tables show some data; very light testing.)
Here is a patch I need to /contrib/pg_resetxlog to support a new "-x
XID" option to set the XID in pg_control. Patch attached. This is the
last feature I needed for a functioning pg_upgrade for 7.1->7.2 and
7.2->7.2 databases.
Many commercial distributions like this script, and with our
newly-needed initdb to fix our timezonetz problem, it seemed like a good
time. :-) It certainly reduces upgrade time.
(BTW, where are we on that timezonetz patch anyway? Tom posted it two
days ago and I haven't seen any comments.)
pg_upgrade is still disabled.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
Attachment | Content-Type | Size |
---|---|---|
unknown_filename | text/plain | 5.3 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Oleg Bartunov | 2002-01-10 06:32:37 | Re: RC1 time? |
Previous Message | Christopher Kings-Lynne | 2002-01-10 03:38:30 | Re: DOSSIER |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-01-10 17:52:30 | Re: [HACKERS] pg_upgrade |
Previous Message | Zeugswetter Andreas SB SD | 2002-01-09 17:40:37 | Makefile.aix patch for shlib's |