# Aiven-Open/pghoard

PostgreSQL® backup and restore service

Repository: https://github.com/Aiven-Open/pghoard
Canonical: https://ross.abutalabs.com/products/pghoard
Homepage: http://aiven-open.github.io/pghoard/
Language: Python
License: Apache-2.0
License Family: permissive
Topics: postgresql, backup, restore, cloud-object-storage, aiven
Last push: 2026-08-20T20:58:32+00:00

## Health v2 (maintenance only)
Score: 93/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 98, release rhythm 83, longevity 100
- inputs: {"age_days": 4095, "days_push": 13, "days_rel": 34, "gap_med": 37, "n_releases_24m": 4}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1421, forks 112 (observed 2026-08-28T04:04:40.706464+00:00)

## What it is
PGHoard is a PostgreSQL backup daemon and restore tooling that continuously stores basebackups and WAL transaction logs in cloud object stores like S3, Azure, Google Cloud, and Ceph. It supports point-in-time recovery, encryption, parallel compression, and automatic retention cleanup.

## Use cases
- back up postgresql to s3
- set up point-in-time recovery for postgres
- continuous wal archiving to cloud storage
- restore a postgres database from object storage
- create a standby replica from backups
- encrypted postgres backups with retention policy

## When to choose
- you need automated, continuous PostgreSQL backups to cloud object storage
- you require point-in-time recovery or standby provisioning from backups
- you want encrypted, compressed backups with monitoring hooks and self-healing retries

## When to avoid
- you only need simple logical dumps (pg_dump) on a cron job
- you use a database other than PostgreSQL
- you prefer a fully managed backup service rather than running your own daemon

## Facets
- artifact type: service
- maturity: active
- function: backup, cryptography, compression, monitoring, alerting, caching
- domain: databases, self-hosted, cloud-computing
- platform: python, self-hosted, cloud
- tags: postgresql, wal-archiving, point-in-time-recovery, object-storage, disaster-recovery, basebackup, pitr, devops, data-engineering, linux, docker

## Member repositories
- Aiven-Open/pghoard (main) score 93

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:04:40.706464+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T04:37:43.439988+00:00, confidence not recorded.
  - readme: https://github.com/Aiven-Open/pghoard (fetched 2026-08-28T04:04:40.706464+00:00, sha b4b3435d47ef)
  - homepage: http://aiven-open.github.io/pghoard/ (fetched 2026-08-29T11:49:52.150083+00:00, sha d4f1c008c206)
- Data as of 2026-08-30T08:39:29.467469+00:00.