Re: pg_upgrade

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.)
> 
> pg_upgrade is still disabled in CVS, it doesn't install, and there is no
> manual page so it is still an unused command. I have made the commit so
> people can review where I have gone and make comments.
> 
> To test it, you have to find the line that says 7.2 and remove the '#'
> comment.  This is for testing purposes only, so far.

Status report:  I have completed all the steps necessary for pg_upgrade
to work for 7.1->7.2 and for 7.2->7.2 databases.  I will run tests
tomorrow, and once I am sure it works, I will ask others to test.

I will not enable it until everyone agrees.  Are there people interested
in this tool being in 7.2, or who are against this tool being in 7.2?

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026