Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rnF2v-00CIEf-RS for pgsql-general@arkaria.postgresql.org; Thu, 21 Mar 2024 09:49:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rnF2u-00BnYV-Gp for pgsql-general@arkaria.postgresql.org; Thu, 21 Mar 2024 09:49:13 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rnF2u-00BnYN-4F for pgsql-general@lists.postgresql.org; Thu, 21 Mar 2024 09:49:12 +0000 Received: from mail-ej1-x629.google.com ([2a00:1450:4864:20::629]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rnF2r-005e0a-7c for pgsql-general@postgresql.org; Thu, 21 Mar 2024 09:49:11 +0000 Received: by mail-ej1-x629.google.com with SMTP id a640c23a62f3a-a450bedffdfso88129666b.3 for ; Thu, 21 Mar 2024 02:49:10 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1711014548; x=1711619348; darn=postgresql.org; h=to:message-id:subject:date:mime-version:from :content-transfer-encoding:from:to:cc:subject:date:message-id :reply-to; bh=Mp+4Hk46tCf2XMCRFpp+Mv+aydQ7SXgEghnFKvaFkX4=; b=Hh5aYdJ3iyjiYsH8wYqLmE+QgFJYzLP9CRl8JFDk5ADa00TinOr+t76sRJTzW2Fvu/ TzgPZpOP9Nz024RtEjGbRmwRvm1FNaggZj5BTYz/kCsC/SXd9gxiAHWXz4a4W0O3vcVl DulKfqOQaXoY2fT38zGbc10cklSwrUFN9VNkxFmj3W5p6wdpdAtRadS+vOYXkcTwlgik GGl++xPYJnk+1ZtKxMWQSW0my+mlpG+tkv9Vm+QU08ZJudvXEsLah4m2BE1PEbU7e/iV 6b/84pYRkSXYBosE121Ij86U78U8Ggc6FWTS2TZpAVOsujLcaQAfre1ZEM+ZpHyfojQH 4F1A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1711014548; x=1711619348; h=to:message-id:subject:date:mime-version:from :content-transfer-encoding:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=Mp+4Hk46tCf2XMCRFpp+Mv+aydQ7SXgEghnFKvaFkX4=; b=Ywt5nPlLIjFQmTVhVrrHOmjvgVj4Od22BQFcqLGaAgKvQAwAiC+M1jMdttZTp5nXFG BWMVz8/7Kkle9WrTVqNxtuwKIykwsEMyop5ngf8UrvlBetadC9WUD6Gvjn4FunLWxjMZ Ik70F1Dh8lBRa8ZHQI7YbE2xRnbbQQv32ry7/Kg8Uo0y2p60Pa8p+TXQmddzxRwgmvOw SFxQxubNekCXwjfZw1IOTVXK0rtGiQJXPYlJPSIoUTSV/Iz3otVN/SoxoWpzDVjpY3Cj MLRBXSqkckte5Rnvtq1MuwZJpG7Fpzl82/3Pw9W2GgpwpVkyCtmNHCLvlQ9uUCe++U5f fpLQ== X-Gm-Message-State: AOJu0YxkRUvFeFbx2WHV2z+0+/Ss7xP4dtK7UwZ//9rWUDznFaOS7GFc iRd44MqyUVDxI3NSE8P1IjVMdBCdxiGELUGbFlZhjcqpZKgWPX2Rf5SFOvXv X-Google-Smtp-Source: AGHT+IE0rgYhB5NUdvfTtW/8cq11IS1YCOdWlVMHgL+IEc1zFVzNe8WIousVze0KpGlLGY1RkwH2Hw== X-Received: by 2002:a17:906:3508:b0:a46:d47e:eefe with SMTP id r8-20020a170906350800b00a46d47eeefemr5434592eja.36.1711014548470; Thu, 21 Mar 2024 02:49:08 -0700 (PDT) Received: from smtpclient.apple ([2a0d:5600:13:1001:4457:c1f1:2412:80c9]) by smtp.gmail.com with ESMTPSA id pv27-20020a170907209b00b00a46647b6496sm8267366ejb.155.2024.03.21.02.49.06 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 21 Mar 2024 02:49:07 -0700 (PDT) Content-Type: multipart/alternative; boundary=Apple-Mail-FB1AA74A-B77E-40D0-AEC2-538F3A8D1EE3 Content-Transfer-Encoding: 7bit From: Joseph Kennedy Mime-Version: 1.0 (1.0) Date: Thu, 21 Mar 2024 10:48:55 +0100 Subject: Question about PostgreSQL upgrade from version 12 to version 15 Message-Id: <32E46CD1-EAD1-4F03-98E2-B842673D547F@gmail.com> To: pgsql-general@postgresql.org X-Mailer: iPhone Mail (21E219) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Apple-Mail-FB1AA74A-B77E-40D0-AEC2-538F3A8D1EE3 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Hello everyone, I'm planning to upgrade my PostgreSQL database from version 12 to version 15= using pg_upgrade. After completing the upgrade process, I'm curious to know= whether it's necessary to reindex the database. Could anyone please clarify whether reindexing is required after completing t= he upgrade process from PostgreSQL version 12 to version 15 using pg_upgrade= ? Thank you in advance for your assistance! Best regards, Joseph= --Apple-Mail-FB1AA74A-B77E-40D0-AEC2-538F3A8D1EE3 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
=
Hello ev= eryone,
I'm plannin= g to upgrade my PostgreSQL database from version 12 to version 15 using pg_u= pgrade. After completing the upgrade process, I'm curious to know whether it= 's necessary to reindex the database.
Could anyone please clarify whether reindexing is require= d after completing the upgrade process from PostgreSQL version 12 to version= 15 using pg_upgrade?
Thank you in advance for your assistance!
Best regards,
Joseph
= --Apple-Mail-FB1AA74A-B77E-40D0-AEC2-538F3A8D1EE3--