From: | Sathish Reddy <sathishreddy(dot)postgresql(at)gmail(dot)com> |
---|---|
To: | keith(dot)fiske(at)crunchydata(dot)com |
Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: Detach partition concurrently from pg cron |
Date: | 2024-07-09 04:24:42 |
Message-ID: | CA+M9Y+Ao9LwwGifGibAT4aQH5f2HVpMfyQzOyD8XV+GKS8Y1NA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Thanks for the advice.please help me on configure pg_cron schedule job
trigger from postgres database to another database will run job
Thanks
Sathish Reddy
On Mon, Jul 8, 2024, 6:46 PM Keith Fiske <keith(dot)fiske(at)crunchydata(dot)com>
wrote:
> On Mon, Jul 8, 2024 at 5:43 AM Sathish Reddy <
> sathishreddy(dot)postgresql(at)gmail(dot)com> wrote:
>
>> Hi
>> Please help me on partman detach partition concurrently using pg cron
>> run from postgres database to another database in detail.
>>
>> Thanks
>> Sathish Reddy
>>
>
> Concurrent detach is not possible with pg_partman at this time. No
> concurrent operations can be called within a function's transaction block.
>
> See this issue for more information -
> https://github.com/pgpartman/pg_partman/issues/387
>
> If you need to detach concurrently, you will have to use some separate
> process to do it at this time. Not sure if that can be done with pg_cron
> since I'm not sure if that is also doing its own calls within a functional
> transaction.
>
> --
> Keith Fiske
> Senior Database Engineer
> Crunchy Data - http://crunchydata.com
>
From | Date | Subject | |
---|---|---|---|
Next Message | srinivasan s | 2024-07-09 06:01:04 | Re: Detach partition concurrently from pg cron |
Previous Message | niraj nandane | 2024-07-09 03:16:06 | Re: How to restrict schema size per tenant |