Migrating the data for PostgreSQL major version upgrade

This site does not allow itself to be embedded. You can still read it on the original site — the toolbar below keeps your place in the directory.

PostgreSQL databases can be migrated without doing database dump-and-restore. Here are the steps to migrate from Postgres 9.6 to 12 in Ubuntu 18.04 Existing PostgreSQL 9.6 Let’s first check the list of installed postgres related packages, service status and the running cluster details. Packages list: $ dpkg -l | grep postgres pgdg-keyring 2018.2 all keyring for apt.postgresql.org…

Read on imagineer.in ↗