Migration postgresql 9p4 to 9p6 impossible

vincentux · July 23, 2018, 7:33am

J’ai trouvé ce tuto pour migrer en version 9.6 (mais j’ai peur de tout cassé)
je me lance ?

gist.github.com

https://gist.github.com/dmitrykustov/27c673ec4f7abd716912e4c830910019

upgrade-postgres-9.4-to-9.6.md

To use the most modern version of Postgres software we need to add postgresql repository. Edit `/etc/apt/sources.list` or create `/etc/apt/sources.list.d/pgdg.list` and add there a line: `deb http://apt.postgresql.org/pub/repos/apt/ jessie-pgdg main`
Then import the repository signing key, and update the package lists:
```bash
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
sudo apt-get update
```
Install a new version of PostgreSQL server.

Once the Debian upgrade finished, I used `dpkg-query -l postgresql*` to check which versions of postgres I have installed.

This file has been truncated. show original

[EDIT] encore trouvé plus simple :