postgresql@18

{
  "aliases": [
    "postgres",
    "postgresql"
  ],
  "alternatives": [
    "mysql",
    "mariadb",
    "sqlite",
    "cockroachdb"
  ],
  "build_dependencies": [
    "docbook",
    "docbook-xsl",
    "gettext",
    "pkgconf"
  ],
  "categories": [
    "database",
    "database-client"
  ],
  "caveats": "This formula has created a default database cluster with:\n  initdb --locale=en_US.UTF-8 -E UTF-8 $HOMEBREW_PREFIX/var/postgresql@18\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:47+00:00",
  "first_seen": "2026-06-20T23:34:18+00:00",
  "full_name": "postgresql@18",
  "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": 15139,
  "installs_365d": 95945,
  "installs_90d": 50266,
  "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:43:54+00:00",
  "llm_model": "claude-haiku-4-5",
  "name": "postgresql@18",
  "oldnames": [],
  "one_liner": "PostgreSQL 18 object-relational database server and client tools (keg-only versioned formula).",
  "optional_dependencies": [],
  "rank_30d": 284,
  "rank_365d": 435,
  "rank_90d": 276,
  "raw_hash": "ce7741109e6c437f",
  "recommended_dependencies": [],
  "revision": 0,
  "ruby_source_path": "Formula/p/postgresql@18.rb",
  "tap": "homebrew/core",
  "test_dependencies": [],
  "uses_from_macos": [
    {
      "bison": "build"
    },
    {
      "flex": "build"
    },
    "curl",
    "libxml2",
    "libxslt",
    "openldap",
    "perl"
  ],
  "version_head": null,
  "version_stable": "18.4",
  "versioned_formulae": [
    "postgresql@17",
    "postgresql@16",
    "postgresql@15",
    "postgresql@14",
    "postgresql@13",
    "postgresql@12"
  ],
  "why_use_this": "Install PostgreSQL 18 alongside other major versions without conflict. Use this when you need the latest features or bug fixes but want to keep older PostgreSQL installations intact. Keg-only means you must explicitly reference the binary path or use `brew link --force` to make it default."
}