Cloud SQL Postgres是否有任何类似cron的工具? [英] Does Cloud SQL Postgres have any cron-like tool?

问题描述

我想将Cloud SQL与PostgreSQL一起使用内部类似cron的工具.在扩展列表中，找不到类似的东西.

I would like to use Cloud SQL with PostgreSQL with an internal cron-like tool. In the extensions list I can't find anything like that.

您是否知道任何解决方案/替代方案，其中不包括我们可以进行呼叫的额外Compute Engine实例?

Do you know any solution/alternative which wouldn't include having an extra Compute Engine instance from where we can make calls ?

推荐答案

您不能在Cloud SQL内部运行cron，因为它是

You can't run cron internally in Cloud SQL as it is fully managed and you only get the access to the database itself.

如果您需要运行此插入内容并选择每分钟，则可以使用

If you need to run this inserts and selects each minute then you can use Google's Task queues to send a request to an App Engine service that will do all that.

cron:
    - description: "make some select/insert"
      url: /tasks/populate
      schedule: every 1 mins
      target: populate_postgres

您每天有每天有28个免费实例小时可以用于App Engine实例.

You have 28 free instance hours a day to use with App Engine instances.

这篇关于Cloud SQL Postgres是否有任何类似cron的工具?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！