On mån, 2012-05-07 at 11:08 -0400, Randy Johnson wrote: > Hello, > > I have a redhat E5 installation with PostgreSQL 7.4 installation. I have > been tasked with upgrading it to 9.x > > I have read that I can install both versions at the same time via YUM and > edit the config file on the new installation to use a different port until > go live time. > > Can anyone confirm if this is true? That would be a good way to go about it, if your packaging supports parallel installations like this. Judging from the age of your existing installation (7.4), however, I'd guess that it does not. So you probably need to build one of the versions from source, do a partial upgrade, or remove the old version. You will likely have some thinking to do. > I also read this is the ideal way to go so I can use the newer version of > pg_dumpall to transfer the data because the newer version contains bug > fixes and other efficiencies. Yes, it's best (or in some cases required) to use the newest pg_dumpall. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
