Re: How to upgrade a postgresql database?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



(Fri, Aug 17, 2018 at 04:11:45PM +0200) Peter Nabbefeld :
> Am 17.08.18 um 16:05 schrieb Ismael Bouya:
> > Hi Peter,
> > What version are you upgrading from? Starting at version 10, you don’t
> > need any particular operation to upgrade minor version (10.X -> 10.Y),
> > that’s why the old binaries are "stuck" at 9.6.
> Current version is 9.6, updated version is 10.5

Then you probably missed that part in the wiki page:
---
a postgresql-old-upgrade package is available that will always run one
major version behind the real PostgreSQL package. This can be installed
side-by-side with the new version of PostgreSQL.
---

Upgrading your system (after shutting down postgresql) and installing
postgresql-old-upgrade should give you /opt/pgsql-9.6/, your current
psql version, and /usr/bin/psql, your target version (10.6). From there,
following the wiki should permit you to upgrade the data to the target
version.
-- 
Ismael

Attachment: signature.asc
Description: PGP signature


[Index of Archives]     [Linux Wireless]     [Linux Kernel]     [ATH6KL]     [Linux Bluetooth]     [Linux Netdev]     [Kernel Newbies]     [Share Photos]     [IDE]     [Security]     [Git]     [Netfilter]     [Bugtraq]     [Yosemite News]     [MIPS Linux]     [ARM Linux]     [Linux Security]     [Linux RAID]     [Linux ATA RAID]     [Samba]     [Device Mapper]

  Powered by Linux