Upgrading from V11 to V12 on Debian install

From: stan <stanb(at)panix(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Upgrading from V11 to V12 on Debian install
Date: 2019-12-02 19:28:40
Message-ID: 20191202192840.GA22579@panix.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have several machines that have version 11 instances on them. These are
all Debian or Ubuntu machines. All of them are pointed to the Postgres
repositories fro the Postgres binaries

deb http://apt.postgresql.org/pub/repos/apt/ buster-pgdg main

dpkg -l shows:

ii postgresql-11 11.6-1.pgdg100+1
ii postgresql-12 12.1-1.pgdg100+1
ii postgresql-client-11 11.6-1.pgdg100+1
ii postgresql-client-12 12.1-1.pgdg100+1
ii postgresql-client-common 210.pgdg100+1
ii postgresql-common 210.pgdg100+1
ii postgresql-contrib 12+210.pgdg100+1
ii postgresql-server-dev-11 11.6-1.pgdg100+1

Googling around, I found this link:

https://scottlinux.com/2015/11/14/upgrade-postgresql-on-debian-jessie-with-pg_upgradecluster/

I plan on upgrading one of the test instances right away. Is the
information in this link the best way to do this in a Debian environment? I
did look at the pg_upgrade documentation, and it looks like I could really
make a mess if I misunderstand even one step.


"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
-- Benjamin Franklin

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2019-12-02 20:28:22 Re: Upgrading from V11 to V12 on Debian install
Previous Message stan 2019-12-02 17:10:32 Preformance on upcoming Linux kernel