Re: Run maintenance proc

[Sathish Reddy <sathishreddy.postgresql@xxxxxxxxx>]

Thanks, I'll check it out.

On Sat, Oct 19, 2024, 6:25 PM Keith Fiske <keith.fiske@xxxxxxxxxxxxxxx> wrote:

On Thu, Oct 17, 2024, 2:22 PM Sathish Reddy <sathishreddy.postgresql@xxxxxxxxx> 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