![]() You can view your 10 configuration with: nano /var/lib/pgsql/10/data/nf ![]() ![]() I’d recommend making the changes to the new version rather than copying over nf from 10. usr/pgsql-11/bin/initdb -D /var/lib/pgsql/11/data/ Migrate your database from the 10.x version to 11.x /usr/pgsql-11/bin/pg_upgrade -old-datadir /var/lib/pgsql/10/data/ -new-datadir /var/lib/pgsql/11/data/ -old-bindir /usr/pgsql-10/bin/ -new-bindir /usr/pgsql-11/bin/ Edit configuration files If you’re using extensions like pg_crypto, you will also need the postgresql11-contrib package sudo yum install postgresql11-contrib Stop Postgresql 10 and Postgresql 11 sudo systemctl stop rvice & sudo systemctl stop rvice Initialize the PostgreSQL 11 database sudo su postgres Since my previous article Upgrading to PostgreSQL 10 on Centos 7 was so popular, I though I’d do a follow-up for anyone looking to upgrade a very simply configured PostgreSQL 10 server to PostgreSQL 11 on Centos 7.įirst, and this goes without saying, backup your server! Install the repo RPM for PosgresSQL 10 sudo yum install Install PosgreSQL 11 sudo yum install postgresql11-server Extensions
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |