Is it possible to use the pg_cron extension on PostgreSQL at Koyeb?

General
1

I would like to use something like CRON for running some SQL functions. Is pg_cron available with PostgreSQL at Koyeb? If so could you point me in the direction of which documentation I can follow to get it going please? If not, which alternatives are available?

Thanks in advance.

2

Hi @Mark_Howell,

Unfortunately, pg_cron is not available :frowning:

3

Hi @Lukasz_Oles

Thanks for the confirmation. What alternatives do you have available that can manage scheduled execution of PostgreSQL functions?

4

Hi @Lukasz_Oles

I think I will go down the route of using Github Actions to create a cron style schedule, which will then trigger the job i need to run via the koyeb api service.

Something that others may have already done.

Kind regards,

Mark

5

Please let us know if it worked for you!

6

As mentioned in the above post, I have managed to trigger a PostgreSQL function via REST a few times per hour by creating a Github Action with the following included in the YAML:

schedule:

  • cron: ‘*/15 * * * *’

This works without authentication. I just need to tidy that bit once your new functionality for authenticated endpoints is available.