Hi All,
Newbie here with a request for info and caveats for upgrading a 9.22 version of postgres to 12.
I am primarily a Windows admin so don't currently have the bandwidth to move this to a Linux environment. I know it would be better, but that will be a future step.
I recently moved everything from a 2012 R2 server to 2019 but did not upgrade Postgres. It appears the move of the DB left out some queries or 'views'.
Am not sure if 9.2.2 is stable on server 2019. I probably just need to go through another backup and restore.
However, an upgrade seems to be in order as well.
Question: Do I upgrade Postgres on the 2012 server and then move the DB, or can I upgrade Postgres on the new server directly. Maybe it does not matter, but your experience in answering this question is appreciated.
Thanks,
Rob