Sign inSign up

qonicsinc/postgres-pgcron

By qonicsinc

•Updated about 1 year ago

PostgreSQL with built-in pg_cron and pg_partman for reliable scheduling and automated partitioning.

Image
Databases & storage
0

9.3K

qonicsinc/postgres-pgcron repository overview

⁠Docker Hub Description Summary

⁠Short Description (for Docker Hub)

PostgreSQL 17.5 with pg_cron scheduler and pg_partman auto-partitioning. Production-ready with optimized configuration.

⁠Full Description (for Docker Hub Overview)

🐘 PostgreSQL 17.5 with pg_cron & pg_partman

Production-ready PostgreSQL image with essential extensions for modern applications:

āœ… pg_cron 1.6 - Schedule SQL commands directly from PostgreSQL
āœ… pg_partman 5.2.4 - Automated table partitioning for large datasets
āœ… Enhanced Security - SCRAM-SHA-256 authentication by default
āœ… Performance Optimized - Tuned for containerized environments

⁠Quick Start

docker run -d --name postgres-app \
  -e POSTGRES_PASSWORD=your_secure_password \
  -e POSTGRES_DB=your_database \
  -p 5432:5432 \
  qonicsinc/postgres-pgcron:17.5

⁠Perfect For

  • Data Archival: Automatic partition and cleanup of old data
  • ETL Pipelines: Schedule data transformation jobs
  • Analytics: Partition large fact tables for better performance
  • Log Management: Automated log rotation and cleanup
  • Time-series Data: Efficient storage and querying of temporal data

⁠Key Features

  • Production-ready security configuration
  • Optimized PostgreSQL settings for containers
  • Health checks and comprehensive logging
  • Easy integration with existing applications
  • Full compatibility with official PostgreSQL image

⁠Extensions Included

ExtensionVersionPurpose
pg_cron1.6PostgreSQL job scheduler
pg_partman5.2.4Automated table partitioning

See the README for detailed examples, Kubernetes deployments, and production configurations.

⁠Tags

  • 17.5, latest - PostgreSQL 17.5 with pg_cron 1.6 and pg_partman 5.2.4

Tag summary

Content type

Image

Digest

sha256:b2865268c…

Size

166.3 MB

Last updated

about 1 year ago

docker pull qonicsinc/postgres-pgcron