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: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?607087CF-3925-4A03-8435-9634EB4A4279>