Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] pg_upgrade

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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

In response to

  • pg_upgrade at 2002-01-09 16:04:01 from Bruce Momjian

Responses

pgsql-hackers by date

Next:From: Oleg BartunovDate: 2002-01-10 06:32:37
Subject: Re: RC1 time?
Previous:From: Christopher Kings-LynneDate: 2002-01-10 03:38:30
Subject: Re: DOSSIER

pgsql-patches by date

Next:From: Tom LaneDate: 2002-01-10 17:52:30
Subject: Re: [HACKERS] pg_upgrade
Previous:From: Zeugswetter Andreas SB SDDate: 2002-01-09 17:40:37
Subject: Makefile.aix patch for shlib's

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group