To (apostrophes may not survive copy/paste, may want to hand enter) listen_addresses = '*' If you need to connect from other servers, make sure to change: #listen_addresses = 'localhost' You can make your changes to the 11 configuration with: nano /var/lib/pgsql/11/data/nf 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 kommentar(er)
