| From: | Sathish Reddy <sathishreddy(dot)postgresql(at)gmail(dot)com> |
|---|---|
| To: | Keith Fiske <keith(dot)fiske(at)crunchydata(dot)com> |
| Cc: | pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Run maintenance proc |
| Date: | 2024-10-19 13:08:31 |
| Message-ID: | CA+M9Y+B6-hT9=37M9DQvSb--kgmKwFokP8fKdUnZ=3ZFNUaABA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Thanks, I'll check it out.
On Sat, Oct 19, 2024, 6:25 PM Keith Fiske <keith(dot)fiske(at)crunchydata(dot)com>
wrote:
>
>
> 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
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Murthy Nunna | 2024-10-19 23:45:22 | Verify or dump pgdata files |
| Previous Message | Keith Fiske | 2024-10-19 12:55:03 | Re: Run maintenance proc |