TL;DR
Install Postgres 9.6, and then:
sudo pg_dropcluster 9.6 main --stop
sudo pg_upgradecluster 9.5 main
sudo pg_dropcluster 9.5 main
Johann du Toit johanndt
johanndt
/ gist:d32f5ccd248b415c203c1fcc131f23cc
Last active
May 22, 2023 05:55
run pg_repack on existing running postgresql 9.6
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| apt-get update | |
| apt-get install postgresql-server-dev-11 unzip | |
| cd /tmp | |
| wget http://api.pgxn.org/dist/pg_repack/1.4.4/pg_repack-1.4.4.zip | |
| unzip pg_repack-1.4.4.zip | |
| cd pg_repack-1.4.4 | |
| make | |
| make install | |
| su - postgres |
johanndt
/ upgrade-postgres-9.5-to-9.6.md
Last active
April 18, 2021 20:07
— forked from Prototype-X/upgrade-postgres-9.5-to-9.6.md
Upgrading PostgreSQL from 9.5 to 9.6 on Ubuntu 16.04
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| from PIL import ImageFont | |
| import toyplot | |
| series_names = ["Series 1", "Series 2", "Series 3"] | |
| canvas = toyplot.Canvas(width=300, height=300) | |
| font = ImageFont.load_default() | |
| next_x = 0 | |
| for legend in series_names: | |
| canvas.legend([ |
johanndt
/ alignment5.ipynb
Created
February 18, 2016 06:01
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
johanndt
/ alignment7.ipynb
Created
February 18, 2016 06:01
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
johanndt
/ alignment6.ipynb
Created
February 18, 2016 06:00
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
johanndt
/ upgrade-postgres-9.3-to-9.5.md
Last active
July 27, 2024 16:49
— forked from dideler/upgrade-postgres-9.3-to-9.4.md
Upgrading PostgreSQL from 9.3 to 9.5 on Ubuntu
TL;DR
Install Postgres 9.5, and then:
sudo pg_dropcluster 9.5 main --stop
sudo pg_upgradecluster 9.3 main
sudo pg_dropcluster 9.3 main
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.