Обсуждение: [ADMIN] Migrating from CentOS repo to PostgreSQL repo
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.
I tested this out on my sandbox and things look like they're fine. Before starting up the new binaries, double-check the PGDATA environment variable (unless you manually specify -D every time).
Also I did receive this warning when uninstalling the old binaries:
warning: file /var/lib/pgsql/data: remove failed: No such file or directory
warning: file /var/lib/pgsql/backups: remove failed: No such file or directory
This is because we don't use those default locations and they didn't exist. That did make me concerned that removing those packages *would* try to remove existing database files, so tested with a default install into that PGDATA dir and then removed the packages. It looks like it left the datafiles alone, so my assumption is that it would only remove the "data" directory if it was empty. The backups directory was empty and was removed.
Don.
On Fri, Aug 11, 2017 at 3:06 PM, Don Seiler <don@seiler.us> wrote:
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.
Don Seiler
www.seiler.us
www.seiler.us