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 1srF1j-00GJNx-DK for pgsql-admin@arkaria.postgresql.org; Thu, 19 Sep 2024 11:08:47 +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 1srF1h-009Xkf-Pq for pgsql-admin@arkaria.postgresql.org; Thu, 19 Sep 2024 11:08:45 +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 1srF1h-009XkX-E7 for pgsql-admin@lists.postgresql.org; Thu, 19 Sep 2024 11:08:45 +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 1srF1c-0000J3-8O for pgsql-admin@postgresql.org; Thu, 19 Sep 2024 11:08:44 +0000 Received: by mail-pf1-x435.google.com with SMTP id d2e1a72fcca58-7191df6b5f5so502892b3a.0 for ; Thu, 19 Sep 2024 04:08:41 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1726744119; x=1727348919; 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=eoHZVFe+z74PuP4bRFJCW4f0tNAymNahSGgi7FULD6M=; b=gvMG+ccd+/2is/mFK32WNoruzmmhvbVudq9cY+XYvK1tvySPcR5GBgWHSWbyiq5vah MZRYGyXsVRdEeD5PoZ1FvvkJVC0w8YPBO+vXpv9yY7yv8uwXcqcv6zanceNYxXTi80+j wJmwtGyDiQYPyvthsa/abuVWleOErDuyF3lIkgtkeLkF/9AbKCKbukJs2kGNjNOwVbYy qNWG5/AP46PlZN+Hbd/vaQvSSf++vVkKbGN707kzBV6t8JADvG3Y8d1r+gd2q70HDtb5 l4VpdRTHT6fYZOK/0SNXp7AAsNVy4/8rbAdQzzK9MCY/VGfQN9hyDgukrpbsNtADhzof lbOA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1726744119; x=1727348919; 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=eoHZVFe+z74PuP4bRFJCW4f0tNAymNahSGgi7FULD6M=; b=Pjv6ibpx0U6cpCO0uh8OjD1Th9n2JxE+qyFM5GMbUPikAHtvuCI/u98IevmrtC1Un5 1v8dPNtgN+siD8Muje2nNo5inKdA9T4E+4uqpkL/GyoTX4Vf4OFH+ADVr4IqumDU3Z8q YhmBO9IMn23nQuA1f1V3ASkcUWhOviz64RF7SYfR1YpgIWcPuD2hINU3N5HMdZQJ/uk+ LDF6pIqtjaohkBGyZLLtxGF4D4CX/F089NQavpkYH44x8lPrjfA8EyHKBJS6PGcfkPbL U+sTfHTCIfopreQ5v3NbnznRU+WTKTqV+/dRSGt3iG62aGfNOaz9+iDjsH0wevYwQMET rOOA== X-Gm-Message-State: AOJu0Yz8PreNAZMAN7TJGb2Oq/Az1rq5BCiUB3YN0I2YWi8lc1S/rYMg irUKUxYbBytF39SDzSZtp0BWR6lec7V67aiMnL4wSK283pqXCggjiy6CERHFLzq7AZiMZyaXIF8 hDEuiVTSkWcdVo8K5Y8BUyaaPWzlhxA== X-Google-Smtp-Source: AGHT+IHI/g/OP46q9lodIYvcRjW5qbBxn1HjAtfFe6bNbkCsOi3TCX9dyfON3xB79cgcg9TzyNsvTgIcLAxyDBVNOTg= X-Received: by 2002:a05:6a21:3115:b0:1d2:bcba:7c83 with SMTP id adf61e73a8af0-1d2bcba7cc9mr26699378637.44.1726744119298; Thu, 19 Sep 2024 04:08:39 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: kamal deen Date: Thu, 19 Sep 2024 16:38:29 +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="000000000000d95123062276f1c4" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000d95123062276f1c4 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Appreciate, Thanks for your response. SK On Thu, Sep 19, 2024, 3:56=E2=80=AFPM kamal deen w= rote: > 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 postg= res >>> version to match with our primary node. >>> >>> ( replic sync also not happening due this version mis match ) >>> >>> Pls advise. >>> >>> Thanks in advance. >>> >>> SK >>> >> --000000000000d95123062276f1c4 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Appreciate,=C2=A0 Thanks for your response.

SK

On Thu, Sep 19, 2024, 3:56=E2=80=AF= PM kamal deen <kamaldeendba@gm= ail.com> wrote:
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:

Backup Your Data
Stop PostgreSQL
Uninstall Pos= tgreSQL 15.8
Install PostgreSQL 15.7
Check Replication

On Thu, 19 Sept= 2024 at 15:00, kamal deen <kamaldeendba@gmail.com>= ; wrote:
Hi Team,

We have ob= served post OS patching one of our replica server got auto upgraded from 15= .7 to 15.8 in Ubuntu , we wanted to downgrade the postgres version to match= with our primary node.

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

Pls advise.
Thanks in advance.

SK
--000000000000d95123062276f1c4--