Skip site navigation (1)Skip section navigation (2)
Date:      Mon, 12 Mar 2018 11:31:45 +0100
From:      Peter Boosten <peter@boosten.org>
To:        Victor Sudakov <vas@mpeks.tomsk.su>
Cc:        freebsd-questions@freebsd.org
Subject:   Re: Upgrading PostgreSQL postgresql92 -> postgresql93
Message-ID:  <607087CF-3925-4A03-8435-9634EB4A4279@boosten.org>
In-Reply-To: <20180312042652.GA98390@admin.sibptus.transneft.ru>
References:  <20180312042652.GA98390@admin.sibptus.transneft.ru>

Next in thread | Previous in thread | Raw E-Mail | Index | Archive | Help


> On 12 Mar 2018, at 05:26, Victor Sudakov <vas@mpeks.tomsk.su> wrote:
>=20
> Dear Colleagues,
>=20
> Anyone using PostgreSQL, how do you upgrade it?
>=20
> 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-*
>=20
> Anything less radical than "pg_dumpall | psql" i.e. some in-place
> procedure?
>=20
>=20

Hi Victor,

I searched (and found) some procedure, which was basically this:

-Package the current postgresql and install that in /tmp
-rename the current data directory
-delete current packages and install new ones
-initdb new database
-use some command to =E2=80=98copy=E2=80=99 (not cp ;) ) to transport old da=
ta to new

I don=E2=80=99t have the url currently available, but it wasn=E2=80=99t that=
 hard to find either.=20

Peter=




Want to link to this message? Use this URL: <http://docs.FreeBSD.org/cgi/mid.cgi?607087CF-3925-4A03-8435-9634EB4A4279>