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 1srF9T-00GKHP-2Z for pgsql-admin@arkaria.postgresql.org; Thu, 19 Sep 2024 11:16: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 1srF9R-009lyg-Dq for pgsql-admin@arkaria.postgresql.org; Thu, 19 Sep 2024 11:16:45 +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 1srF9Q-009lxn-Tz for pgsql-admin@lists.postgresql.org; Thu, 19 Sep 2024 11:16:44 +0000 Received: from mail-il1-x12e.google.com ([2607:f8b0:4864:20::12e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1srF9O-001xkR-5P for pgsql-admin@lists.postgresql.org; Thu, 19 Sep 2024 11:16:43 +0000 Received: by mail-il1-x12e.google.com with SMTP id e9e14a558f8ab-3a09c22d119so2660165ab.1 for ; Thu, 19 Sep 2024 04:16:42 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1726744601; x=1727349401; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=1zM3ph0K+p9LL8ocCFnLgAJPjLNAzyF9AX8GX0bhgZQ=; b=hs6WNLiQ2wJ7//Yy2Dzu7Lgmd7dRgMdepZGOpgCaWFjPUW4F28mO9HldWAUInie5zh gdiRr16dpJiFD29B7QVbqwNI6V8th2xb2H9N6cCELpkLIVfH7sOta/Fp66juMuBdLazp ka1rYBrjN+v++hKPmmzmWZ3l8as9To/ItqTfyg6eNuIdzrJrY0c1zgZjaDv90XbfrELm Fsx8TdN4Cv1j3Rj+AVZ1+rVAXL9lWeqPyorYYmvuzpiLLmrzXmPBU33sAfhk7ob2+Itw FyfTSGK1HlLNj1/unVcVHWCAwcsD1OsBIWYPPQbmM3nnuMalxu+RcetDbiFsQCPIdhC3 aw/w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1726744601; x=1727349401; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=1zM3ph0K+p9LL8ocCFnLgAJPjLNAzyF9AX8GX0bhgZQ=; b=uutLQDB10Y1uHxhQKNJUu7nM+sCoI0Z17/ekA3VYQrHMN30eXKf1+xbUzEpLkNKQUr S8+EZDixgy7OMg2m8I3HcXo6cvd36pU1hc2oVIQKxNrnc1OiDOAu+CcOE8E3lmfkdHiI kcrnsy3/mZKROaCi1xFKayInnOfaKDBiWfZNUTB5xeFNH0lfVX0q31UHit42SNY/0slT eXoYZtTc2Zz9cYpnFUrAPBYSlRfwSeYKwbbxjyFO6PxxqcLxGK1oYvZ23vvMG7k2Cz7b o6uIx83pLdeCvGHNCNWPnADXA7IslNPZPy5b8jMOrMY0+DqwIQMp/g8tOp36dQK/4L9W w6ng== X-Gm-Message-State: AOJu0YygzanNnokI7ay+PGyolrp+GPv/cKUPem3qUZkPt9MRDcRqu8ik yD6MT5/T26F8mR3k7lq9tnvbHFoR3OO5spG6elu9Uup2vCbfEjQ3VY2M/PBKX7PJ/PRKrf7POWF 19LyQknhCIcCViBp1hbKySIPOoTY5Zw== X-Google-Smtp-Source: AGHT+IFKjlumsEA2p+3Gb4M4+VSuM+waIlgg9o1YsH5bhTIii30Hcoee0C4vLfsQwddNxZnBAYSyNVePUqu0YRy66yQ= X-Received: by 2002:a05:6e02:12e1:b0:3a0:9f1a:790b with SMTP id e9e14a558f8ab-3a09f1a797bmr135302645ab.18.1726744600857; Thu, 19 Sep 2024 04:16:40 -0700 (PDT) MIME-Version: 1.0 From: "Narendran .j" Date: Thu, 19 Sep 2024 16:46:28 +0530 Message-ID: Subject: Failover and Failback To: pgsql-admin@lists.postgresql.org Content-Type: multipart/alternative; boundary="0000000000008d55b00622770eed" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000008d55b00622770eed Content-Type: text/plain; charset="UTF-8" Hello Team, I have facing a problem in failback. I just promoted my secondary as master by using pg_ctl promote.it was successful.so now how can I bring my old master as primary I tried with pg_rewind it's not working. So is there any other way to perform failback. Is there any procedure to perform failback and failover please share with me. Additionally we don't use any tool for it. Regards Narendran J --0000000000008d55b00622770eed Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hello Team,

= I have facing a problem in failback. I just promoted my secondary as master= by using pg_ctl promote.it was successfu= l.so now how can I bring my old master as primary I tried with pg_rewind it= 's not=C2=A0working. So is there any other way to perform failback. Is = there any procedure to perform failback and failover please share with me. = Additionally we don't use any tool for it.

<= /div>
Regards=C2=A0
Narendran J
--0000000000008d55b00622770eed--