Fedora 36 will upgrade your PostgreSQL database from 13.4~ to 14.1-3.
Since this is a major upgrade it will require that you upgrade your database.
Here is how to do it:
- Install the upgrade utilities: dnf install postgresql-upgrade
- Become user postgres: sudo su - postgres
- Rename the data directory: mv /var/lib/pgsql/data/ /var/lib/pgsql/data_13.4/
- As root, initialize your 14.1 database: sudo postgresql-setup --initdb --unit postgresql
- As user postgres, Copy your pg_hba.conf: cp /var/lib/pgsql/data_13.4/pg_hba.conf /var/lib/pgsql/data/pg_hba.conf
- To avoid any potential password issues, temporarily change "md5" to "trust" in both pg_hba.conf files
- Run the upgrade process: pg_upgrade -b /usr/lib64/pgsql/postgresql-13/bin/ -B /usr/bin/ -d data_13.4/ -D data
- Change "trust" to md5" if you changed in step 6
- Enable your postgresql.service: sudo systemctl enable postgresql.service
- Start your postgresql.service: sudo systemctl start postgresql.service
- Run the analyse_new_cluster.sh script as suggested
- Run the delete_old_cluster.sh script as suggested