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 1t290O-0029eA-AC for pgsql-admin@arkaria.postgresql.org; Sat, 19 Oct 2024 12:56:28 +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 1t28zM-002WhU-Sq for pgsql-admin@arkaria.postgresql.org; Sat, 19 Oct 2024 12:55:25 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t28zM-002WhM-GA for pgsql-admin@lists.postgresql.org; Sat, 19 Oct 2024 12:55:24 +0000 Received: from mail-oo1-xc2e.google.com ([2607:f8b0:4864:20::c2e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1t28zF-001tzi-HK for pgsql-admin@lists.postgresql.org; Sat, 19 Oct 2024 12:55:23 +0000 Received: by mail-oo1-xc2e.google.com with SMTP id 006d021491bc7-5eb9ee4f14cso331857eaf.1 for ; Sat, 19 Oct 2024 05:55:17 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=crunchydata.com; s=google; t=1729342515; x=1729947315; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=BIr9K8YX/j0sTJ9XZxCNUxNud3xwfD3bEy3u6y8tlLg=; b=pmLolEoARBWzWZAw1Xy6wWtWKkTBYn53rALHpubZioeVkfspDMC6NDUJA4B4yQNLk9 jDDl9yy+8/zM/m254UJSeTRUOsUh02htt3otGnFt4JCzu8pPAua+auW+w81pRCLzu3vK LOL8i1uE7rNFwW7lG/E16OfJ5GPi87+uk42yHyqFcd/DGbPPvOvgrVCsUy51RVJyHXuq peHuwfhCJulHF/VYPR4CPDo0JkL+1HEp6SxANo5UIspz5TOun+AYuUNFQId5v3wuYYxf aA7vrzJDCK41k8zMay8AZh+TUiYk3MjIliNL+oDFCgx+XxRQMLI/m0f/T3NR2nzSNejV wAuA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1729342515; x=1729947315; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=BIr9K8YX/j0sTJ9XZxCNUxNud3xwfD3bEy3u6y8tlLg=; b=BzURh56gSG7Oz1fwMWPE8z4so8HqU5O6XY4Gjtp2pWAFRqVPQ2gEOleMkNqYpxizaf uFdBvIZTDhUSv35WtDNVJSa/ADe2/ED0d7q3KumqJkGxvLConny93UI7an8MyzfGxyHc 69jtcTevYN4ubedyP4GSjecwGvEoSAYFZEQJYTL2Mx7nZ+mK6oD5CCyEL+Ia0dVAaINT WlsFf0yPjY3LE/SeKuK5xsA61yssnTwqhTNVWrr5A9KxGFeToa2Wsqp2l4eLz3FK2YuK wSYYA4PhgRQ4qUpJxtD8W7kCYpUhOsH817sfBzsPoe/Y+sGzh2p2dOI1sGo9niWMBSMJ +svw== X-Gm-Message-State: AOJu0YysB+CvlXHwP/OV6LZofs1j5YgKyh9yZks0YP319YFuVpO+WJBx hUAFbCVb6mzAaDKHSXd5cxet0QhnWJDrGZ4DfaNuTXuWc+YnLIntZNhX/cuXO+OqE2pF+323Qy7 nlpDxzYS+u/nFHIAd+AZ1l9OomL/ZRmtUqwuTzg== X-Google-Smtp-Source: AGHT+IFk+jYAvqw9XD4pjF3AFIQ8vi2xhRXWQLibAyxB5eOf4M+K/yw3JqtAxQ1l9eXaFCvHa1KBQnJFbA6sF9FnsTA= X-Received: by 2002:a05:6820:151a:b0:5eb:64ca:f6ef with SMTP id 006d021491bc7-5eb8b4b0c3fmr3875644eaf.2.1729342514892; Sat, 19 Oct 2024 05:55:14 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Keith Fiske Date: Sat, 19 Oct 2024 08:55:03 -0400 Message-ID: Subject: Re: Run maintenance proc To: Sathish Reddy Cc: pgsql-admin Content-Type: multipart/alternative; boundary="0000000000004baa180624d3eed3" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000004baa180624d3eed3 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Thu, Oct 17, 2024, 2:22=E2=80=AFPM Sathish Reddy < sathishreddy.postgresql@gmail.com> wrote: > Hi > > .. please help on below one > Automate partition maintenance on postgres without any script on primary > detach 3months partition at same time 4 months partition detach partition > from replica on postgres rds. > > Thanks > Sathish Reddy > Take a look at the pg_partman extension. It automates new child table creation for time-based partitioning and can set retention rules as well https://github.com/pgpartman/pg_partman/ Keith --0000000000004baa180624d3eed3 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


On Thu, Oct 17, 2024, 2:22=E2=80=AFPM Sathish Reddy &l= t;sathishreddy.postgre= sql@gmail.com> wrote:
Hi=C2=A0

=C2=A0.. = please help on below one=C2=A0
Automate partition ma= intenance on postgres without any script on primary detach 3months partitio= n at same time 4 months partition detach partition from replica on postgres= rds.

Thanks=C2=A0
=
Sathish Reddy


Take a look at the pg_partman extension. It automates new c= hild table creation for time-based partitioning and can set retention rules= as well



--0000000000004baa180624d3eed3--