I thought it might be a good idea to submit this procedure... it is
required with
every major PostgreSQL upgrade. Probably should also be in the release
notes, but
the cookbook would be good also.
Here is the link:
https://goo.gl/T9H7mM
Here are the contents:
<!-- Do not edit above this line -->
<!--
Please provide some information so we can give you credit:
name: Gerald Cox
fas_id: gbcox
email: gbcox(a)bzb.us
-->
PostgreSQL Upgrade - Fedora 22
==============================
Fedora 22 will upgrade your PostgreSQL database from 9.3.6 to 9.4.1
Since this is a major upgrade it will require that you upgrade your database.
Required Ingredients
--------------------------
* postgresql-upgrade
Directions
---------------
### Upgrade PostgreSQL database from 9.3.6 to 9.4.1
1. Install the upgrade utilities:
dnf install postgresql-upgrade
2. Become user postgres:
sudo su - postgres
3. Rename the data directory:
mv /var/lib/pgsql/data/ /var/lib/pgsql/data_9.3/
4. As root, initialize your 9.4 database:
sudo postgresql-setup initdb
5. As user postgres, Copy your pg_hba.conf:
cp /var/lib/pgsql/data_9.3/pg_hba.conf
/var/lib/pgsql/data/pg_hba.conf
6. To avoid any potential password issues, temporarily change "md5" to
"trust" in both pg_hba.conf files
vim /var/lib/pgsql/data_9.3/pg_hba.conf
vim /var/lib/pgsql/data/pg_hba.conf
7. Run the upgrade process:
pg_upgrade -b /usr/lib64/pgsql/postgresql-9.3/bin/ -B /usr/bin/ -d
data_9.3/ -D data
8. Change "trust" to md5" if you changed in step 6
vim /var/lib/pgsql/data/pg_hba.conf
9. Enable your postgresql.service:
sudo systemctl enable postgresql.service
10. Start your postgresql.service:
sudo systemctl start postgresql.service
11. Run the analyse_new_cluster.sh script as suggested
./analyse_new_cluster.sh
12. Run the delete_old_cluster.sh script as suggested
./delete_old_cluster.sh
References:
* [Upstream
Documentation](http://www.postgresql.org/docs/9.0/static/migration.html)
"Migration Between Releases"
* [The Shiny Object](https://tso.bzb.us/2015/05/postgresql-upgrade-fedora-22.html)
"PostgreSQL Upgrade Fedora 22"