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(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