# postgres/postgres

Mirror of the official PostgreSQL GIT repository. Note that this is just a *mirror* - we don't work with pull requests on github. To contribute, please see https://wiki.postgresql.org/wiki/Submitting_a_Patch

Repository: https://github.com/postgres/postgres
Canonical: https://ross.abutalabs.com/products/postgres
Homepage: https://www.postgresql.org/
Language: C
License: NOASSERTION
License Family: other
Last push: 2026-08-26T21:57:03+00:00

## Health v2 (maintenance only)
Score: 77/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 99, release rhythm 35, longevity 100
- inputs: {"age_days": 5825, "days_push": 7, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: no_releases, no_license
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 21906, forks 5874 (observed 2026-08-28T04:11:32.180379+00:00)

## What it is
PostgreSQL is a mature, open source object-relational database management system supporting an extended subset of the SQL standard, including transactions, foreign keys, triggers, user-defined types, and extensibility via extensions like PostGIS. This repository is a read-only GitHub mirror of the official PostgreSQL git repository; contributions go through the PostgreSQL community process, not pull requests.

## Use cases
- self-host a relational database for my web application
- store and query JSON documents alongside relational data
- run ACID-compliant transactions for financial data
- add geospatial queries with PostGIS
- set up replication and backups for a production database
- build from source to develop database extensions

## When to choose
- you need a reliable, feature-rich open source relational database with strong SQL standards conformance
- you need advanced features like partitioning, materialized views, full-text search, or custom data types
- you want a database that runs on all major operating systems with decades of proven stability

## When to avoid
- you want to contribute code via GitHub pull requests - this is a mirror only
- you need a lightweight embedded database for a small single-user app
- you prefer a managed NoSQL document store without SQL

## Facets
- artifact type: application
- maturity: stable
- function: database, search-engine, json, security, backup, concurrency
- domain: databases, backend, developer-tools
- platform: windows, bsd, cross-platform, self-hosted, c
- tags: postgresql, sql, relational-database, acid, object-relational, mirror-repository, extensible, data-engineering, linux, macos

## Member repositories
- postgres/postgres (main) score 77

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:11:32.180379+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-29T16:57:45.997548+00:00, confidence not recorded.
  - readme: https://github.com/postgres/postgres (fetched 2026-08-28T04:11:32.180379+00:00, sha f8f3f3b5e7f5)
  - homepage: https://www.postgresql.org/ (fetched 2026-08-29T07:56:57.220540+00:00, sha 313f58dfcdda)
  - site_page: https://www.postgresql.org/about (fetched 2026-08-29T07:56:57.229909+00:00, sha 6ad46101240f)
  - site_page: https://www.postgresql.org/docs (fetched 2026-08-29T07:56:57.232096+00:00, sha d4083e7b1fe0)
  - site_page: https://www.postgresql.org/about/donate (fetched 2026-08-29T07:56:57.233912+00:00, sha b7ae9a39b6ac)
  - site_page: https://www.postgresql.org/about/news/postgresql-186-1711-1615-1519-1424-and-19-beta-3-released-3365 (fetched 2026-08-29T07:56:57.235769+00:00, sha 037924039baf)
  - site_page: https://www.postgresql.org/about/featurematrix (fetched 2026-08-29T07:56:57.240161+00:00, sha bf2d2661be16)
  - site_page: https://www.postgresql.org/about/governance (fetched 2026-08-29T07:56:57.242316+00:00, sha 458a08f53644)
  - site_page: https://www.postgresql.org/docs/release (fetched 2026-08-29T07:56:57.244203+00:00, sha 1ab4547b62e9)
  - site_page: https://www.postgresql.org/download (fetched 2026-08-29T07:56:57.238360+00:00, sha 8173f6c84c98)
- Data as of 2026-08-30T08:39:29.467469+00:00.