From nobody Sat Sep 09 06:12:39 2023 X-Original-To: dev-commits-ports-all@mlmmj.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mlmmj.nyi.freebsd.org (Postfix) with ESMTP id 4RjN1m4fKPz4sGMX; Sat, 9 Sep 2023 06:12:44 +0000 (UTC) (envelope-from mfechner@freebsd.org) Received: from smtp.freebsd.org (smtp.freebsd.org [96.47.72.83]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (4096 bits) client-digest SHA256) (Client CN "smtp.freebsd.org", Issuer "R3" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4RjN1m38cbz4cWJ; Sat, 9 Sep 2023 06:12:44 +0000 (UTC) (envelope-from mfechner@freebsd.org) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1694239964; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=HNnxKslebSX1O+5yyH3VxcK7lG3+9FL29/j6A78I6hY=; b=Ao0u4RMJryXjbKi3hJ2V+gqxZkBqvVTbYwfH+mFfoLjHrvHfuy71mnBZPXv6sXtBtSakJ4 184EpubLaFXqeCVWqP2Hzglx+pn3IzLT+8HA7neFYi3XhrlzLVZKHr/HSCZLAjteBU6xxN aMIQgDYjDvT/VeLxrYcBEV5GOZJPUd4vyWiuyXEeDb0bZEwC8x5vl5jKGITPC02T1pPsr7 rDsZmbO2PHpCS7RTz0QioJUBaJzXewCLHsfSkLgJpBqrlyvmWo2lHqGZFerYdUEUMz1GNy zq3g/uJzf08bu3v5XHq83Ulgx/w0B49BsK9pA4/7aFquFsS7yid+AFnWWn7UYQ== ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1694239964; a=rsa-sha256; cv=none; b=TAe65dpkSFJgXLosA+SAoP29NdH2mDIGsW+2i90HVgVOGrSf432sGubyPPBSiwfYT/6aR+ q6JGATp2jlOdqgO6Zmy7guX9ns8qhthBnXmXTsNnxLoBb6y2hrCZlSFTD/XsKpkOKh/RSq siTv0Seos70B2athcqj66Wz2pIKHTK1tbGYKagNMpgWMz1rpj1cVgER1hkRvoi8rwGzwlx QCxWltzd7R+7CrvcIia6WxAvU0dP62Gs68Y/rhNYzfZX+jQmL/I+xsaWqWga4h5834n6wY KeCOO4Sr6EpNt+i67JKxA4MbFNkEPloJ40K/IyvOQr4F2//Xf+15Kc5nzP6MXg== ARC-Authentication-Results: i=1; mx1.freebsd.org; none ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1694239964; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=HNnxKslebSX1O+5yyH3VxcK7lG3+9FL29/j6A78I6hY=; b=rLXctHOXaNO04bl42wEJEPbo2k3Io+Gf1tFRk93iQ6sVHbaYGJABnedBi/CEPDG4Tq4eJx z0kbl659kOFi+De0MjC0Rxiyhivq6Xr0J87b2A2ulEYbfeI5Xn5RLxeyfkyke020Rxht3C ry3WGCfTdWjVvxZX8XhKwJWQwkXNO+gh9j/uYO8RTGeKPYySTTuYfwTwLvHwFy6m7067E8 w/Nt/ZhcHIehGqgDt4/33XXlFPOZDtv/m3ormfYbDU02NtLoGk864uOXTtVfjRbYGL/1BR nGe/R6WLsFIMgrErEobxQ9d0o1HG69QoTDEzP/S4AMB2rVxEd86dRdiBp3tJ1Q== Received: from [192.168.0.151] (unknown [212.108.136.146]) (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256) (Client did not present a certificate) (Authenticated sender: mfechner) by smtp.freebsd.org (Postfix) with ESMTPSA id 4RjN1l23LMzy91; Sat, 9 Sep 2023 06:12:43 +0000 (UTC) (envelope-from mfechner@freebsd.org) Message-ID: <4e633eee-1573-3a7b-eeb5-57aed892fe09@freebsd.org> Date: Sat, 9 Sep 2023 09:12:39 +0300 List-Id: Commit messages for all branches of the ports repository List-Archive: https://lists.freebsd.org/archives/dev-commits-ports-all List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-dev-commits-ports-all@freebsd.org X-BeenThere: dev-commits-ports-all@freebsd.org MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:102.0) Gecko/20100101 Thunderbird/102.15.0 Subject: Re: git: 0c0bf56482b3 - main - Mk/bsd.default-versions.mk: Update to PostgreSQL 15 Content-Language: en-US To: Kevin Bowling , ports-committers@FreeBSD.org, dev-commits-ports-all@FreeBSD.org, dev-commits-ports-main@FreeBSD.org References: <202309081822.388IMQsO057995@gitrepo.freebsd.org> From: Matthias Fechner In-Reply-To: <202309081822.388IMQsO057995@gitrepo.freebsd.org> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit Dear Kevin, Am 08.09.2023 um 21:22 schrieb Kevin Bowling: > + # service postgresql stop > + # pkg create postgresql13-server postgresql13-contrib > + # mkdir /tmp/pg-upgrade > + # tar xf postgresql13-server-13.12.pkg -C /tmp/pg-upgrade > + # tar xf postgresql13-contrib-13.12.pkg -C /tmp/pg-upgrade > + # pkg delete -f databases/postgresql13-server databases/postgresql13-contrib databases/postgresql13-client > + > + Now update PostgreSQL: > + > + pkg user: > + # pkg install databases/postgresql15-server databases/postgresql15-contrib > + # pkg upgrade > + > + Portmaster users: > + # portmaster databases/postgresql15-server databases/postgresql15-contrib > + # portmaster -a > + > + Portupgrade users: > + # portinstall databases/postgresql15-server databases/postgresql15-contrib > + # portupgrade -a > + > + After installing the new PostgreSQL version you need to convert > + all your databases to new version: > + > + # su -l postgres -c "/usr/local/bin/initdb --encoding=utf-8 --lc-collate=C -D /var/db/postgres/data15 -U postgres" > + # su -l postgres -c "pg_upgrade -b/tmp/pg-upgrade/usr/local/bin/ -d/var/db/postgres/data13/ -B /usr/local/bin/ -D /var/db/postgres/data15/ -U postgres " > + > + Now the migration is finished. You can start PostgreSQL again with: > + > + # service postgresql start thanks a lot for your work and this really nice instructions. Should we maybe add this line to the postgres upgrade documentation? /usr/local/bin/vacuumdb -U postgres --all --analyze-in-stages Gruß Matthias -- "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the universe trying to produce bigger and better idiots. So far, the universe is winning." -- Rich Cook