Postgres Pro
Downloads
Home   >   mailing lists

Re: Run maintenance proc - Mailing list pgsql-admin

From Sathish Reddy
Subject Re: Run maintenance proc
Date
Msg-id CA+M9Y+B6-hT9=37M9DQvSb--kgmKwFokP8fKdUnZ=3ZFNUaABA@mail.gmail.com
Whole thread Raw
In response to Re: Run maintenance proc  (Keith Fiske <keith.fiske@crunchydata.com>)
List pgsql-admin
Tree view

Thanks, I'll check it out.

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


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: Keith Fiske
Date:
Subject: Re: Run maintenance proc
Next
From: Murthy Nunna
Date:
Subject: Verify or dump pgdata files