From nobody Sat Sep 09 06:58:47 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 4RjP382vRqz4skgm for ; Sat, 9 Sep 2023 06:59:00 +0000 (UTC) (envelope-from kevin.bowling@kev009.com) Received: from mail-qt1-x82d.google.com (mail-qt1-x82d.google.com [IPv6:2607:f8b0:4864:20::82d]) (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-signature RSA-PSS (2048 bits) client-digest SHA256) (Client CN "smtp.gmail.com", Issuer "GTS CA 1D4" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4RjP380r1Yz3N5F for ; Sat, 9 Sep 2023 06:58:59 +0000 (UTC) (envelope-from kevin.bowling@kev009.com) Authentication-Results: mx1.freebsd.org; none Received: by mail-qt1-x82d.google.com with SMTP id d75a77b69052e-414b0bdea1cso18297521cf.1 for ; Fri, 08 Sep 2023 23:58:59 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=kev009.com; s=google; t=1694242739; x=1694847539; darn=freebsd.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=WIzNrzSmDpPwlYQPtsiHCJyKas9l1UanUYrhFA1Ej3E=; b=di8XiuQDO/mTCDu2n70eVmPyU5D/+O2UGhcgDA4YSffMjU+j9VCvCPbePwQEHW/mUU PqB3SnX505ObNbvmaySSV/KJugvtCGKnFS7s8HgPUjs7sKax2csyZYDmJbGcK2U0lEYr 0JePRJZP83jYEMA5qoTSmCcz0/OnZpNUUoDU0= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1694242739; x=1694847539; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=WIzNrzSmDpPwlYQPtsiHCJyKas9l1UanUYrhFA1Ej3E=; b=JhL0ci/5w1TNtWHBqrEEQmaijQbLwx2MTPZHdgDFxB6lapM4h7cbztnj+Qx9WihH0z X3gQjf3Je0DgH8RAsXK4JIHAoTwr7SLMovlSmv8XIbPWmM1SGQhcJTOxI6KgODGD/+0L a3VnYgD3X20wLRTk2RO4sel76TdhaKiQp/AC7X0W2iaDQywndSwumbu7r+V9UNXrbCZj E06y1slYUqThCwjQ3/LIbgG4sDyP70Zb3rnNVQ5wWz+VPO1XaLt25Sp0py9UvWTJ9Sb8 CFs1mU+jrJD2TvYmT6y7nEsh55aqpbCPnDYOBHc6V3TrV/CAX6bPzGQg5Ix36sUqCjmP NO/A== X-Gm-Message-State: AOJu0YzxrOG9H/2QuNBF9TLNHYWamEmuQWsChiGYDrCIepdcH4XXbwj+ BXKcUaqkm7c1rjItyAIvxFnDJ2HtI72J3+HONZcqRg== X-Google-Smtp-Source: AGHT+IHVfaKzDfaBB69uzSZM2YWHVIBrUaLm64u5oaOYip6uNNAvquRHvNpOv8kRaQ3LLYayuDAFAi/doqomsqEGKR8= X-Received: by 2002:a05:622a:164d:b0:410:87a:be98 with SMTP id y13-20020a05622a164d00b00410087abe98mr5041064qtj.20.1694242739160; Fri, 08 Sep 2023 23:58:59 -0700 (PDT) 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 References: <202309081822.388IMQsO057995@gitrepo.freebsd.org> <4e633eee-1573-3a7b-eeb5-57aed892fe09@freebsd.org> In-Reply-To: <4e633eee-1573-3a7b-eeb5-57aed892fe09@freebsd.org> From: Kevin Bowling Date: Fri, 8 Sep 2023 23:58:47 -0700 Message-ID: Subject: Re: git: 0c0bf56482b3 - main - Mk/bsd.default-versions.mk: Update to PostgreSQL 15 To: Matthias Fechner Cc: Kevin Bowling , ports-committers@freebsd.org, dev-commits-ports-all@freebsd.org, dev-commits-ports-main@freebsd.org Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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:15169, ipnet:2607:f8b0::/32, country:US] X-Rspamd-Queue-Id: 4RjP380r1Yz3N5F On Fri, Sep 8, 2023 at 11:12=E2=80=AFPM Matthias Fechner wrote: > > 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=3Dutf-8 --lc-c= ollate=3DC -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 Sure feel free to add it > Gru=C3=9F > 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 >