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 1qSRsp-005p3F-H1 for pgsql-admin@arkaria.postgresql.org; Sun, 06 Aug 2023 00:44:35 +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 1qSRsn-001z7O-Mo for pgsql-admin@arkaria.postgresql.org; Sun, 06 Aug 2023 00:44:34 +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 1qSRsn-001z7F-Bk for pgsql-admin@lists.postgresql.org; Sun, 06 Aug 2023 00:44:33 +0000 Received: from mail-yb1-xb2b.google.com ([2607:f8b0:4864:20::b2b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qSRsl-000l8B-20 for pgsql-admin@lists.postgresql.org; Sun, 06 Aug 2023 00:44:32 +0000 Received: by mail-yb1-xb2b.google.com with SMTP id 3f1490d57ef6-d45caf42d73so1665048276.2 for ; Sat, 05 Aug 2023 17:44:30 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1691282669; x=1691887469; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:from:to:cc:subject:date:message-id :reply-to; bh=fc2D6Js/LSPzVuEC99dZy3W2Ji0DrNk+PN7U0Q4ROQI=; b=JtlZ/cf3F3xtAxyOUxbA3RlLLiBQIs4jM0pV+UEl6V3X3AcZ18vq8nwGkWOsfmFbby FZCBlwDhTVD+Cp8ZWlj6zgaWh+BIBYfQpWYAQWMrWq8pIeiMNmdpi7kFfax2rCNgGRA2 Roitt2lOZP7KGMu0gL37MwJr3C84uniK/leT7je1UgLHnBBxLhZbgprQiCGZFbmx1VKc WZxVmiWIiPEUVKpra43nkgNIoVFfZYNNJ/ep4AqYk9BFNzDJBGQdw0HctQWKEl0qzHg3 F00A5pcKVBjUqtcSUFYkKHc4wanyPrzRRSjlTW5CuxlXT/2w4fpKm5ycgxXYbXuDBYhr n/MA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1691282669; x=1691887469; h=in-reply-to:from:references: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=fc2D6Js/LSPzVuEC99dZy3W2Ji0DrNk+PN7U0Q4ROQI=; b=RlQ95JJgqb2EHDEcFTVTOgVZgEp685rKWtKe2FqDVHgY32lQvaHgdK2enNqM9sNIjO 7CRzMeJi9icKsErhqRYbAbk4PfIrC04IZr//y2U9c5KU7dmX/2btFhxWPIGQr73FGRlD PbqF45L7nI/kQbRfL8OgNXUaIjtduhMrQyUgGZ9zGVuCTBORVTvMYJQwzbYtm2mX3TQO N10l6s0/4Bd0pM3Kgwr/YaeDXmNxew34VNMhxZtrQjYvvCiPbgduzJrKZjI5YNsP2KUa 8CzUm+p7JCM9jyugwSjo4Xgw/nF1sOBIFyKbDzUGGxT/uhZN9JgOFqzItZhodak4Hu+p zNjw== X-Gm-Message-State: AOJu0Yz+0kEVh+gEajVKmpkoo+QKLBnGdxMRWoDUQUG/JmOUicuDfxZe 5GpGfdPuKJVRVbIoOV3rLqxtUPB74BM= X-Google-Smtp-Source: AGHT+IGnUAt4AvxKyRqpTwl9VrcL9wlGuyFIodamoWcjmBTz4q/PkjiZOd8jfsGWNGG1vHoCbiCYrg== X-Received: by 2002:a25:cfc6:0:b0:d4b:e4f4:cb0e with SMTP id f189-20020a25cfc6000000b00d4be4f4cb0emr2713014ybg.22.1691282669366; Sat, 05 Aug 2023 17:44:29 -0700 (PDT) Received: from ?IPV6:2600:1700:bd2c:b810:9444:c670:2c09:c643? ([2600:1700:bd2c:b810:9444:c670:2c09:c643]) by smtp.googlemail.com with ESMTPSA id i9-20020a5b0c89000000b00cad44e2417esm1514489ybq.64.2023.08.05.17.44.29 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sat, 05 Aug 2023 17:44:29 -0700 (PDT) Content-Type: multipart/alternative; boundary="------------ssLjykReNofEd3xxGVRA6ekM" Message-ID: <11b4adf7-9b46-a3b5-e18f-2cc38adc6116@gmail.com> Date: Sat, 5 Aug 2023 19:44:28 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.11.0 Subject: Re: Archive cleanup Content-Language: en-US To: pgsql-admin@lists.postgresql.org References: From: Ron In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------ssLjykReNofEd3xxGVRA6ekM Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit Use PgBackRest, and make your life a *lot* easier. On 8/5/23 19:36, Rajesh Kumar wrote: > Archive is must for point in time recovery right? > > On Fri, 4 Aug 2023 at 06:48, Jeff Janes wrote: > > On Fri, Aug 4, 2023 at 5:04 AM Rajesh Kumar > wrote: > > Hi friends, > > Anybody let me know how to automate the archive clean up in postgres. > > > If the only reason you have an archive is so a standby can get the > WAL, then you can just use a slot instead.  If you don't have an > archive, you don't need to clean it up. > > If you are using the archive for something else, you would need to > tell us what that is.  Otherwise, you are just asking "how long is a > piece of string"? > > Cheers, > > Jeff > -- Born in Arizona, moved to Babylonia. --------------ssLjykReNofEd3xxGVRA6ekM Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit Use PgBackRest, and make your life a lot easier.

On 8/5/23 19:36, Rajesh Kumar wrote:
Archive is must for point in time recovery right?

On Fri, 4 Aug 2023 at 06:48, Jeff Janes <jeff.janes@gmail.com> wrote:
On Fri, Aug 4, 2023 at 5:04 AM Rajesh Kumar <rajeshkumar.dba09@gmail.com> wrote:
Hi friends,

Anybody let me know how to automate the archive clean up in postgres.

If the only reason you have an archive is so a standby can get the WAL, then you can just use a slot instead.  If you don't have an archive, you don't need to clean it up.

If you are using the archive for something else, you would need to tell us what that is.  Otherwise, you are just asking "how long is a piece of string"?

Cheers,

Jeff

--
Born in Arizona, moved to Babylonia.
--------------ssLjykReNofEd3xxGVRA6ekM--