Re: Run maintenance proc

From: Keith Fiske <keith(dot)fiske(at)crunchydata(dot)com>
To: Sathish Reddy <sathishreddy(dot)postgresql(at)gmail(dot)com>
Cc: pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Run maintenance proc
Date: 2024-10-19 12:55:03
Message-ID: CAODZiv4-OdJm_CO_OY_kpzTs7J1=nkcJgUOx90yi_=TZHL33ug@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, Oct 17, 2024, 2:22 PM Sathish Reddy <
sathishreddy(dot)postgresql(at)gmail(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Sathish Reddy 2024-10-19 13:08:31 Re: Run maintenance proc
Previous Message SOzcn 2024-10-19 08:25:38 Re: Run maintenance proc