![]() Start the server systemctl start rviceĪnalyze and optimize the new cluster. ![]() View the old configuration nano /var/lib/pgsql/9.5/data/pg_hba.confĮdit the new configuration nano /var/lib/pgsql/10/data/pg_hba.conf 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 10 configuration with: nano /var/lib/pgsql/10/data/nf You can view your 9.5 configuration with: nano /var/lib/pgsql/9.5/data/nf I’d recommend making the changes to the new version rather than copying over nf from 9.5, since there are a bunch of new options in the PostreSQL 10 version of the file. Migrate your database from the 9.x version to 10 /usr/pgsql-10/bin/pg_upgrade -old-datadir /var/lib/pgsql/9.5/data/ -new-datadir /var/lib/pgsql/10/data/ -old-bindir /usr/pgsql-9.5/bin/ -new-bindir /usr/pgsql-10/bin/ usr/pgsql-10/bin/initdb -D /var/lib/pgsql/10/data/ Initialize the PostgreSQL 10 database sudo su postgres Stop Postgresql 9.5 and Postgresql 10 sudo systemctl stop postgresql-9.5.service & sudo systemctl stop rvice Install PosgreSQL 10 sudo yum install postgresql10-server Install the repo RPM for PosgresSQL 10 sudo yum install If you’re upgrading from a different version, just replace 9.5 and 95 wherever you see it with your appropriate version number. In these examples, I’m using upgrading from PostgreSQL 9.5. Here’s a quick rundown on upgrading a very simply configured PostgreSQL 9.x server to PostgreSQL 10 running on Centos 7.įirst, and this goes without saying, backup your server! ( An updated version of this post for upgrading to PostgreSQL 11 is available here)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |