We have a PostgreSQL cluster that we want to back up to Google Cloud Storage on a schedule. I’m planning on creating a Cloud Function that runs on a schedule.

Because our databases aren’t stored on Google Cloud, I can’t use this guide that Google has published. And since pg_dump has to be installed on the system to be available, that isn’t an option in Cloud Functions either.

What options do I have? Is it possible to use something like psycopg2 in Python or pg in Node.js?