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 1sJwqi-007W5I-2n for pgsql-general@arkaria.postgresql.org; Wed, 19 Jun 2024 15:03:48 +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 1sJwqf-000QKw-PE for pgsql-general@arkaria.postgresql.org; Wed, 19 Jun 2024 15:03:46 +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 1sJwqf-000QKn-Ds for pgsql-general@lists.postgresql.org; Wed, 19 Jun 2024 15:03:46 +0000 Received: from mail-ej1-x631.google.com ([2a00:1450:4864:20::631]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sJwqd-0025u4-TK for pgsql-general@postgresql.org; Wed, 19 Jun 2024 15:03:45 +0000 Received: by mail-ej1-x631.google.com with SMTP id a640c23a62f3a-a6f177b78dcso838265366b.1 for ; Wed, 19 Jun 2024 08:03:43 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1718809422; x=1719414222; darn=postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=YjwCcxo2SAI1dySz+IPjMRBphKXOY/9Vo08F6gP7Xn0=; b=Zkf8uvn6t2TBTgFM4gXbXKPSO5PJ9YEV5cIPSyk/85eLNHjC684nrK/jn8YYPUlphb zOvqazzTl46rwc462ZPPnqEmOtQffG+YN6SdMip5QPRD4x/WIdR7qGlk6E6EwLyE3I+I JkGN7rai/KrcREcIqKJWZWduw7KZXnEGGVquCKdJRl7cJYDuQsgwA2oaMcc8+VNM4F7+ XKhiUz3rgQgZ4jgM8zhBWRJStkFhki/EpU/hmRuc15ayCGS7rToRAZvFtIGHdewim85F 1dyYqbn870eP6H86qRQMFASvivXOw/CLUKAq3qR9UTjel1gE8EKoUVegBiGcogOUyloO Z3Vw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1718809422; x=1719414222; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=YjwCcxo2SAI1dySz+IPjMRBphKXOY/9Vo08F6gP7Xn0=; b=SXh/EjzHw6GR0fhu1grL2zGpQuHqKbEK7bKs/2huHhmgLgI8rb9gZ7h4G9Folt4MNF xAWJtPep+f0vJO59YdMpAb4Ynip/V66887aWReU+ajcG0icWqq1Ju+WzTQxo4MYloh1X gQhH8mBsbjP8fzKbzOOkYKs7OE9a3j3fdWvZfVSpE7SmO7uZq0pPvmjuSBdecnulLxRd pHluwLhEBSyw9wPjHryVJlZeOmFOSekZsnQIw3HEohxFR15TBI/8Orubp0GQX8AvW7j7 cNpTh1H1oc/lYzhtzWX4FJpwUzpVKTqPl/qHwz7T062TUaFmVPqSExBzBn8lofYaOdRZ NYNg== X-Gm-Message-State: AOJu0YxlOg7bl+dHheyCsY7f3KpC3qG0bEJAqzAYyrWwwaDjbeK4La6/ /aLDFpp7o/LAiWKQV1uqGSwtUFB8GneOsCbVRaNQDr9Q1JPzmdE8uxBm3AinV0txDYswlj+rmsa WpizcxL3KVoDJUEE6hTfMyrLxewqY0g== X-Google-Smtp-Source: AGHT+IFwlqpcrzBuxQni5lkPjFAnSC2l4aBgw/Llt8lvLyS2gA/bfAYGgtxM5NZRDh/Lm/+zCa16PGvn5uRPs4ZODH8= X-Received: by 2002:a17:906:4a92:b0:a6f:3ba9:9514 with SMTP id a640c23a62f3a-a6fab6489efmr145343066b.37.1718809421869; Wed, 19 Jun 2024 08:03:41 -0700 (PDT) MIME-Version: 1.0 From: Yongye Serkfem Date: Wed, 19 Jun 2024 11:03:30 -0400 Message-ID: Subject: Manual Failover To: pgsql-general Content-Type: multipart/alternative; boundary="00000000000006fd21061b3f8172" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000006fd21061b3f8172 Content-Type: text/plain; charset="UTF-8" Hello Engineers, I am facing an issue with the manual failover of the standby to the master role. I was able to promote the standby and got it out of recovery mode. How do I direct applications to point to the standby which has assumed the role of the current master, and what should I do after completing maintenance on the previous master to assume its original role as master? I would appreciate any input, and thank you for your time. Yongye Serkfem --00000000000006fd21061b3f8172 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hello Engineers,
I am facing an issue with the manual = failover of the standby to the master role. I was able to promote the stand= by and got it out of recovery=C2=A0mode. How do I direct applications to po= int to the standby which has assumed the role of the current master, and wh= at should I do after completing maintenance on the previous=C2=A0master to = assume its original role as master?=C2=A0
I would appreciate any = input, and thank you for your time.

Yongye Serkfem=
--00000000000006fd21061b3f8172--