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

Re: [HACKERS] PG_UPGRADE status?

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] PG_UPGRADE status?
Date: 1999-09-08 18:28:49
Message-ID: 199909081828.OAA17938@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
> I know Tom Lane has done some work on pg_upgrade -- the last message was
> on 8/2/99, and left the thread hanging.
> 
> What is the current status of pg_upgrade in 6.5.x??
> 
> I ask because the presence of a working pg_upgrade drastically reduces
> the work necessary to get postgresql upgrading working prpoerly in an
> RPM environment.  I particular, the upgrade from RedHat 6.0 to RedHat
> 6.1 is going to be from postgresql 6.4.2 to 6.5.1.  I do not forsee
> anyone successfully upgrading a RedHat 5.x installation to 6.1, as other
> things will break -- although I could be entirely wrong.

pg_upgrade will not work in converting from <= 6.4.* to 6.5.* because
the on-disk date format changed in 6.5.  Hopefully, 6.6 will allow
pg_upgrade for 6.5.* databases.  We try not to change the on-disk
format, but sometimes we have to.  MVCC required it for 6.5.*. 

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist(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

Responses

pgsql-hackers by date

Next:From: Lamar OwenDate: 1999-09-08 19:04:30
Subject: Re: [HACKERS] PG_UPGRADE status?
Previous:From: Lamar OwenDate: 1999-09-08 17:30:10
Subject: Re: [HACKERS] Problem enabling pltcl

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