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 1srENL-00GExH-GT for pgsql-admin@arkaria.postgresql.org; Thu, 19 Sep 2024 10:27:03 +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 1srENJ-008uyK-DT for pgsql-admin@arkaria.postgresql.org; Thu, 19 Sep 2024 10:27:01 +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 1srENJ-008uy1-1m for pgsql-admin@lists.postgresql.org; Thu, 19 Sep 2024 10:27:01 +0000 Received: from mail-pf1-x435.google.com ([2607:f8b0:4864:20::435]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1srENH-001yof-2o for pgsql-admin@postgresql.org; Thu, 19 Sep 2024 10:27:00 +0000 Received: by mail-pf1-x435.google.com with SMTP id d2e1a72fcca58-71781f42f75so622310b3a.1 for ; Thu, 19 Sep 2024 03:26:58 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1726741617; x=1727346417; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=pzy5MyenwcdN0yQNWGybzfHK3Z3XHWxj05CJ/GRFUhI=; b=g97nscLY0rO34CefhJvqPMUupEj79buuH1/L3OmpfoiXTcq+9/DzDFr589RLfr6yc6 QFzCYyKRFGMIa4OUi1Jsra3VG1L1GWpIh5sBj1A/xAjKGaJr39FKjA8H9B1c4Zlb1K71 Oesl8Zd7/5+ZX6qISUpYb1Y1Eiepcdf0dhOXCArNZFmKERzmqGE4d1t/hiM7IU5nf9Zq tjZS9DIZa5X1OvsD6N0SjXCfl3BvK82JFxdyFmAZ5J2a0g2M5RQHdPdzXyUdABERY4hh dg3cvjPRncDPLSuzLlFP2gxYteCjZ0/Mg5G76Co/NlL7XBnGTv2WscUc74QHWj1XS9X6 bDOQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1726741617; x=1727346417; h=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=pzy5MyenwcdN0yQNWGybzfHK3Z3XHWxj05CJ/GRFUhI=; b=Al4LoaSUzVrcolaXJKno0CdIetBS8Jh2ERJo9nao8xKS69wR4dZ4PgbogZtD4j8ZHV CC7mxt9nH6K1n8mZc0Mf7wsmpsPrYULP3d8woy8m+Q3qAoqMxQDd/gLbjmPZ+BW/GVDz wV6Q6/Byyt7G9zldR/rJZAidPghXarexIi9ohPGNsPCnk/WCgr6QG1LxAJqz3ktb8XqM 5/je/NhMpQ2EPfIp6qUDebUUNSG6V1i5qp+LfqIDND1GiCLJjsV1LEwRihmJjMUu26QP YB9DSJAVwjcFhNtFdNPdGFT7uqPwoRDfNTcHG18Vm4j2KdpRw3M3gcGMmSzosARtP89Z SqXg== X-Gm-Message-State: AOJu0Yw8WfYdLM0jWbMBXevvYOvaVrA3/AQvj+4/dMfmvWU6jl2fSCQD aXlMGDvZlI2n3nfAgQfEuSx2YV+7dp6IuMDI5qixPK8O4cnZJuaIVeO/r4iVCqaaXTbfBLHrVe3 Qu1+Xe37puHW59eABl7CAL5cyR+bq6Q== X-Google-Smtp-Source: AGHT+IFSqsJBEwUnQfEVsiDE8BpCOeKG0JMx9fccAXKa0X3Iub2GSB2/jGgjp2ks2kZZyfoemXbwZIJybcvxirrdCgY= X-Received: by 2002:a05:6a00:1790:b0:70d:1dcf:e2a5 with SMTP id d2e1a72fcca58-719260656f1mr40177074b3a.3.1726741617134; Thu, 19 Sep 2024 03:26:57 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: kamal deen Date: Thu, 19 Sep 2024 15:56:47 +0530 Message-ID: Subject: Re: How to install specific postgres version / downgrade in Ubuntu To: Muhammad Usman Khan Cc: pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary="000000000000b557a20622765c13" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000b557a20622765c13 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Thanks for your response, I would like to get the exact commands to use. SK On Thu, Sep 19, 2024, 3:35=E2=80=AFPM Muhammad Usman Khan wrote: > Hi, > I think the only solution is to: > > Backup Your Data > Stop PostgreSQL > Uninstall PostgreSQL 15.8 > Install PostgreSQL 15.7 > Check Replication > > On Thu, 19 Sept 2024 at 15:00, kamal deen wrote: > >> Hi Team, >> >> We have observed post OS patching one of our replica server got auto >> upgraded from 15.7 to 15.8 in Ubuntu , we wanted to downgrade the postgr= es >> version to match with our primary node. >> >> ( replic sync also not happening due this version mis match ) >> >> Pls advise. >> >> Thanks in advance. >> >> SK >> > --000000000000b557a20622765c13 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Thanks for your response,=C2=A0
I would like to get the exact commands to use.

SK


On Thu, Sep 19, 2024= , 3:35=E2=80=AFPM Muhammad Usman Khan <usman.k@bitnine.net> wrote:
Hi,
I think the only solution is to:

Backu= p Your Data
Stop PostgreSQL
Uninstall PostgreSQL 15.8
Install Post= greSQL 15.7
Check Replication

On Thu, 19 Sept 2024 at 15:00, kamal deen &= lt;kamaldeendba@gmail.com> wrote:
Hi Team,
We have observed post OS patching one of our repl= ica server got auto upgraded from 15.7 to 15.8 in Ubuntu , we wanted to dow= ngrade the postgres version to match with our primary node.

( replic sync also not happening due = this version mis match )

Pls advise.

Thanks in a= dvance.

SK
--000000000000b557a20622765c13--