Hello,
I am preparing to do a major upgrade of a production postgres environment.
Currently there is the live production db server, a WAL shipping warm standby server, and a reporting server that is synced using perl/SQL scripts and rebuilt weekly.
I will also be changing operating systems from RHEL (release 4) to Ubuntu 10.10.
The main aim of doing the upgrade is to take advantage of streaming replication for the reporting env. So here are my questions:
1. In upgrading the warm standby server, should I be attempting to pg_upgrade the current warm standby, or just build this box from scratch and set it up and allow it to sync up?
2. Is there any known issues with the OS or versions that I have chosen? I had trouble with Ubuntu and pg_upgrade with 9.0.4, but this newer release seems to have a lot more bug fixes and I believe Ubuntu supports it.
3. Should I bother upgrading the reporting server, or just build a new one and start replication?
Thanks in advance!
I am preparing to do a major upgrade of a production postgres environment.
Currently there is the live production db server, a WAL shipping warm standby server, and a reporting server that is synced using perl/SQL scripts and rebuilt weekly.
I will also be changing operating systems from RHEL (release 4) to Ubuntu 10.10.
The main aim of doing the upgrade is to take advantage of streaming replication for the reporting env. So here are my questions:
1. In upgrading the warm standby server, should I be attempting to pg_upgrade the current warm standby, or just build this box from scratch and set it up and allow it to sync up?
2. Is there any known issues with the OS or versions that I have chosen? I had trouble with Ubuntu and pg_upgrade with 9.0.4, but this newer release seems to have a lot more bug fixes and I believe Ubuntu supports it.
3. Should I bother upgrading the reporting server, or just build a new one and start replication?
Thanks in advance!