How to use PostgresSQL Cron Plugin?
Hey guys! I need to schedule a function to run every day that updates a table based on the current timestamp.
How can i add pg_cron with Railway?
Solution:Jump to solution
@marcobranco you would need to build an image that has the pg_cron extension installed
use this repo as a base https://github.com/railwayapp-templates/postgres-ssl
these are the install instructions https://github.com/citusdata/pg_cron#installing-pg_cron
you would need to modify the latest dockerfile...
10 Replies
Project ID:
N/AN/A
I recommend taking a peak at this:
https://docs.railway.app/reference/cron-jobs
fragly
oh no <:e_guh:1082624029971726356>
why are your emojis so funny
<:SH_yesmirk:964456386425667618>
idk, thank you though
Solution
@marcobranco you would need to build an image that has the pg_cron extension installed
use this repo as a base https://github.com/railwayapp-templates/postgres-ssl
these are the install instructions https://github.com/citusdata/pg_cron#installing-pg_cron
you would need to modify the latest dockerfile
damn I completely missed the mark on that one
maybe