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 1jmmZJ-0003UU-Dl for pgsql-hackers@arkaria.postgresql.org; Sat, 20 Jun 2020 23:06:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jmmZG-0001Gz-LF for pgsql-hackers@arkaria.postgresql.org; Sat, 20 Jun 2020 23:06:34 +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 1jmmZG-0001Gs-6d for pgsql-hackers@lists.postgresql.org; Sat, 20 Jun 2020 23:06:34 +0000 Received: from mail-il1-x142.google.com ([2607:f8b0:4864:20::142]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jmmZC-0004UF-V8 for pgsql-hackers@lists.postgresql.org; Sat, 20 Jun 2020 23:06:32 +0000 Received: by mail-il1-x142.google.com with SMTP id a13so12747114ilh.3 for ; Sat, 20 Jun 2020 16:06:30 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=bym+h4UxGcmC1QjdiJCkEv/WtIvSIv+N3iMkxph+3D0=; b=iK5otCXIkCHK5MTtBw97YxMhOgOZOlX+9049P8fqbtQLgGnfUTFT+p5z9o6JAELZsr vqNqUKYyxHrGHMdOhGKF9PKJqIQJLNgfNiIZ4XREoSvDfUq1XyL7vWAJfJE4C1wWUsFT xh9eNn76TrZ8QedGmCVYzRYZwr6SMPu49kpzMk9W1SZuqb/CYBP4LBI7PGY0Je0BeNOg Ias0n+vQjGJaAswSD9Sofmiw3DqWdSr5blu74QeCHYATp7oBKruBln0o5N1Rg41X53V6 jcDjsR2Z2fMn0X6OGHcc9DBvMEPVciHrHvFcrhoVwDGQq2TBIlXdNnA17Yi0ZY0EdqSI cO3A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=bym+h4UxGcmC1QjdiJCkEv/WtIvSIv+N3iMkxph+3D0=; b=kssgMbh/klHSQjLTUq/vIbJC0YGeUtU/Ro+e1ik/cT++2uaovyU+UseEkNYKPM83f1 ooVoJnci4Ipm4a6xb2xx+oqe3J6UUAfvLQ0CsaDyig77cwokdxRn0pYH2keojj066/ZL SZbb0Y/BSqthImRdPJbqxhGTJD7cCPKEOC5qYwSOjN9+whd4fng6LTMtrkb/nW2Ot9ba o9sbLbWXTOZFK3hONkRJLnQJShJusSk0XEFw3UNnChSal2OzIjTU7IjofF4Crybj8NPG DAVV+Qq0zuf5Grfb6Vv/zbDeGWJkreQEtmOPMLNVFnc4G/i1JXzIHV2QEaIDsCcj0pE6 WkYw== X-Gm-Message-State: AOAM533SCaBIbhnJRjYKs2yXZbXOnsqvF9PeM/7lqupuGDsqlIc3JXQu 8kWAeUP6jd0Q2Xh2HVrk+/a19w== X-Google-Smtp-Source: ABdhPJxvB0RzlOEiz33MYNwed8feUgOyefTfVyxAsz6gpoVZ9DVjQEIRgH/oGCOoYmL3ynorwEbnPg== X-Received: by 2002:a92:c103:: with SMTP id p3mr9706080ile.166.1592694390073; Sat, 20 Jun 2020 16:06:30 -0700 (PDT) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id a13sm5587298ill.51.2020.06.20.16.06.28 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Sat, 20 Jun 2020 16:06:28 -0700 (PDT) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id 09854800A36; Sat, 20 Jun 2020 18:06:27 -0500 (CDT) Date: Sat, 20 Jun 2020 18:06:27 -0500 From: Justin Pryzby To: Alvaro Herrera Cc: Kyotaro Horiguchi , jgdr@dalibo.com, andres@anarazel.de, michael@paquier.xyz, sawada.mshk@gmail.com, peter.eisentraut@2ndquadrant.com, pgsql-hackers@lists.postgresql.org, thomas.munro@enterprisedb.com, sk@zsrv.org, michael.paquier@gmail.com Subject: Re: [HACKERS] Restricting maximum keep segments by repslots Message-ID: <20200620230627.GA17995@telsasoft.com> References: <20200407.091243.1526068106063312556.horikyota.ntt@gmail.com> <20200407002502.GA7078@alvherre.pgsql> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="HcccYpVZDxQ8hzPO" Content-Disposition: inline In-Reply-To: <20200407002502.GA7078@alvherre.pgsql> User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --HcccYpVZDxQ8hzPO Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Minor language tweak: diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index 7050ce6e2e..08142d64cb 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -3800,8 +3800,8 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows slots are allowed to retain in the pg_wal directory at checkpoint time. If max_slot_wal_keep_size is -1 (the default), replication slots {+may+} retain {+an+} unlimited amount of WAL files. [-If-]{+Otherwise, if+} restart_lsn of a replication slot [-gets-]{+falls+} behind {+by+} more than [-that megabytes-]{+the given size+} from the current LSN, the standby using the slot may no longer be able to continue replication due to removal of required WAL files. You can see the WAL availability of replication slots --HcccYpVZDxQ8hzPO Content-Type: text/x-diff; charset=us-ascii Content-Disposition: attachment; filename="v1-0001-Tweak-user-facing-doc-in-c6550776394e25c1620bc825.patch" From f675c46b25b744dfd17e6139dfb6ab89b28e558f Mon Sep 17 00:00:00 2001 From: Justin Pryzby Date: Sat, 20 Jun 2020 18:03:19 -0500 Subject: [PATCH v1] Tweak user-facing doc in c6550776394e25c1620bc8258427c8f1d448080d --- doc/src/sgml/config.sgml | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index 7050ce6e2e..08142d64cb 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -3800,8 +3800,8 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows slots are allowed to retain in the pg_wal directory at checkpoint time. If max_slot_wal_keep_size is -1 (the default), - replication slots retain unlimited amount of WAL files. If - restart_lsn of a replication slot gets behind more than that megabytes + replication slots may retain an unlimited amount of WAL files. Otherwise, if + restart_lsn of a replication slot falls behind by more than the given size from the current LSN, the standby using the slot may no longer be able to continue replication due to removal of required WAL files. You can see the WAL availability of replication slots -- 2.17.0 --HcccYpVZDxQ8hzPO--