From nobody Thu Jul 10 19:19:56 2025 X-Original-To: freebsd-questions@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 4bdPn12rjsz61RnX for ; Thu, 10 Jul 2025 19:20:05 +0000 (UTC) (envelope-from list_freebsd@bluerosetech.com) Received: from echo.brtsvcs.net (echo.brtsvcs.net [IPv6:2607:f740:c::4ae]) (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 did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id 4bdPn074QTz447y for ; Thu, 10 Jul 2025 19:20:04 +0000 (UTC) (envelope-from list_freebsd@bluerosetech.com) Authentication-Results: mx1.freebsd.org; none Received: from chombo.houseloki.net (chombo [65.100.43.2]) by echo.brtsvcs.net (Postfix) with ESMTPS id 7C8E9167D0F; Thu, 10 Jul 2025 19:19:57 +0000 (UTC) Received: from [10.26.25.100] (ivy.pas.ds.pilgrimaccounting.com [10.26.25.100]) by chombo.houseloki.net (Postfix) with ESMTPSA id 07F7E6BD9; Thu, 10 Jul 2025 12:19:57 -0700 (PDT) Message-ID: <57e50146-4bb8-fa49-2fd8-3ea610b0eac7@bluerosetech.com> Date: Thu, 10 Jul 2025 12:19:56 -0700 List-Id: User questions List-Archive: https://lists.freebsd.org/archives/freebsd-questions List-Help: List-Post: List-Subscribe: List-Unsubscribe: X-BeenThere: freebsd-questions@freebsd.org Sender: owner-freebsd-questions@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.1 Subject: Re: Postgres upgrade from 12 to 13 - anyway to fetch EOL package? Content-Language: en-US To: Kaya Saman , freebsd-questions@freebsd.org References: <2fa10246-a2a9-4b67-94ce-d80f11a4509a@optiplex-networks.com> From: list_freebsd@bluerosetech.com In-Reply-To: <2fa10246-a2a9-4b67-94ce-d80f11a4509a@optiplex-networks.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-Rspamd-Queue-Id: 4bdPn074QTz447y X-Spamd-Bar: ---- X-Rspamd-Pre-Result: action=no action; module=replies; Message is reply to one we originated X-Spamd-Result: default: False [-4.00 / 15.00]; REPLY(-4.00)[]; ASN(0.00)[asn:36236, ipnet:2607:f740:c::/48, country:US] On 2025-07-10 1:55, Kaya Saman wrote: > I've recently updated my servers to 13.5 and now I'm updating all the @ports > > > I have a jail with postgres installed but forgot to check > /usr/ports/UPDATING for the upgrade procedure. > > > Does anyone know if there's a location with obsolete packages so I can > grab the pg12 package? > > > According to UPDATING I need both of these: > > >   # pkg create postgresql12-server postgresql12-contrib >   # tar xf postgresql12-server-12.8.pkg -C /tmp/pg-upgrade >   # tar xf postgresql12-contrib-12.8.pkg -C /tmp/pg-upgrade > > > Or is there another solution to get my databases upgraded? Check to see if you have the old pkgs in /var/cache/pkg If not, you can look up when databases/postgresql12-* was deleted from the tree, check out ports at the commit just before that, make stage package, unpack as needed.