postgresql@17

brew install postgresql@17 v17.10 PostgreSQL keg-only

PostgreSQL 17: object-relational database server with SQL and procedural language support.

Why you might care

Install this if you need PostgreSQL 17 specifically alongside other major versions; Homebrew keeps it keg-only to avoid conflicts. PostgreSQL is a production-grade relational database with strong ACID guarantees, rich data types, full-text search, JSON operators, and extensibility via stored procedures and custom types. Use it for persistent data storage in web apps, data warehousing, or as a local development replica of production.

Alternatives

MySQL MariaDB SQLite MongoDB

8.8k

30-day installs · #382

33.7k

90-day · #364

131.7k

365-day · #359

Runtime dependencies

icu4c@78 krb5 lz4 openssl@3 readline zstd gettext

Build dependencies

docbook docbook-xsl gettext pkgconf

Caveats

This formula has created a default database cluster with:
  initdb --locale=en_US.UTF-8 -E UTF-8 $HOMEBREW_PREFIX/var/postgresql@17

When uninstalling, some dead symlinks are left behind so you may want to run:
  brew cleanup --prune-prefix

Keg-only reason

:versioned_formula

Blurb generated by claude-haiku-4-5 on today.

Raw metadata

{
  "aliases": [],
  "alternatives": [
    "MySQL",
    "MariaDB",
    "SQLite",
    "MongoDB"
  ],
  "build_dependencies": [
    "docbook",
    "docbook-xsl",
    "gettext",
    "pkgconf"
  ],
  "categories": [
    "database",
    "language-runtime"
  ],
  "caveats": "This formula has created a default database cluster with:\n  initdb --locale=en_US.UTF-8 -E UTF-8 $HOMEBREW_PREFIX/var/postgresql@17\n\nWhen uninstalling, some dead symlinks are left behind so you may want to run:\n  brew cleanup --prune-prefix\n",
  "conflicts_with": [],
  "dependencies": [
    "icu4c@78",
    "krb5",
    "lz4",
    "openssl@3",
    "readline",
    "zstd",
    "gettext"
  ],
  "deprecated": 0,
  "deprecation_reason": null,
  "desc": "Object-relational database system",
  "disable_reason": null,
  "disabled": 0,
  "enrichment_fetched_at": "2026-06-20T23:40:50+00:00",
  "first_seen": "2026-06-20T23:34:18+00:00",
  "full_name": "postgresql@17",
  "github_default_branch": null,
  "github_last_commit_at": null,
  "github_readme_excerpt": null,
  "github_repo": null,
  "github_stars": null,
  "github_topics": [],
  "homepage": "https://www.postgresql.org/",
  "homepage_og_description": "The world\u0027s most advanced open source database.",
  "homepage_og_image": "https://www.postgresql.org/media/img/about/press/elephant.png",
  "homepage_title": "PostgreSQL: The world\u0027s most advanced open source database",
  "installs_30d": 8757,
  "installs_365d": 131658,
  "installs_90d": 33728,
  "keg_only": 1,
  "keg_only_reason": ":versioned_formula",
  "last_seen": "2026-06-20T23:34:18+00:00",
  "license": "PostgreSQL",
  "llm_generated_at": "2026-06-20T23:44:32+00:00",
  "llm_model": "claude-haiku-4-5",
  "name": "postgresql@17",
  "oldnames": [],
  "one_liner": "PostgreSQL 17: object-relational database server with SQL and procedural language support.",
  "optional_dependencies": [],
  "rank_30d": 382,
  "rank_365d": 359,
  "rank_90d": 364,
  "raw_hash": "03756197fd801ad9",
  "recommended_dependencies": [],
  "revision": 0,
  "ruby_source_path": "Formula/p/postgresql@17.rb",
  "tap": "homebrew/core",
  "test_dependencies": [],
  "uses_from_macos": [
    {
      "bison": "build"
    },
    {
      "flex": "build"
    },
    "libxml2",
    "libxslt",
    "openldap",
    "perl"
  ],
  "version_head": null,
  "version_stable": "17.10",
  "versioned_formulae": [
    "postgresql@18",
    "postgresql@16",
    "postgresql@15",
    "postgresql@14",
    "postgresql@13",
    "postgresql@12"
  ],
  "why_use_this": "Install this if you need PostgreSQL 17 specifically alongside other major versions; Homebrew keeps it keg-only to avoid conflicts. PostgreSQL is a production-grade relational database with strong ACID guarantees, rich data types, full-text search, JSON operators, and extensibility via stored procedures and custom types. Use it for persistent data storage in web apps, data warehousing, or as a local development replica of production."
}