■

Upgrade conda-forge postgresql from 14 to 15

Assume having old postgresql (v14) db directory exists at

/home/username/aiida-proj/psql

Upgrade postgresql (14 -> 15) of the current conda env (myproj)

Create a new conda env (psql) with old postgresql (14).

initdb -D /home/username/myproj/psql15
cp /home/username/myproj/psql/pg_hba.conf /home/username/myproj/psql15/
cp /home/username/myproj/psql/postgresql.conf /home/username/myproj/psql15/
pg_upgrade --old-datadir=/home/username/myproj/psql --new-datadir=/home/username/myproj/psql15 --old-bindir=/home/username/.miniforge/envs/psql/bin --new-bindir=/home/username/.miniforge/envs/myproj/bin --old-options '-c config_file=/home/username/myproj/psql/postgresql.conf' --new-options '-c config_file=/home/username/myproj/psql15/postgresql.conf' --check

If all OK, remove --check and rerun the above again.

mv /home/username/myproj/psql /home/username/myproj/psql14
ln -s /home/username/myproj/psql15 /home/username/myproj/psql