← Directory

PostgreSQL with pg_cron

PostgreSQL with pg_cron is an OSS Apps Docker image of PostgreSQL, the open-source object-relational database, preconfigured with the pg_cron extension.

  • Network Services
  • Productivity
  • Tools & Utilities
PostgreSQL with pg_cron is an OSS Apps Docker image of PostgreSQL, the open-source object-relational database, preconfigured with the pg_cron extension. It lets you schedule recurring SQL jobs such as backups and maintenance directly inside the database, removing the need for an external cron setup.

Platform availability

Available on 1 of 9 platforms

  • Unraid
  • TrueNAS (not listed)
  • Umbrel (not listed)
  • ZimaOS (not listed)
  • Proxmox (not listed)
  • Helm (not listed)
  • Mac (not listed)
  • Windows (not listed)
  • Linux (not listed)

Health score?A 0-100 score computed nightly from four factors: maintained (40%: recent commits and steady activity), popular (25%: GitHub stars, log scale), easy to install (20%: platforms, install notes, setup guides, Docker image) and light to run (15%: minimum RAM, ARM support). When the source code has been checked, a fifth factor, security check (20%: automated scan for committed secrets, unsafe desktop-app settings, known-vulnerable dependencies and project hygiene; any serious finding caps it at 20), is added. Factors without data are left out and the rest are rescaled.

46/100 Fair

Maintained
No data
Popular
No data
Easy to install
351 install platform, install notes, Docker image
Light to run
602 GB minimum RAM, runs on ARM

Based on 2 of 4 factors.

Availability: platform listings confirmed today, links checked 4 days ago

No GitHub repository data collected yet.

Resources & Compatibility

Minimum requirements: 2 GB RAM. ARM (e.g. Raspberry Pi) is supported.

Checked 16 days ago - source: Docker Hub image tags and published docs

First-install notes

  • Create postgres user and data folder Create a dedicated postgres account and a data folder owned by that account before initializing PostgreSQL. If the folder is owned by the wrong user, PostgreSQL can fail to start or write data because of permission errors. source
  • Initialize the database before starting it Run initdb (the command that creates the database files) against that data folder before starting the server. Without this, PostgreSQL has no database to load, so the server will not start. source
  • Start Postgres as postgres, not root Use the postgres account when running pg_ctl (the PostgreSQL start/stop helper) to start the server. Starting as root can create root-owned data files and is less secure, which can cause later permission problems. source

Fetched 16 days ago - each note links to its source

Alternatives (12)

  • Apache Cassandra
  • CockroachDB - CockroachDB is a distributed SQL database for developers and operators of transactional applications that need horizontal scaling and resil…
  • CouchDB - Apache CouchDB is a document database that stores JSON data and speaks HTTP, with built-in replication, change tracking, and flexible views…
  • FerretDB - FerretDB is an open-source MongoDB compatibility proxy for self-hosted stacks.
  • Firebird - Firebird is a relational database offering many ANSI SQL-92 features that runs on Linux, Windows, and a variety of Unix platforms.
  • Microsoft SQL Server - SQL Server delivers on Microsoft’s Data Platform vision by helping your organization manage your data by enabling you to store data from st…
  • MongoDB - MongoDB is a cross-platform, open-source document-oriented NoSQL database that stores data in flexible, JSON-like BSON documents instead of…
  • MySQL Community Edition - Free GPL database platform supporting SQL and NoSQL applications with InnoDB storage, replication, clustering, connectors, and cross-platfo…
  • SQLite - SQLite is a lightweight, embedded relational database engine that stores an entire database in a single file on your device.
  • SurrealDB - SurrealDB is a modern "all-in-one" database that stores and organises your app's information.
  • mariadb - MariaDB is a fast, open-source relational database server forked from MySQL by its original developers.
  • rethinkdb - RethinkDB is an open-source, distributed NoSQL database built for realtime web applications.

Checked 3 days ago - source: AlternativeTo

Common questions

Does pg_cron need special handling when using Postgres in Docker?

pg_cron is not included in the default Postgres Docker image. You usually need to extend the image or adjust docker-compose to install and use it.

What data-directory permission issue can prevent PostgreSQL from starting?

Create a dedicated postgres account and a data folder owned by that account before initializing PostgreSQL. If the folder is owned by the wrong user, PostgreSQL can fail to start or write data because of permission errors.

Can I start PostgreSQL as root in a self-hosted setup?

Use the postgres account when running pg_ctl to start the server. Starting as root can create root-owned data files and is less secure, which can cause later permission problems.

What ongoing operations am I responsible for when self-hosting PostgreSQL?

You become fully accountable for backups, downtime, and patching. You should verify that you can actually restore from your backups.

Answers sourced from stackoverflow.com, www.postgresql.org, www.postgresql.org, www.reddit.com

Community

Collected 10 days ago - public community threads