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 1srE2x-00GCwq-W4 for pgsql-admin@arkaria.postgresql.org; Thu, 19 Sep 2024 10:06:00 +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 1srE2w-008YoZ-IC for pgsql-admin@arkaria.postgresql.org; Thu, 19 Sep 2024 10:05:58 +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 1srE2w-008YjE-1H for pgsql-admin@lists.postgresql.org; Thu, 19 Sep 2024 10:05:58 +0000 Received: from mail-pj1-x102a.google.com ([2607:f8b0:4864:20::102a]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1srE2s-001xJG-Rt for pgsql-admin@postgresql.org; Thu, 19 Sep 2024 10:05:56 +0000 Received: by mail-pj1-x102a.google.com with SMTP id 98e67ed59e1d1-2d8fa2ca5b1so585568a91.3 for ; Thu, 19 Sep 2024 03:05:54 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=bitnine-net.20230601.gappssmtp.com; s=20230601; t=1726740353; x=1727345153; 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=ywEMAw7Ka4H1/WGEahs4iD55Ys/GcwPIgQPSBImUaLs=; b=FF/lotw0i+oeqAyri2xPTjqlIo7QIt15V4r9zuZN1lYa4MtbzaPqIEjqrqTNSKX6G/ K8XacpV07fkcaIk/Lbtld7mmaoWX3cQkaOMqjO8NEZi2u+k6gm/VYQndNocWc7N3cf7q R2C0NayFj5UgYzBwvorZc1Y36sYny7SS4wFQLZgay2cBbNPfBft2mHLAfL5o2ckG9+lQ JCWjN/xdSRfWv5XxK4KRedrEm0uSvX5CUlb5lI5uUxlWCzGcYo53jn6Q+mF/RR9u2QhV hKMnrpFUBhqCwj3J4GImuS78z1p5eVCe8rGrAadrEWBYJh6Qu0OIjDNcXJRBPfmhUu9s Cuww== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1726740353; x=1727345153; 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=ywEMAw7Ka4H1/WGEahs4iD55Ys/GcwPIgQPSBImUaLs=; b=o+Zu3dlbuyrJ+u0KUN5jcwSd4apBtF4qWg/qNFkNpUamyClKj9rfckcVwlv9uAkLiv VWqJ2rmueh5JvSGRoOIYn+oyLXBZFYKwhAJZ4TxYhCwFQMO6LLYUlJ2v1DQYYGaaVLMj zFIavTC5mCsNWhqOQJ8uT2jRI8hr8JMY2JimQcDZ0AKvLzRdVBFFwgQFBT4d9GhZ76uj hnsA19Cv/sIDhOWLcRzJhwag5ClEzsWc5o6QCgwT3Wf8k2usEYEtf5sbv3NbtYaRq74O bOnCrU46Sa0Oel+wqeRMpe7koOv3fdZnwceJDEKY0UqDgS+DanM9qc2aeOJk1un5W3S0 w1SA== X-Gm-Message-State: AOJu0YxhxRT2NTiEK9lEYjcTBvv+eOQO6FGnpVBYor4W/jwZ7SKe2Lg7 x/mA8bD8jqnfYog8n9VaY6SvF+G+34dQbztUyuSu7h8Co6nNyhCtQS9UWpgWeVCd36kRtK+hG8b kxFZ3O8tp+qz0xDIIZgWz7kQ9NFYfR0J9KvsyCA== X-Google-Smtp-Source: AGHT+IHx18MHahXEsZCSmBM1SHdlXMowbQ3m9+q30Brtvhz2KxAMQNmPh6FXlO3cUm6arodbR//I2NOxR/SfzxwhJos= X-Received: by 2002:a17:90b:1c92:b0:2d3:bc5f:715f with SMTP id 98e67ed59e1d1-2dbb9df9afbmr25455375a91.10.1726740353500; Thu, 19 Sep 2024 03:05:53 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Muhammad Usman Khan Date: Thu, 19 Sep 2024 15:05:38 +0500 Message-ID: Subject: Re: How to install specific postgres version / downgrade in Ubuntu To: kamal deen Cc: pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary="00000000000063f20e06227611e1" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000063f20e06227611e1 Content-Type: text/plain; charset="UTF-8" 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 postgres > version to match with our primary node. > > ( replic sync also not happening due this version mis match ) > > Pls advise. > > Thanks in advance. > > SK > --00000000000063f20e06227611e1 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
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 <kamaldeendba@gmail.com> wrote= :
Hi Team,

We have observed = post OS patching one of our replica server got auto upgraded from 15.7 to 1= 5.8 in Ubuntu , we wanted to downgrade the postgres version to match with o= ur primary node.

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

Pls advise.

Thanks in advance.

SK
--00000000000063f20e06227611e1--