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 1kmH6K-0004yQ-UX for pgsql-admin@arkaria.postgresql.org; Mon, 07 Dec 2020 14:02:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kmH6J-0006Vy-U2 for pgsql-admin@arkaria.postgresql.org; Mon, 07 Dec 2020 14:02:51 +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 1kmH6J-0006Vr-Mt for pgsql-admin@lists.postgresql.org; Mon, 07 Dec 2020 14:02:51 +0000 Received: from mail-ej1-x629.google.com ([2a00:1450:4864:20::629]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kmH6D-0004FT-Ve for pgsql-admin@lists.postgresql.org; Mon, 07 Dec 2020 14:02:50 +0000 Received: by mail-ej1-x629.google.com with SMTP id f23so19646329ejk.2 for ; Mon, 07 Dec 2020 06:02:45 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=Vt9VxPRw45Xhgj1fSbam6W6ILr9UzM0PQ9ebOT/xd4Y=; b=MSOEK0qQcuArzL7P4422AzSzHcPdces0aJkLIqOJ3MRXVII+ESy+6CRkm1oOBdLVKc HFrmlyW1aVSJLfi0iKYKrbozFKt3zTsn9Nd/+zP4TMliyqlW1I+Kr2vuMhN2XRnqtnSq t4xeZfSOje9yHZpaA/GlUuy7DScpjAgOSTwiNx1cPsYNJUndzHAQvyuYPUr0zZ9EgTSC 9MMAUJ69hn8+HdWVMAMweZ2pN2fAlR6Qzt2tvXkigJBtuNoONLsK6kD24afC5KBWd1ms EHhbntXaEHefTttKN0nzuYeEmqVPG1U1QCeRFDDMYNwyOs1BbX2TqieX0J27hkDIj+H1 mCMA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=Vt9VxPRw45Xhgj1fSbam6W6ILr9UzM0PQ9ebOT/xd4Y=; b=b/5eOTQBsLUPmNJ3ckYdJ7ja4XbiiuZ0yZsuHRpeXACPszFPWPjI2pUyGWIhSbkOwp 4HNHCv4OebQapwLvWuh+THw/z4oJ5E0vX13mV5tJvm6V3SegHqUpls3w+jLfM5ji3vkf QGzIF8E+jOGgOH22j9CPkg+6P8c2SXxjL3JhbiA9DlLzLioxJrsme9f3n5I1cziV9Tpv mW81R5iFDIDxlw3JU6bbilfK6QTH3QkeiaRPOqSIv7uahHxH+s0Unu6z5YQsDIE+S1gt aACKBr7DhZRm6ooeYSuVmSeb8+suV/qAhw6/Xp/xAybEnmKurb9myungTm9NAI3M5KpO oZWQ== X-Gm-Message-State: AOAM531JN8GeG3stLskgZ19jbeS62G3NGDsZlURqyJ3t80rKrxM1jv+i 5XKynAet7URrxwl1tREM3u0= X-Google-Smtp-Source: ABdhPJx6AAQa9dpmZJhHjzHu2sweNJ3AgS1sVCyKIk0/AEv/SDLxwsqC/pGa9L65r84omKSFoWAwXQ== X-Received: by 2002:a17:906:1b46:: with SMTP id p6mr19433253ejg.68.1607349754724; Mon, 07 Dec 2020 06:02:34 -0800 (PST) Received: from [192.168.1.8] (241-57-239-77.dyn.cable.fcom.ch. [77.239.57.241]) by smtp.gmail.com with ESMTPSA id s15sm13631775edj.75.2020.12.07.06.02.34 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Mon, 07 Dec 2020 06:02:34 -0800 (PST) Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Mac OS X Mail 14.0 \(3654.20.0.2.21\)) Subject: Re: Archive directory From: =?utf-8?Q?Paul_F=C3=B6rster?= In-Reply-To: <5AAB0FED-45AA-45F6-AFB5-A65A36275492@elevated-dev.com> Date: Mon, 7 Dec 2020 15:02:32 +0100 Cc: Yambu , Ian Lawrence Barwick , Pgsql-admin Content-Transfer-Encoding: quoted-printable Message-Id: <92588443-EB0E-412B-B768-301603D21CCA@gmail.com> References: <5AAB0FED-45AA-45F6-AFB5-A65A36275492@elevated-dev.com> To: Scott Ribe X-Mailer: Apple Mail (2.3654.20.0.2.21) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi Scott, > On 07. Dec, 2020, at 14:53, Scott Ribe = wrote: >=20 > The point of the archive command is to copy to the replica. If you're = archiving on master, then using some script to copy to replica, then = postgres has no way to know when it is safe to delete WAL files. in my understanding, this is only true if you don't use replication = slots. If you use replication slots then the primary should know when a = WAL file is no longer needed and abandoned or ready to be recycled. Cheers, Paul=