From owner-freebsd-questions@freebsd.org Mon Mar 12 10:31:55 2018 Return-Path: Delivered-To: freebsd-questions@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id D9F64F33EA4 for ; Mon, 12 Mar 2018 10:31:55 +0000 (UTC) (envelope-from peter@boosten.org) Received: from smtpq1.mnd.mail.iss.as9143.net (smtpq1.mnd.mail.iss.as9143.net [212.54.34.164]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id 713F573EB5 for ; Mon, 12 Mar 2018 10:31:55 +0000 (UTC) (envelope-from peter@boosten.org) Received: from [212.54.34.119] (helo=smtp11.mnd.mail.iss.as9143.net) by smtpq1.mnd.mail.iss.as9143.net with esmtp (Exim 4.86_2) (envelope-from ) id 1evKk8-00045x-5n; Mon, 12 Mar 2018 11:31:48 +0100 Received: from 5419f71f.cm-5-2d.dynamic.ziggo.nl ([84.25.247.31] helo=ra.boosten.org) by smtp11.mnd.mail.iss.as9143.net with esmtp (Exim 4.86_2) (envelope-from ) id 1evKk8-0006N3-4U; Mon, 12 Mar 2018 11:31:48 +0100 Received: from [172.17.11.184] (unknown [217.150.190.18]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by ra.boosten.org (Postfix) with ESMTPSA id D25CC3432F3F; Mon, 12 Mar 2018 11:31:47 +0100 (CET) Content-Type: text/plain; charset=utf-8 Mime-Version: 1.0 (1.0) Subject: Re: Upgrading PostgreSQL postgresql92 -> postgresql93 From: Peter Boosten X-Mailer: iPhone Mail (15D100) In-Reply-To: <20180312042652.GA98390@admin.sibptus.transneft.ru> Date: Mon, 12 Mar 2018 11:31:45 +0100 Cc: freebsd-questions@freebsd.org Content-Transfer-Encoding: quoted-printable Message-Id: <607087CF-3925-4A03-8435-9634EB4A4279@boosten.org> References: <20180312042652.GA98390@admin.sibptus.transneft.ru> To: Victor Sudakov X-SourceIP: 84.25.247.31 X-Ziggo-spambar: / X-Ziggo-spamscore: 0.0 X-Ziggo-spamreport: CMAE Analysis: v=2.3 cv=UKXz4hXy c=1 sm=1 tr=0 a=JWBJsaPp29SgP5DpYRBqZw==:17 a=IkcTkHD0fZMA:10 a=v2DPQv5-lfwA:10 a=BDJrjQDDUOCbYk0jNA4A:9 a=QEXdDO2ut3YA:10 none X-Ziggo-Spam-Status: No X-Spam-Status: No X-Spam-Flag: No X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.25 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 12 Mar 2018 10:31:56 -0000 > On 12 Mar 2018, at 05:26, Victor Sudakov 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=