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 1r91US-00DXHS-8y for pgsql-hackers@arkaria.postgresql.org; Fri, 01 Dec 2023 11:15:24 +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 1r91UQ-0077MT-B7 for pgsql-hackers@arkaria.postgresql.org; Fri, 01 Dec 2023 11:15:22 +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 1r91UQ-0077Kp-12 for pgsql-hackers@lists.postgresql.org; Fri, 01 Dec 2023 11:15:22 +0000 Received: from mail-wm1-x332.google.com ([2a00:1450:4864:20::332]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1r91UN-008GCs-As for pgsql-hackers@postgresql.org; Fri, 01 Dec 2023 11:15:20 +0000 Received: by mail-wm1-x332.google.com with SMTP id 5b1f17b1804b1-40b5155e154so17146145e9.3 for ; Fri, 01 Dec 2023 03:15:19 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1701429318; x=1702034118; darn=postgresql.org; h=content-transfer-encoding:in-reply-to:from:references:cc:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=SpuYualSi0VVzAJePdLxw9ufy2M5rk7TypKVYjrXAU0=; b=E3x3ShCo+j0zhEndSv0AbCN7QAtjSZbJNrZfxuDDVllEY2wS5KY0kSuUTAZfjmaJTa JDR8hy5TuB4RTf8rVOUMTIxI+CPJ2pW/5cDUozgYkcsm1yfoBwwssxLI9JOPHUkTrLYu zKNeiLdmUpY6VrlBbwLo4u8nKg187/ScecNUlsb2jNUYe6iEZnWMZMUqGMfC4GNCQYwt dtudFHsDVki3NtLCqN+qbDBQQ7AEaRf/b0S6AqOkMuS6DN5PUJnNHZGrrO1xnnrlCLSR yV5xbffKuSFijuuwqcGHg9IZe8fnfcFznXY9+a3VSZtIFVYeSlK4UGey7kANp/j10Yqd 1x7g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1701429318; x=1702034118; h=content-transfer-encoding:in-reply-to:from:references:cc:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=SpuYualSi0VVzAJePdLxw9ufy2M5rk7TypKVYjrXAU0=; b=EEdMuiDh8OrIrzUnGc6D58owid3IHS/VZMWy61JmLYLFuaHrjHoLTkOHGGgOQeGwPW 1N6lkLYDvNBdLPvSR+Muhv4dXWs+yvxztFQIGT0kd17f1wh1u40rlze8QiJupjbj4oBg zkYVlzlxOD4tEHb++0jYRR1A84uJKz/0JVEpHC7XhFKPLgEM2WTOwcMrUj2DtSbYvYV+ f+N6Agm9zjW7xFUCJ1ktPWAdyPAuEpHp9MNq0Q8/PTTkwAscyTIpm/GHzoi//pRpL+26 Oembfn/JRLFdi24A1FdQPq8LfxCBBVJwT6zMMucBuf1XA3nr/UfdrxLHUbngpoAuepuc AUjA== X-Gm-Message-State: AOJu0Yw0fB88mz95UBhGAla4mEBLy7KWBa/8aHRLEU0CU86XTbD/xiOn wjq2mBWcI4EpKvLuwz/bUOs= X-Google-Smtp-Source: AGHT+IEjQv98Q4P28HjJ8pLOY5E7SK6J0VGyAksmlc0/LWqak9PkUpHuFOVaF+r0Dr7zGip8XWvqUw== X-Received: by 2002:adf:e482:0:b0:333:2fd2:2f03 with SMTP id i2-20020adfe482000000b003332fd22f03mr773000wrm.124.1701429317533; Fri, 01 Dec 2023 03:15:17 -0800 (PST) Received: from ?IPV6:2a01:cb11:192:7000:7945:1082:2fd:9ccb? ([2a01:cb11:192:7000:7945:1082:2fd:9ccb]) by smtp.gmail.com with ESMTPSA id dr6-20020a5d5f86000000b003316b38c625sm3940049wrb.99.2023.12.01.03.15.16 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 01 Dec 2023 03:15:17 -0800 (PST) Message-ID: <6694284d-c847-42df-8f76-6efa8eeeb0df@gmail.com> Date: Fri, 1 Dec 2023 12:15:16 +0100 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Synchronizing slots from primary to standby Content-Language: en-US To: Amit Kapila Cc: "Zhijie Hou (Fujitsu)" , shveta malik , Peter Smith , "Hayato Kuroda (Fujitsu)" , Bharath Rupireddy , Peter Eisentraut , Bruce Momjian , Ashutosh Sharma , Andres Freund , pgsql-hackers , Ajin Cherian , Alvaro Herrera References: <65326908-f1ef-40ce-acc6-414801c30946@gmail.com> <1789e94e-8266-44d1-95e4-7f41abc27d0d@gmail.com> <828dcda4-50c2-4069-bdc3-9e8c90c943d7@gmail.com> From: "Drouvot, Bertrand" In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On 12/1/23 12:06 PM, Amit Kapila wrote: > On Wed, Nov 29, 2023 at 3:24 PM Drouvot, Bertrand > wrote: >> I think I'm fine with documenting the fact that the user should not change the failover >> value. But if he does change it (because at the end nothing prevents it to do so) then >> I think the meaning of subfailoverstate should still make sense. >> > > How user can change the slot's failover property? Do we provide any > command for it? It's doable, using a replication connection: " $ psql replication=database psql (17devel) Type "help" for help. postgres=# ALTER_REPLICATION_SLOT logical_slot6 (FAILOVER false); ALTER_REPLICATION_SLOT " Regards, -- Bertrand Drouvot PostgreSQL Contributors Team RDS Open Source Databases Amazon Web Services: https://aws.amazon.com