Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > linux.debian.user > #211070

Re: Upgrading to Buster but keeping Postgresql-9.6

Show all headers | View raw

[Multipart message — attachments visible in raw view] - view raw

Phil Endecott [2019-07-08T22:24:17+01] wrote:

> Indeed, not upgrading to Buster is a possibility. Also upgrading
> PostgreSQL to version 11 is a possibility. I think I understand the
> issues with each of those options, but I don't have a good
> understanding of the issues with trying to keep pg-9.6 on Buster.

Your PostgreSQL use seems to be far more advanced than mine so don't
take this as recommendation. I will just describe what I remember from
upgrades. I think I have upgraded Debian PostgreSQL three times now and
last time just a couple of days ago from 9.6 (Debian 9) to 11 (Debian
10).

  - Debian meta package "postgresql" depends on the supported version of
    database server. Debian distribution upgrade from Debian 9 to 10
    upgrades the meta package and it brings new version of PostgreSQL.

  - On upgrade (install of postgresql-11) the old version
    (postgresql-9.6) is kept but the server is shut down and it won't be
    started automatically anymore on system boot. All databases remain.
    I _think_ that the old version still works.

  - After upgrade the new version is started automatically but does not
    contain the database cluster(s) of the old version. Clusters must be
    upgraded manually with commands:

        systemctl stop postgresql       # stop v11
        pg_dropcluster 11 main          # remove v11's default "main" cluster
        pg_upgradecluster 9.6 main      # convert "main" from v9.6 to v11
        systemctl start postgresql      # start v11

  - If PostgreSQL server software is removed (apt remove postgresql-9.6)
    the actual database cluster data still remains under
    /var/lib/postgresql directory. If the server software is purged (apt
    purge postgresql-9.6) then the data is also removed.

-- 
///  OpenPGP key: 4E1055DC84E9DFF613D78557719D69D324539450
//  https://keys.openpgp.org/search?q=tlikonen@iki.fi
/  https://keybase.io/tlikonen  https://github.com/tlikonen

Back to linux.debian.user | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

Upgrading to Buster but keeping Postgresql-9.6 "Phil Endecott" <phil_llxjo_endecott@chezphil.org> - 2019-07-08 21:50 +0200
  Re: Upgrading to Buster but keeping Postgresql-9.6 Jochen Spieker <ml@well-adjusted.de> - 2019-07-08 22:00 +0200
  Re: Upgrading to Buster but keeping Postgresql-9.6 Andrei POPESCU <andreimpopescu@gmail.com> - 2019-07-08 23:10 +0200
    Re: Upgrading to Buster but keeping Postgresql-9.6 "Phil Endecott" <phil_llxjo_endecott@chezphil.org> - 2019-07-08 23:50 +0200
      Re: Upgrading to Buster but keeping Postgresql-9.6 Richard Hector <richard@walnut.gen.nz> - 2019-07-09 02:20 +0200
        Re: Upgrading to Buster but keeping Postgresql-9.6 "Phil Endecott" <phil_llxjo_endecott@chezphil.org> - 2019-07-10 17:50 +0200
          Re: Upgrading to Buster but keeping Postgresql-9.6 Clemens Eisserer <linuxhippy@gmail.com> - 2019-07-11 20:00 +0200
      Re: Upgrading to Buster but keeping Postgresql-9.6 Andrei POPESCU <andreimpopescu@gmail.com> - 2019-07-09 10:10 +0200
      Re: Upgrading to Buster but keeping Postgresql-9.6 Teemu Likonen <tlikonen@iki.fi> - 2019-07-09 10:30 +0200

csiph-web