Howdy again listers.
In my stumbling around my new PostgreSQL surroundings, I found some inconsistency in a few of our 9.2 DB servers (all CentOS) in that some have installed postgresql-server from the CentOS7 base repository, where as others have installed postgresql92-server from the PostgreSQL repo. I've seen this with one of our 9.5 groups as well but I'm assuming the process will largely be the same.
I'd like to standardize all of these to use the postgresql.org repositories across the board. I'm wondering what the work involved is in doing so and not losing my database. Easy enough to test in a CentOS7 VM but just wanted to know if there were any known issues or tips to look for.
My initial guess at an action plan would be to:
- stop postgres
- Probably backup the config files
- Uninstall postgresql-server and other postgresql packages
- Pray that it didn't delete any data or config files?
- Configure the pgdg-centos92 repo in yum for that version of CentOS
- Install postgresql92-server from this repo
- Verify things start up.
- Look over any scripts that might have hard-coded binaries paths that have changed.
As always, looking forward to learning more and seeing what you all think.
