Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lhVHr-0001j5-KL for pgsql-admin@arkaria.postgresql.org; Fri, 14 May 2021 10:43:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lhVHq-0004vZ-Gq for pgsql-admin@arkaria.postgresql.org; Fri, 14 May 2021 10:43:18 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lhVHq-0004vQ-6K for pgsql-admin@lists.postgresql.org; Fri, 14 May 2021 10:43:18 +0000 Received: from mail-wm1-x32d.google.com ([2a00:1450:4864:20::32d]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lhVHc-00025g-M0 for pgsql-admin@postgresql.org; Fri, 14 May 2021 10:43:16 +0000 Received: by mail-wm1-x32d.google.com with SMTP id 8so1595258wmc.5 for ; Fri, 14 May 2021 03:43:04 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=cybertec; h=message-id:subject:from:to:date:in-reply-to:references:user-agent :mime-version:content-transfer-encoding; bh=YBlmvHXf2LlKQByWwvmEWsRqGHPP+NtRxzPzBws03Pw=; b=IXLNQOvJ8HX0oPZ2ucQCjly1oEqA97sOT3e7v1N/AaQKy589ljzH0bmb+aSjc88t/A 42pTzx7zd0Gz7p6QqP2LZpgg+XpV5oyIjEivO3aR/DIa5vKmtoIfc+Rld2+6DLffOTFG 689xgialdtKddhmyFqzxheePLhfLxjAgfhJMVVS2O3pvAM9SiV6wGK/JiIbXQ8kGMWBa NpCkAhUSTpq4bEUDwyWnTbKAZGUHpbZPgkxX+Bp+a7DeFfp1iV14O1DahGgJJOzuH3X7 YnJqzy6mE9Xlea8UOXbaDnSHTJMcYaukHf1TY3WrsTpabmjICN1zfY81/Gy6q63EpXoZ tXZg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:message-id:subject:from:to:date:in-reply-to :references:user-agent:mime-version:content-transfer-encoding; bh=YBlmvHXf2LlKQByWwvmEWsRqGHPP+NtRxzPzBws03Pw=; b=Ac1ezymv6djLGeZHzexPNLnGA93TcgYGt1rNYi0wIZST2g3MrmDjCeBNrorSRMQUWw LZFzJmlNuY3V1kmq7XG2PyLR+EtDuaC5OTljBJVhKIN5gb2+hSKeTrot2gMoDGM4E2BP N0QLZjHwoi7EWJwrXKF/qTHGZfX0hvm81LW5OqIRluytE6qN8lHKM2uf/27eBRRihJYl k3msgbBvUGL5aZAJ5AhYmGi92ua/g+WEi0K/KUj1FKGBLotz4cFzMdxLruCNvjdwj8mN f6c7lVArmAvEFTbZoxZqdVxfTKslFUD9wuCm1xX4/6Mhu0G0F7G7xNHiILa7oM0h0ISp dZvA== X-Gm-Message-State: AOAM533lJaT4lfb0S2IAXkVxthLJhCS7bhh0lcEp9wPYUiWPJk8OFgqh m3IibMXgzh93v3Afu1zLQBPQsw== X-Google-Smtp-Source: ABdhPJwx+EJpBy2AF4CDA9BnRUJ3Wzng+BkJQFWkwnFc7PPZPqA2hy92H05/Ch3ijWjgP4x3DRZJHg== X-Received: by 2002:a7b:c446:: with SMTP id l6mr280832wmi.78.1620988981788; Fri, 14 May 2021 03:43:01 -0700 (PDT) Received: from localhost.localdomain (217-149-172-105.nat.highway.telekom.at. [217.149.172.105]) by smtp.gmail.com with ESMTPSA id b6sm11266682wmj.2.2021.05.14.03.43.01 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 14 May 2021 03:43:01 -0700 (PDT) Message-ID: Subject: Re: Changing wal_level From: Laurenz Albe To: rammohan ganapavarapu , pgsql-admin Date: Fri, 14 May 2021 12:43:00 +0200 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" User-Agent: Evolution 3.36.5 (3.36.5-2.fc32) MIME-Version: 1.0 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, 2021-05-13 at 10:09 -0700, rammohan ganapavarapu wrote: > I have a master slave setup with wal_level=replica, i am trying to see if I can > change the wal_level to logical without breaking the existing replication, is it possible? Yes, that is possible. All that you need to do is restart the primary server. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com