Re: Run maintenance proc - Mailing list pgsql-admin

From Keith Fiske
Subject Re: Run maintenance proc
Date
Msg-id CAODZiv4-OdJm_CO_OY_kpzTs7J1=nkcJgUOx90yi_=TZHL33ug@mail.gmail.com
Whole thread Raw
In response to Run maintenance proc  (Sathish Reddy <sathishreddy.postgresql@gmail.com>)
Responses Re: Run maintenance proc
List pgsql-admin


On Thu, Oct 17, 2024, 2:22 PM 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


Keith

pgsql-admin by date:

Previous
From: SOzcn
Date:
Subject: Re: Run maintenance proc
Next
From: Sathish Reddy
Date:
Subject: Re: Run maintenance proc