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 1t29CN-002As3-AB for pgsql-admin@arkaria.postgresql.org; Sat, 19 Oct 2024 13:08:51 +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 1t29CL-002i3J-5C for pgsql-admin@arkaria.postgresql.org; Sat, 19 Oct 2024 13:08:49 +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 1t29CK-002i3B-OO for pgsql-admin@lists.postgresql.org; Sat, 19 Oct 2024 13:08:49 +0000 Received: from mail-oo1-xc2f.google.com ([2607:f8b0:4864:20::c2f]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1t29CI-001u4n-2v for pgsql-admin@lists.postgresql.org; Sat, 19 Oct 2024 13:08:48 +0000 Received: by mail-oo1-xc2f.google.com with SMTP id 006d021491bc7-5eb7e19de4aso1247942eaf.1 for ; Sat, 19 Oct 2024 06:08:45 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1729343324; x=1729948124; 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=VSCEcUmmCyjg5cCZfWv5O1XD+ETIOCbXB8Sho9+zcBQ=; b=R7DPq9f4ZViQH3j0i4AQ2XEA0xjtSK7fPjevB29wqyDlqgPxUfkxr6RRyBc3ACsUdw DnwPQ0TJsj7hUUSgc6rU5N4lgXnvq78SR9wuA9Dic6D1oYSYmyW2XCHhPYzZ3QqK6MN6 gpKZZE0LhPh8RvZCnTI0g4kKYjwP0bifrzyZXMIy+0fyO7IyeF9Mk9lQjq7wgtQFg2ad PnLu8l8SD/QU2AX1/CTEzsmkJx5peY9rXfF654mpbuzXXWBmF4CN22OsCoJTjFj0+tGe X7QqiDR8pB0uwI5s4n4e2b1sqFqR5p//lTKp0HgDAFByJxCOZvkm0NFO42CpYWz3or+l 0lUw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1729343324; x=1729948124; 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=VSCEcUmmCyjg5cCZfWv5O1XD+ETIOCbXB8Sho9+zcBQ=; b=L5ymFOdGnAEilXEq4N/hy24bTu7Ov3tqgU5/m9erh/3aaRJIMez46917WIMqGn5Mlr pn5yIrchHufR5AppNEzYFb7lsKBRoecFjgNYzEpPqp0ha0EvZYkE8Dzxgd64bL7JuVeo kLnN+EsMVb8iht+roq9N1jRKAi3qL1gHKAs2P0jVqEQMGp0aZ+wjdCRCdjrjHKOPqvKs 44LFXUnuzPpo32qO1E1jDmQ8ftN+GUHLTHKg12Leon/XmV7Nc9EPbnnO2Snm87QYyavS 7rKgSaNcRZQJGSizzWizTv0VUoOvz/JtH6l9cWveYaTH9kDysdwSpFAQ7khQ+jVeZknw rRkg== X-Gm-Message-State: AOJu0YzDgVqEAViBoCdAK711ofyJ2cj28Q/ZQYe7C+/RpXUz1GmpRQtb MlJ5nQmxT4hg2A6H3RP+1AoYTo5zbtlfJHF2UY7lyxAnQ8Km2QokdPdEtVTvUFAlBZIJNRGn3B5 ZYwgB0HcS5Qf109XKLwqsV3rQj2c= X-Google-Smtp-Source: AGHT+IGYNtylGys0QKcStOD66XPmvAGkrP5PsKZsviEiAAr4AQpaSbY2ZRYtsqETxaHnefg8VpxBAtG0v6Qzz9VNLQk= X-Received: by 2002:a05:6820:82c:b0:5e7:aeed:97be with SMTP id 006d021491bc7-5eb8b7e4073mr4141599eaf.8.1729343324275; Sat, 19 Oct 2024 06:08:44 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Sathish Reddy Date: Sat, 19 Oct 2024 18:38:31 +0530 Message-ID: Subject: Re: Run maintenance proc To: Keith Fiske Cc: pgsql-admin Content-Type: multipart/alternative; boundary="00000000000089cc9d0624d41e18" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000089cc9d0624d41e18 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Thanks, I'll check it out. On Sat, Oct 19, 2024, 6:25=E2=80=AFPM Keith Fiske wrote: > > > 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 partitio= n >> 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 > > --00000000000089cc9d0624d41e18 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

Thanks, I'll check it out.


On Sat= , Oct 19, 2024, 6:25=E2=80=AFPM Keith Fiske <keith.fiske@crunchydata.com> wrote:


On Thu, Oct 17, 2024, 2:22= =E2=80=AFPM Sathish Reddy <sathishreddy.postgresql@gmail.= com> wrote:
Hi=C2=A0

=C2=A0.. please hel= p on below one=C2=A0
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=C2=A0
Sathish Reddy


Take a look at the pg_partman extension. It automates new child t= able creation for time-based partitioning and can set retention rules as we= ll


Keith

--00000000000089cc9d0624d41e18--