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 1tTcw6-0072jw-Q2 for pgsql-admin@arkaria.postgresql.org; Fri, 03 Jan 2025 08:21:39 +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 1tTcw4-007f4J-Bp for pgsql-admin@arkaria.postgresql.org; Fri, 03 Jan 2025 08:21:36 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tTcw3-007f4A-Vs for pgsql-admin@lists.postgresql.org; Fri, 03 Jan 2025 08:21:35 +0000 Received: from mail-wm1-x330.google.com ([2a00:1450:4864:20::330]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tTcvx-002xdd-Ug for pgsql-admin@lists.postgresql.org; Fri, 03 Jan 2025 08:21:35 +0000 Received: by mail-wm1-x330.google.com with SMTP id 5b1f17b1804b1-436a39e4891so31106445e9.1 for ; Fri, 03 Jan 2025 00:21:29 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1735892488; x=1736497288; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=RTBRLro4R+7m6rZIeo5s5fDlQTOs0TeD8A0h85xQmIE=; b=sqBPt3a9tz3vJsDtMFDawqP4FkuWelfkiP07/1mOFROLW3yzz+Hd3HskcTJ1Vl/cXM AlkR8x09Y2Zv4Jn+ryhKWsnGzSH+ZKgaUF1kpEyQHTuLNaVtTbHeQgOt9VvQhSJfmxdQ Am8m59aSS8YBJnr7WYyAPC1EkJgep7Xoih4blJdkMKt3W3MXL2C60v86nV84d5+ltkaJ nY0PntJSTVFu0rIYVEkOEXkF4nZNUElxzYSIkwKQ28Z2CVzzjo1l8bH3KHWIMYSR47GF gNxRDOdZYcpv/9hrCNeq8wkaGNiv7WWw7i7TKfxzbUaBKVeW40S0iJiCWW/CbKl0zZ2g iGtw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1735892488; x=1736497288; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=RTBRLro4R+7m6rZIeo5s5fDlQTOs0TeD8A0h85xQmIE=; b=jLPycIQCyGjY3Mf0OHMyIj0HnNO7GyEJ3XAP5ozLDn7ka5xX2aNpn/2zqHv77UzRRM OaPEU3fA1UltpHEtO0e7Qa1uLGHtWCjWZx5rxuwIAy6AjpEACokbt+BZLAR5NgMhfSAr y/rMMDXT9QsdolVWY+azY8WcjWzr0khvnbxKJOODqUlMN24Ov99zfqYIpG88B+jStFiU y7xg/Uzd8mVtduKWI3RyjqKWFeWrrXS8fQ92hHhIsbVOP4mbXAvXLYFPReYktoSs7DAm Ev7TsGVxQDKTqBaNWzXhp0HQSym6mYnlEKRNO7cD1ZujvS6wqElnsumM/W4brmLuvVct 5s8Q== X-Forwarded-Encrypted: i=1; AJvYcCX78xZLlO8Rcpw7DEhzOFReG/+31yjBPMUL6VOWF56W9+NsHvv+sp8GOitUqTRtPSbjw+Di4PTM+WX+Sg==@lists.postgresql.org X-Gm-Message-State: AOJu0YyuU5Nfb6vav3WbgMZpVBa/iLT15cLsZT2gglgNnaa4DYbSNlYe 7HOkxcifc9Ne8/INqunPd+gNG995HSeoNQ2nB9wmD1WWxvyb8jGdnZRBvkHuboM= X-Gm-Gg: ASbGnctunYn8Apj8cX62MMIZJupyHv4HQjsci0weGrrrFfxQk+FJBEG6/gJlT4MD+QP JlK5phMen9b/XsTDb7RJwsck0xbHDQ6Amx5j2MNA0e/RxELDedS5AwzzvMuo6fFuG1fT9MTYiOf pJrg31wRY528+m9KKkVsf86UuzG1cUbYMVoz341mOwDBfvSloc6FPijKDW5Ojpif+nA6EP6djVa jZ2vDleqI+W7gsUAebfNncRUtAmW7IRk8xSAtpSmC741rfRIEq+M4sbnV2BavpW8bvfn5QZ+pdQ X-Google-Smtp-Source: AGHT+IETbDpudtMqTnzIZuEoSJlt0feTbwz4YvqXYVZ2hnrvkbyE+zVR5YToVWGPBTZlyZMGnrUIdQ== X-Received: by 2002:a05:6000:4614:b0:386:2e8c:e277 with SMTP id ffacd0b85a97d-38a22408c81mr45816022f8f.55.1735892488261; Fri, 03 Jan 2025 00:21:28 -0800 (PST) Received: from localhost.localdomain ([2001:871:5e:ce68:6327:1235:d52c:ed43]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-43656a0b361sm508990675e9.0.2025.01.03.00.21.27 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 03 Jan 2025 00:21:28 -0800 (PST) Message-ID: Subject: Re: Upgrade for primary standby config From: Laurenz Albe To: Siddhartha Jain , pgsql-admin@lists.postgresql.org Date: Fri, 03 Jan 2025 09:21:27 +0100 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.54.2 (3.54.2-1.fc41) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, 2025-01-03 at 06:21 +0530, Siddhartha Jain wrote: > Please provide me with the high level steps for upgrade in postgres from = 11 to 15 version > for primary-standby configuration setup. You cannot use a streaming replication standby server; you have to use logi= cal replication. - set up a logical replication standby server - wait until replication has caught up - stop your application - set the sequences on the subscriber (they are not replicated) - drop the subscription - make the application run with the new database I recommend that you use pg_upgrade rather than logical replication. Yours, Laurenz Albe