From owner-freebsd-questions@freebsd.org  Mon Mar 12 04:27:02 2018
Return-Path: <owner-freebsd-questions@freebsd.org>
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 E6D27F47C80
 for <freebsd-questions@mailman.ysv.freebsd.org>;
 Mon, 12 Mar 2018 04:27:01 +0000 (UTC)
 (envelope-from vas@mpeks.tomsk.su)
Received: from relay2.tomsk.ru (mail.sibptus.tomsk.ru [212.73.124.5])
 by mx1.freebsd.org (Postfix) with ESMTP id 2F77C8E864
 for <freebsd-questions@freebsd.org>; Mon, 12 Mar 2018 04:26:59 +0000 (UTC)
 (envelope-from vas@mpeks.tomsk.su)
X-Virus-Scanned: by clamd daemon 0.98.5_1 for FreeBSD at relay2.tomsk.ru
Received: from [212.73.125.240] (HELO admin.sibptus.transneft.ru)
 by relay2.tomsk.ru (CommuniGate Pro SMTP 5.1.16)
 with ESMTPS id 39952649 for freebsd-questions@freebsd.org;
 Mon, 12 Mar 2018 10:22:05 +0600
Received: from admin.sibptus.transneft.ru (sudakov@localhost [127.0.0.1])
 by admin.sibptus.transneft.ru (8.15.2/8.15.2) with ESMTP id w2C4QtYQ099386
 for <freebsd-questions@freebsd.org>; Mon, 12 Mar 2018 11:26:57 +0700 (+07)
 (envelope-from vas@mpeks.tomsk.su)
Received: (from sudakov@localhost)
 by admin.sibptus.transneft.ru (8.15.2/8.15.2/Submit) id w2C4QqsK099385
 for freebsd-questions@freebsd.org; Mon, 12 Mar 2018 11:26:52 +0700 (+07)
 (envelope-from vas@mpeks.tomsk.su)
X-Authentication-Warning: admin.sibptus.transneft.ru: sudakov set sender to
 vas@mpeks.tomsk.su using -f
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>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Organization: AO "Svyaztransneft", SibPTUS
X-PGP-Key: http://www.dreamwidth.org/pubkey?user=victor_sudakov
X-PGP-Fingerprint: 10E3 1171 1273 E007 C2E9  3532 0DA4 F259 9B5E C634
User-Agent: Mutt/1.9.3 (2018-01-21)
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.25
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <https://lists.freebsd.org/mailman/options/freebsd-questions>, 
 <mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions/>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <https://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
 <mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Mon, 12 Mar 2018 04:27:02 -0000

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