/pg_upgrade.md

Created October 19, 2017 13:03

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/anonymous/05e4aa901ed6096bdc0ffe0d43cbf4e8.js"></script>
Save anonymous/05e4aa901ed6096bdc0ffe0d43cbf4e8 to your computer and use it in GitHub Desktop.

Download ZIP

Upgrade to PostgreSQL 10 on Ubuntu

Raw

pg_upgrade.md

Install packages

sudo apt install postgresql-10 postgresql-plpython-10 postgresql-plperl-10 libpq-dev

Install PL/R

If you have PL/R functions in your existing database, then this is necessary:

git clone https://github.com/postgres-plr/plr
cd plr
USE_PGXS=1 make
sudo USE_PGXS=1 make install

Shut down servers

sudo pg_ctlcluster 10 main stop
sudo pg_ctlcluster 9.6 main stop

Run `pg_upgrade`

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment