[arch-general] How to upgrade a postgresql database?

Ismael Bouya 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...
Name: signature.asc
Type: application/pgp-signature
Size: 228 bytes
Desc: not available
URL: <https://lists.archlinux.org/pipermail/arch-general/attachments/20180817/0782d971/attachment.asc>

More information about the arch-general mailing list