[arch-general] How to upgrade a postgresql database?
ismael.bouya at normalesup.org
Fri Aug 17 14:14:52 UTC 2018
(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
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 228 bytes
Desc: not available
More information about the arch-general