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?
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.
Thanks for your advice.
Randy