Skip site navigation (1)Skip section navigation (2)
Date:      Mon, 12 Mar 2018 11:26:52 +0700
From:      Victor Sudakov <vas@mpeks.tomsk.su>
To:        freebsd-questions@freebsd.org
Subject:   Upgrading PostgreSQL postgresql92 -> postgresql93
Message-ID:  <20180312042652.GA98390@admin.sibptus.transneft.ru>

next in thread | raw e-mail | index | archive | help
Dear Colleagues,

Anyone using PostgreSQL, how do you upgrade it?

The pg_upgrade utility is not packaged in
postgresql93-server-9.3.22.txz or postgresql93-client-9.3.22.txz, and
even if it were, it requires the binaries from both the old version
and the new version to be present while the pkg system simply replaces
postgresql92-* with postgresql93-*

Anything less radical than "pg_dumpall | psql" i.e. some in-place
procedure?

Any ideas please?

-- 
Victor Sudakov,  VAS4-RIPE, VAS47-RIPN
AS43859



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20180312042652.GA98390>