GET /api/v1/ports/?format=api&ordering=-updated_at&page=675
HTTP 200 OK
Allow: GET, HEAD, OPTIONS
Content-Type: application/json
Vary: Accept

{
    "count": 51892,
    "next": "https://ports.macports.org/api/v1/ports/?format=api&ordering=-updated_at&page=676",
    "previous": "https://ports.macports.org/api/v1/ports/?format=api&ordering=-updated_at&page=674",
    "results": [
        {
            "name": "postgresql_select-93",
            "portdir": "databases/postgresql_select",
            "version": "0.8",
            "license": "Permissive",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "common files for selecting default PostgreSQL version",
            "long_description": "This port installs files that allow 'port select' to be used to create links to the preferred default version of PostgreSQL.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "davidgilman1",
                    "github": "dgilman",
                    "ports_count": 146
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql_select"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "run",
                    "ports": [
                        "postgresql93"
                    ]
                }
            ]
        },
        {
            "name": "postgresql_select-92",
            "portdir": "databases/postgresql_select",
            "version": "0.8",
            "license": "Permissive",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "common files for selecting default PostgreSQL version",
            "long_description": "This port installs files that allow 'port select' to be used to create links to the preferred default version of PostgreSQL.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "davidgilman1",
                    "github": "dgilman",
                    "ports_count": 146
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql_select"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "run",
                    "ports": [
                        "postgresql92"
                    ]
                }
            ]
        },
        {
            "name": "postgresql_select-91",
            "portdir": "databases/postgresql_select",
            "version": "0.8",
            "license": "Permissive",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "common files for selecting default PostgreSQL version",
            "long_description": "This port installs files that allow 'port select' to be used to create links to the preferred default version of PostgreSQL.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "davidgilman1",
                    "github": "dgilman",
                    "ports_count": 146
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql_select"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "run",
                    "ports": [
                        "postgresql91"
                    ]
                }
            ]
        },
        {
            "name": "postgresql_select-90",
            "portdir": "databases/postgresql_select",
            "version": "0.8",
            "license": "Permissive",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "common files for selecting default PostgreSQL version",
            "long_description": "This port installs files that allow 'port select' to be used to create links to the preferred default version of PostgreSQL.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "davidgilman1",
                    "github": "dgilman",
                    "ports_count": 146
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql_select"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "run",
                    "ports": [
                        "postgresql90"
                    ]
                }
            ]
        },
        {
            "name": "postgresql_select-84",
            "portdir": "databases/postgresql_select",
            "version": "0.8",
            "license": "Permissive",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "common files for selecting default PostgreSQL version",
            "long_description": "This port installs files that allow 'port select' to be used to create links to the preferred default version of PostgreSQL.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "davidgilman1",
                    "github": "dgilman",
                    "ports_count": 146
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql_select"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "run",
                    "ports": [
                        "postgresql84"
                    ]
                }
            ]
        },
        {
            "name": "pqa",
            "portdir": "databases/pqa",
            "version": "1.6",
            "license": "Permissive and GPLConflict",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "http://pqa.projects.postgresql.org/",
            "description": "pqa is a PostgreSQL SQL analysis tool",
            "long_description": "PostgreSQL Query Analyzer produces HTML reports on the most frequent queries, slowest queries, queries by type select/insert/update/delete), and more.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "extract",
                    "ports": [
                        "unzip"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "ruby"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql_select",
            "portdir": "databases/postgresql_select",
            "version": "0.8",
            "license": "Permissive",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "common files for selecting default PostgreSQL version",
            "long_description": "This port installs files that allow 'port select' to be used to create links to the preferred default version of PostgreSQL.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "davidgilman1",
                    "github": "dgilman",
                    "ports_count": 146
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "run",
                    "ports": [
                        "postgresql_select-84",
                        "postgresql_select-90",
                        "postgresql_select-91",
                        "postgresql_select-92",
                        "postgresql_select-93",
                        "postgresql_select-94",
                        "postgresql_select-95",
                        "postgresql_select-96",
                        "postgresql_select-10",
                        "postgresql_select-11",
                        "postgresql_select-12",
                        "postgresql_select-13",
                        "postgresql_select-14",
                        "postgresql_select-15",
                        "postgresql_select-16",
                        "postgresql_select-17",
                        "postgresql_select-18",
                        "calendar-contacts-server"
                    ]
                }
            ]
        },
        {
            "name": "postgresql_autodoc",
            "portdir": "databases/postgresql_autodoc",
            "version": "1.41",
            "license": "BSD",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "http://www.rbt.ca/autodoc/",
            "description": "Automatic documentation generator for postgresql databases",
            "long_description": "Automatic documentation generator for postgresql databases. It supports output in HTML, GraphViz, SGML DocBook and DIA formats.",
            "active": true,
            "categories": [
                "databases",
                "textproc"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "perl5.34"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "p5.34-dbd-pg",
                        "p5.34-dbi",
                        "p5.34-html-template",
                        "p5.34-term-readkey"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql96-server",
            "portdir": "databases/postgresql96-server",
            "version": "9.6.24",
            "license": "Permissive",
            "platforms": "{darwin any}",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "run postgresql96 as server",
            "long_description": "run postgresql96 as server",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "jwa",
                    "github": "jyrkiwahlstedt",
                    "ports_count": 44
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql96"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql96-doc",
            "portdir": "databases/postgresql96-doc",
            "version": "9.6.24",
            "license": "Permissive",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "Documentation for the PostgreSQL database version 9.6",
            "long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity. This is the documentation.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "jwa",
                    "github": "jyrkiwahlstedt",
                    "ports_count": 44
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql96",
            "portdir": "databases/postgresql96",
            "version": "9.6.24",
            "license": "Permissive",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "The most advanced open-source database available anywhere.",
            "long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "jwa",
                    "github": "jyrkiwahlstedt",
                    "ports_count": 44
                }
            ],
            "variants": [
                "python",
                "python27",
                "python3",
                "perl",
                "tcl",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18",
                        "bison"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "kerberos5",
                        "libxml2",
                        "zlib",
                        "openssl3",
                        "libxslt",
                        "readline"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql_select-96"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "pgAdmin3",
                        "slony1"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql96-server"
                    ]
                }
            ]
        },
        {
            "name": "postgresql95-server",
            "portdir": "databases/postgresql95-server",
            "version": "9.5.25",
            "license": "Permissive",
            "platforms": "{darwin any}",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "run postgresql95 as server",
            "long_description": "run postgresql95 as server",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "jwa",
                    "github": "jyrkiwahlstedt",
                    "ports_count": 44
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql95"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql95-doc",
            "portdir": "databases/postgresql95-doc",
            "version": "9.5.25",
            "license": "Permissive",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "Documentation for the PostgreSQL database version 9.5",
            "long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity. This is the documentation.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "jwa",
                    "github": "jyrkiwahlstedt",
                    "ports_count": 44
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql95",
            "portdir": "databases/postgresql95",
            "version": "9.5.25",
            "license": "Permissive",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "The most advanced open-source database available anywhere.",
            "long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "jwa",
                    "github": "jyrkiwahlstedt",
                    "ports_count": 44
                }
            ],
            "variants": [
                "python",
                "python27",
                "python3",
                "perl",
                "tcl",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18",
                        "bison"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "libxml2",
                        "libxslt",
                        "zlib",
                        "openssl3",
                        "readline"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql_select-95"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "run",
                    "ports": [
                        "postgresql95-server"
                    ]
                }
            ]
        },
        {
            "name": "postgresql94-server",
            "portdir": "databases/postgresql94-server",
            "version": "9.4.26",
            "license": "Permissive",
            "platforms": "{darwin any}",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "run postgresql94 as server",
            "long_description": "run postgresql94 as server",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "jwa",
                    "github": "jyrkiwahlstedt",
                    "ports_count": 44
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql94"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql94-doc",
            "portdir": "databases/postgresql94-doc",
            "version": "9.4.26",
            "license": "Permissive",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "Documentation for the PostgreSQL database version 9.4",
            "long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity. This is the documentation.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "jwa",
                    "github": "jyrkiwahlstedt",
                    "ports_count": 44
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql94",
            "portdir": "databases/postgresql94",
            "version": "9.4.26",
            "license": "Permissive",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "The most advanced open-source database available anywhere.",
            "long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "jwa",
                    "github": "jyrkiwahlstedt",
                    "ports_count": 44
                }
            ],
            "variants": [
                "python",
                "python27",
                "perl",
                "tcl",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18",
                        "bison"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "libxml2",
                        "libxslt",
                        "zlib",
                        "openssl11",
                        "readline"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql_select-94"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "run",
                    "ports": [
                        "postgresql94-server"
                    ]
                }
            ]
        },
        {
            "name": "postgresql93-server",
            "portdir": "databases/postgresql93-server",
            "version": "9.3.25",
            "license": "Permissive",
            "platforms": "{darwin any}",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "run postgresql93 as server",
            "long_description": "run postgresql93 as server",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "jwa",
                    "github": "jyrkiwahlstedt",
                    "ports_count": 44
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql93"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql93-doc",
            "portdir": "databases/postgresql93-doc",
            "version": "9.3.25",
            "license": "Permissive",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "Documentation for the PostgreSQL database version 9.3",
            "long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity. This is the documentation.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "jwa",
                    "github": "jyrkiwahlstedt",
                    "ports_count": 44
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql93",
            "portdir": "databases/postgresql93",
            "version": "9.3.25",
            "license": "Permissive",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "The most advanced open-source database available anywhere.",
            "long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "jwa",
                    "github": "jyrkiwahlstedt",
                    "ports_count": 44
                }
            ],
            "variants": [
                "python",
                "python27",
                "krb5",
                "perl",
                "tcl",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18",
                        "bison"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "readline",
                        "libxml2",
                        "zlib",
                        "openssl11",
                        "libxslt",
                        "ossp-uuid"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql_select-93"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "run",
                    "ports": [
                        "postgresql93-server"
                    ]
                }
            ]
        },
        {
            "name": "postgresql92-server",
            "portdir": "databases/postgresql92-server",
            "version": "9.2.24",
            "license": "Permissive",
            "platforms": "{darwin any}",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "run postgresql92 as server",
            "long_description": "run postgresql92 as server",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql92"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql92-doc",
            "portdir": "databases/postgresql92-doc",
            "version": "9.2.24",
            "license": "Permissive",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "Documentation for the PostgreSQL database version 9.2",
            "long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity. This is the documentation.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql92",
            "portdir": "databases/postgresql92",
            "version": "9.2.24",
            "license": "Permissive",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "The most advanced open-source database available anywhere.",
            "long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [
                "python",
                "python27",
                "krb5",
                "perl",
                "tcl",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18",
                        "bison"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "readline",
                        "libxml2",
                        "zlib",
                        "openssl11",
                        "libxslt",
                        "ossp-uuid"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql_select-92"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "py27-pygresql",
                        "postgis",
                        "py37-pygresql",
                        "qt4-mac-postgresql92-plugin",
                        "libzdb-postgresql92"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql92-server"
                    ]
                }
            ]
        },
        {
            "name": "postgresql91-server",
            "portdir": "databases/postgresql91-server",
            "version": "9.1.24",
            "license": "Permissive",
            "platforms": "{darwin any}",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "run postgresql91 as server",
            "long_description": "run postgresql91 as server",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql91"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql91-doc",
            "portdir": "databases/postgresql91-doc",
            "version": "9.1.24",
            "license": "Permissive",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "Documentation for the PostgreSQL database version 9.1",
            "long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity. This is the documentation.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql91",
            "portdir": "databases/postgresql91",
            "version": "9.1.24",
            "license": "Permissive",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "The most advanced open-source database available anywhere.",
            "long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [
                "python",
                "python27",
                "krb5",
                "perl",
                "tcl",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18",
                        "bison"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "ossp-uuid",
                        "readline",
                        "zlib",
                        "libxslt",
                        "libxml2",
                        "openssl10"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql_select-91"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "qt4-mac-postgresql91-plugin",
                        "libzdb-postgresql91"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql91-server"
                    ]
                }
            ]
        },
        {
            "name": "postgresql90-server",
            "portdir": "databases/postgresql90-server",
            "version": "9.0.23",
            "license": "Permissive",
            "platforms": "{darwin any}",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "run postgresql90 as server",
            "long_description": "run postgresql90 as server",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql90"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "run",
                    "ports": [
                        "iplike"
                    ]
                }
            ]
        },
        {
            "name": "postgresql90-doc",
            "portdir": "databases/postgresql90-doc",
            "version": "9.0.23",
            "license": "Permissive",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "Documentation for the PostgreSQL database version 9.0",
            "long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity. This is the documentation.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql90",
            "portdir": "databases/postgresql90",
            "version": "9.0.23",
            "license": "Permissive",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "The most advanced open-source database available anywhere.",
            "long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [
                "python",
                "python27",
                "krb5",
                "perl",
                "tcl",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18",
                        "bison"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "ossp-uuid",
                        "readline",
                        "zlib",
                        "libxslt",
                        "libxml2",
                        "openssl10"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql_select-90"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "build",
                    "ports": [
                        "postgresql-unaccent"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "qt4-mac-postgresql90-plugin",
                        "libzdb-postgresql90"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql90-server"
                    ]
                }
            ]
        },
        {
            "name": "postgresql84-server",
            "portdir": "databases/postgresql84-server",
            "version": "8.4.22",
            "license": "Permissive",
            "platforms": "{darwin any}",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "run postgresql84 as server",
            "long_description": "run postgresql84 as server",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql84"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql84-doc",
            "portdir": "databases/postgresql84-doc",
            "version": "8.4.22",
            "license": "Permissive",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "Documentation for the PostgreSQL database version 8.4",
            "long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity. This is the documentation.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql84",
            "portdir": "databases/postgresql84",
            "version": "8.4.22",
            "license": "Permissive",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "The most advanced open-source database available anywhere.",
            "long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [
                "python",
                "python27",
                "krb5",
                "perl",
                "tcl",
                "earthdistance",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18",
                        "bison"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "ossp-uuid",
                        "readline",
                        "zlib",
                        "libxslt",
                        "libxml2",
                        "openssl10"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql_select-84"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "py27-pgsql",
                        "qt4-mac-postgresql84-plugin",
                        "libzdb-postgresql84",
                        "BiggerSQL"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql84-server"
                    ]
                }
            ]
        },
        {
            "name": "postgresql83-server",
            "portdir": "databases/postgresql83-server",
            "version": "8.3.23",
            "license": "Permissive",
            "platforms": "{darwin any}",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "run postgresql83 as server",
            "long_description": "run postgresql83 as server",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql83"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql83-doc",
            "portdir": "databases/postgresql83-doc",
            "version": "8.3.23",
            "license": "Permissive",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "Documentation for the PostgreSQL database version 8.3",
            "long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity. This is the documentation.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql83",
            "portdir": "databases/postgresql83",
            "version": "8.3.23",
            "license": "Permissive",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "The most advanced open-source database available anywhere.",
            "long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [
                "python",
                "python27",
                "krb5",
                "perl",
                "tcl"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "bison",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "ossp-uuid",
                        "readline",
                        "zlib",
                        "libxslt",
                        "libxml2",
                        "openssl10"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "libpqxx26",
                        "qt4-mac-postgresql83-plugin",
                        "libzdb-postgresql83",
                        "rb-postgres",
                        "BigSQL"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql83-server"
                    ]
                }
            ]
        },
        {
            "name": "postgresql82-server",
            "portdir": "databases/postgresql82-server",
            "version": "8.2.23",
            "license": "Permissive",
            "platforms": "{darwin any}",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "run postgresql82 as server",
            "long_description": "run postgresql82 as server",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql82"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql82-doc",
            "portdir": "databases/postgresql82-doc",
            "version": "8.2.23",
            "license": "Permissive",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "Documentation for the PostgreSQL database version 8.2",
            "long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity. This is the documentation.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql82",
            "portdir": "databases/postgresql82",
            "version": "8.2.23",
            "license": "Permissive",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "The most advanced open-source database available anywhere",
            "long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [
                "python",
                "krb5",
                "perl",
                "tcl",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "bison",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "readline",
                        "zlib",
                        "libxslt",
                        "libxml2",
                        "openssl10"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "qt4-mac-postgresql82-plugin",
                        "libzdb-postgresql82"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql82-server"
                    ]
                }
            ]
        },
        {
            "name": "postgresql18",
            "portdir": "databases/postgresql18",
            "version": "18.3",
            "license": "Permissive",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "The most advanced open-source database available anywhere.",
            "long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "davidgilman1",
                    "github": "dgilman",
                    "ports_count": 146
                }
            ],
            "variants": [
                "clang14",
                "clang15",
                "clang16",
                "clang17",
                "clang18",
                "clang19",
                "clang20",
                "clang21",
                "clang22",
                "clangdevel",
                "python3",
                "perl",
                "tcl",
                "llvm",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18",
                        "docbook-xsl-nons",
                        "bison",
                        "pkgconfig",
                        "perl5",
                        "docbook-xml-4.5"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "libxml2",
                        "libxslt",
                        "lz4",
                        "openssl3",
                        "zlib",
                        "zstd",
                        "icu",
                        "readline",
                        "kerberos5"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql_select-18",
                        "curl-ca-bundle"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "octave-database",
                        "pg18-timescaledb",
                        "php85-postgresql",
                        "php84-postgresql",
                        "php83-postgresql",
                        "php82-postgresql",
                        "php81-postgresql",
                        "php80-postgresql",
                        "php74-postgresql",
                        "php73-postgresql",
                        "php72-postgresql",
                        "php71-postgresql",
                        "php70-postgresql",
                        "php56-postgresql",
                        "php55-postgresql",
                        "php54-postgresql",
                        "php53-postgresql",
                        "php52-postgresql"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql18-server"
                    ]
                }
            ]
        },
        {
            "name": "postgresql18-server",
            "portdir": "databases/postgresql18-server",
            "version": "18.3",
            "license": "Permissive",
            "platforms": "{darwin any}",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "run postgresql18 as server",
            "long_description": "run postgresql18 as server",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "davidgilman1",
                    "github": "dgilman",
                    "ports_count": 146
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql17-server",
            "portdir": "databases/postgresql17-server",
            "version": "17.9",
            "license": "Permissive",
            "platforms": "{darwin any}",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "run postgresql17 as server",
            "long_description": "run postgresql17 as server",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "davidgilman1",
                    "github": "dgilman",
                    "ports_count": 146
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql17"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "calendar-contacts-server"
                    ]
                }
            ]
        },
        {
            "name": "postgresql17",
            "portdir": "databases/postgresql17",
            "version": "17.9",
            "license": "Permissive",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "The most advanced open-source database available anywhere.",
            "long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "davidgilman1",
                    "github": "dgilman",
                    "ports_count": 146
                }
            ],
            "variants": [
                "clang13",
                "clang14",
                "clang15",
                "clang16",
                "clang17",
                "clang18",
                "clang19",
                "clang20",
                "clang21",
                "clang22",
                "clangdevel",
                "python3",
                "perl",
                "tcl",
                "llvm",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18",
                        "docbook-xsl-nons",
                        "bison",
                        "pkgconfig",
                        "perl5",
                        "docbook-xml-4.5"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "libxml2",
                        "libxslt",
                        "lz4",
                        "openssl3",
                        "zlib",
                        "zstd",
                        "icu",
                        "readline",
                        "kerberos5"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql_select-17",
                        "curl-ca-bundle"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "build",
                    "ports": [
                        "pg17-postgis3-doc",
                        "pg17-postgis-doc"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "qt6-psql-plugin",
                        "qt610-psql-plugin",
                        "qt68-psql-plugin",
                        "qt69-psql-plugin",
                        "pg17-pgpointcloud",
                        "pg17-postgis",
                        "py314-psycopg2",
                        "py39-psycopg2",
                        "py39-psycopg",
                        "pg17-timescaledb",
                        "gdal",
                        "grass",
                        "mapnik",
                        "mod_tile",
                        "openstreetmap-carto",
                        "osm2pgrouting",
                        "osm2pgsql",
                        "pdal-pgpointcloud",
                        "pg17-pgrouting",
                        "qgis3",
                        "qgis3-ltr",
                        "saga",
                        "py-psycopg",
                        "py310-psycopg",
                        "py311-psycopg",
                        "py312-psycopg",
                        "py313-psycopg",
                        "py310-psycopg2",
                        "py311-psycopg2",
                        "py312-psycopg2",
                        "py313-psycopg2"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql17-server"
                    ]
                }
            ]
        },
        {
            "name": "postgresql16-server",
            "portdir": "databases/postgresql16-server",
            "version": "16.13",
            "license": "Permissive",
            "platforms": "{darwin any}",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "run postgresql16 as server",
            "long_description": "run postgresql16 as server",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "davidgilman1",
                    "github": "dgilman",
                    "ports_count": 146
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql16"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql16",
            "portdir": "databases/postgresql16",
            "version": "16.13",
            "license": "Permissive",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "The most advanced open-source database available anywhere.",
            "long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "davidgilman1",
                    "github": "dgilman",
                    "ports_count": 146
                }
            ],
            "variants": [
                "clang13",
                "clang14",
                "clang15",
                "clang16",
                "clang17",
                "clang18",
                "clang19",
                "clang20",
                "clang21",
                "clang22",
                "clangdevel",
                "python3",
                "perl",
                "tcl",
                "llvm",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18",
                        "docbook-xsl-nons",
                        "bison",
                        "pkgconfig",
                        "docbook-xml-4.5"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "kerberos5",
                        "libxml2",
                        "libxslt",
                        "lz4",
                        "openssl3",
                        "zlib",
                        "zstd",
                        "icu",
                        "readline"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql_select-16",
                        "curl-ca-bundle"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "build",
                    "ports": [
                        "pg16-postgis3-doc",
                        "pgpool-II",
                        "pg16-postgis-doc"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "qt4-mac-postgresql16-plugin",
                        "qt5-psql-plugin",
                        "qt511-psql-plugin",
                        "qt513-psql-plugin",
                        "qt53-psql-plugin",
                        "qt55-psql-plugin",
                        "qt56-psql-plugin",
                        "qt57-psql-plugin",
                        "qt58-psql-plugin",
                        "qt59-psql-plugin",
                        "iplike",
                        "libgda5",
                        "libpqxx",
                        "libzdb-postgresql16",
                        "pg_rman",
                        "pg16-pgpointcloud",
                        "pgtcl",
                        "pg16-postgis",
                        "py312-pygresql",
                        "osm2pgsql-lua",
                        "py38-psycopg2",
                        "py37-psycopg2",
                        "psqlODBC",
                        "pg16-timescaledb",
                        "wt",
                        "pg16-pgrouting",
                        "tinyows",
                        "glom",
                        "gawk-pgsql",
                        "p5.28-dbd-pg",
                        "p5.30-dbd-pg",
                        "p5.32-dbd-pg",
                        "p5.34-dbd-pg"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql16-server"
                    ]
                }
            ]
        },
        {
            "name": "postgresql15-server",
            "portdir": "databases/postgresql15-server",
            "version": "15.17",
            "license": "Permissive",
            "platforms": "{darwin any}",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "run postgresql15 as server",
            "long_description": "run postgresql15 as server",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "jwa",
                    "github": "jyrkiwahlstedt",
                    "ports_count": 44
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql15"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql15",
            "portdir": "databases/postgresql15",
            "version": "15.17",
            "license": "Permissive",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "The most advanced open-source database available anywhere.",
            "long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "davidgilman1",
                    "github": "dgilman",
                    "ports_count": 146
                }
            ],
            "variants": [
                "clang13",
                "clang14",
                "clang15",
                "clang16",
                "clang17",
                "clang18",
                "clang19",
                "clang20",
                "clang21",
                "clang22",
                "clangdevel",
                "python3",
                "perl",
                "tcl",
                "llvm",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18",
                        "bison",
                        "pkgconfig"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "kerberos5",
                        "libxml2",
                        "zlib",
                        "openssl3",
                        "libxslt",
                        "icu",
                        "readline"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql_select-15"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "build",
                    "ports": [
                        "pg15-postgis3-doc",
                        "pg15-postgis-doc"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "R-RPostgres",
                        "R-adbcpostgresql",
                        "qt4-mac-postgresql15-plugin",
                        "qt64-psql-plugin",
                        "qt67-psql-plugin",
                        "pgmodeler",
                        "pg15-pgpointcloud",
                        "pg15-postgis",
                        "mosml-dynlibs",
                        "R-RPostgreSQL",
                        "PDAL",
                        "pg15-timescaledb",
                        "grass7",
                        "mapserver",
                        "pg15-pgrouting"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql15-server"
                    ]
                }
            ]
        },
        {
            "name": "postgresql15-doc",
            "portdir": "databases/postgresql15-doc",
            "version": "15.17",
            "license": "Permissive",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "Documentation for the PostgreSQL database version 15",
            "long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity. This is the documentation.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "jwa",
                    "github": "jyrkiwahlstedt",
                    "ports_count": 44
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "docbook-xml-4.5",
                        "docbook-xsl-nons",
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql14-server",
            "portdir": "databases/postgresql14-server",
            "version": "14.22",
            "license": "Permissive",
            "platforms": "{darwin any}",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "run postgresql14 as server",
            "long_description": "run postgresql14 as server",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "jwa",
                    "github": "jyrkiwahlstedt",
                    "ports_count": 44
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql14"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql14-doc",
            "portdir": "databases/postgresql14-doc",
            "version": "14.22",
            "license": "Permissive",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "Documentation for the PostgreSQL database version 14",
            "long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity. This is the documentation.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "jwa",
                    "github": "jyrkiwahlstedt",
                    "ports_count": 44
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "docbook-xml-4.5",
                        "docbook-xsl-nons",
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql14",
            "portdir": "databases/postgresql14",
            "version": "14.22",
            "license": "Permissive",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "The most advanced open-source database available anywhere.",
            "long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "davidgilman1",
                    "github": "dgilman",
                    "ports_count": 146
                }
            ],
            "variants": [
                "python",
                "clang13",
                "clang14",
                "clang15",
                "clang16",
                "clang17",
                "clang18",
                "clang19",
                "clang20",
                "clang21",
                "clang22",
                "clangdevel",
                "python27",
                "python3",
                "perl",
                "tcl",
                "llvm",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18",
                        "bison",
                        "pkgconfig"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "kerberos5",
                        "libxml2",
                        "zlib",
                        "openssl3",
                        "libxslt",
                        "icu",
                        "readline"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql_select-14"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "build",
                    "ports": [
                        "pg14-postgis3-doc",
                        "pg14-postgis-doc"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "pg14-pgpointcloud",
                        "pg14-postgis",
                        "py27-psycopg2",
                        "py36-psycopg2",
                        "py36-psycopg",
                        "pg14-timescaledb",
                        "pg14-pgrouting",
                        "qore-pgsql-module"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql14-server"
                    ]
                }
            ]
        }
    ]
}