Обсуждение: Pg_cron

Поиск
Список
Период
Сортировка

Pg_cron

От
Sathish Reddy
Дата:
Hi 
  I have pg_cron created extension on one database but I am trying to schedule job to another database from same database.
Database A 
Database B

I need to do vaccum datbase B from database A using pg_cron.


Help us.


Thanks 
Sathish Reddy 

Re: Pg_cron

От
Rajesh Kumar
Дата:
Did u configure pg_hba local connection as trust?



On Wed, 22 May 2024, 15:27 Sathish Reddy, <sathishreddy.postgresql@gmail.com> wrote:
Hi 
  I have pg_cron created extension on one database but I am trying to schedule job to another database from same database.
Database A 
Database B

I need to do vaccum datbase B from database A using pg_cron.


Help us.


Thanks 
Sathish Reddy 

Re: Pg_cron

От
abbas alizadeh
Дата:
Hi.
With function cron.schedule_in_database you can schedule the job for different databases

Regards
Abbas

> On 22 May 2024, at 1:57 PM, Sathish Reddy <sathishreddy.postgresql@gmail.com> wrote:
>
> 
> Hi
>   I have pg_cron created extension on one database but I am trying to schedule job to another database from same
database.
> Database A
> Database B
>
> I need to do vaccum datbase B from database A using pg_cron.
>
>
> Help us.
>
>
> Thanks
> Sathish Reddy