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

{
    "count": 50591,
    "next": "https://ports.macports.org/api/v1/ports/?format=api&ordering=-name&page=578",
    "previous": "https://ports.macports.org/api/v1/ports/?format=api&ordering=-name&page=576",
    "results": [
        {
            "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": [
                        "BiggerSQL",
                        "py27-pgsql",
                        "qt4-mac-postgresql84-plugin",
                        "libzdb-postgresql84"
                    ]
                },
                {
                    "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": [
                        "BigSQL",
                        "libpqxx26",
                        "qt4-mac-postgresql83-plugin",
                        "libzdb-postgresql83",
                        "rb-postgres"
                    ]
                },
                {
                    "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": "postgresql81-server",
            "portdir": "databases/postgresql81-server",
            "version": "8.1.23",
            "license": "Permissive",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "run postgresql81 as server",
            "long_description": "run postgresql81 as server",
            "active": false,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-9.0"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql81"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql81-doc",
            "portdir": "databases/postgresql81-doc",
            "version": "8.1.23",
            "license": "Permissive",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "Documentation for the postgresql database",
            "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": false,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-9.0"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql81",
            "portdir": "databases/postgresql81",
            "version": "8.1.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": false,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [
                "python",
                "krb5",
                "perl",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "bison",
                        "clang-9.0"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "readline",
                        "zlib",
                        "libxslt",
                        "libxml2",
                        "openssl"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "pg2xbase",
                        "qt4-mac-postgresql81-plugin",
                        "libzdb-postgresql81"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql81-server"
                    ]
                }
            ]
        },
        {
            "name": "postgresql80-server",
            "portdir": "databases/postgresql80-server",
            "version": "8.0.26",
            "license": "Permissive",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "run postgresql80 as server",
            "long_description": "run postgresql80 as server",
            "active": false,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-9.0"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql80"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql80-doc",
            "portdir": "databases/postgresql80-doc",
            "version": "8.0.26",
            "license": "Permissive",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "Documentation for the postgresql database",
            "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": false,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-9.0"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql80",
            "portdir": "databases/postgresql80",
            "version": "8.0.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": false,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [
                "python",
                "krb5",
                "perl",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "bison",
                        "clang-9.0"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "zlib",
                        "openssl",
                        "readline"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "qt4-mac-postgresql80-plugin",
                        "libzdb-postgresql80"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql80-server"
                    ]
                }
            ]
        },
        {
            "name": "postgresql18-server",
            "portdir": "databases/postgresql18-server",
            "version": "18.1",
            "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": 142
                },
                {
                    "name": "vital.had",
                    "github": "barracuda156",
                    "ports_count": 2571
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql18",
            "portdir": "databases/postgresql18",
            "version": "18.1",
            "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": 142
                },
                {
                    "name": "vital.had",
                    "github": "barracuda156",
                    "ports_count": 2571
                }
            ],
            "variants": [
                "clang14",
                "clang15",
                "clang16",
                "clang17",
                "clang18",
                "clang19",
                "clang20",
                "clang21",
                "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": [
                        "pg18-timescaledb"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql18-server"
                    ]
                }
            ]
        },
        {
            "name": "postgresql17-server",
            "portdir": "databases/postgresql17-server",
            "version": "17.7",
            "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": 142
                },
                {
                    "name": "vital.had",
                    "github": "barracuda156",
                    "ports_count": 2571
                }
            ],
            "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.7",
            "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": 142
                },
                {
                    "name": "vital.had",
                    "github": "barracuda156",
                    "ports_count": 2571
                }
            ],
            "variants": [
                "perl",
                "tcl",
                "llvm",
                "clang13",
                "clang14",
                "clang15",
                "universal",
                "clang16",
                "clang17",
                "clang18",
                "clang19",
                "clang20",
                "clang21",
                "clangdevel",
                "python3"
            ],
            "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": [
                        "py311-psycopg2",
                        "py312-psycopg2",
                        "py313-psycopg2",
                        "py314-psycopg2",
                        "pg17-postgis",
                        "pg17-pgrouting",
                        "mod_tile",
                        "qt69-psql-plugin",
                        "gdal",
                        "qgis3",
                        "qgis3-ltr",
                        "py-psycopg",
                        "py310-psycopg",
                        "py311-psycopg",
                        "py312-psycopg",
                        "py313-psycopg",
                        "saga",
                        "pg17-pgpointcloud",
                        "pdal-pgpointcloud",
                        "pg17-timescaledb",
                        "qt68-psql-plugin",
                        "grass",
                        "openstreetmap-carto",
                        "py39-psycopg2",
                        "qt6-psql-plugin",
                        "octave-database",
                        "mapnik",
                        "osm2pgrouting",
                        "osm2pgsql",
                        "py39-psycopg",
                        "py310-psycopg2"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql17-server"
                    ]
                }
            ]
        },
        {
            "name": "postgresql16-server",
            "portdir": "databases/postgresql16-server",
            "version": "16.11",
            "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": 142
                },
                {
                    "name": "vital.had",
                    "github": "barracuda156",
                    "ports_count": 2571
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql16"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql16",
            "portdir": "databases/postgresql16",
            "version": "16.11",
            "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": 142
                },
                {
                    "name": "vital.had",
                    "github": "barracuda156",
                    "ports_count": 2571
                }
            ],
            "variants": [
                "clang13",
                "clang14",
                "clang15",
                "clang16",
                "clang17",
                "clang18",
                "clang19",
                "clang20",
                "clang21",
                "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-postgis-doc",
                        "pgpool-II",
                        "pg16-postgis3-doc"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "qt4-mac-postgresql16-plugin",
                        "php84-postgresql",
                        "php83-postgresql",
                        "php82-postgresql",
                        "glom",
                        "php81-postgresql",
                        "php80-postgresql",
                        "psqlODBC",
                        "php74-postgresql",
                        "php73-postgresql",
                        "php72-postgresql",
                        "php71-postgresql",
                        "php70-postgresql",
                        "php56-postgresql",
                        "php55-postgresql",
                        "php54-postgresql",
                        "php53-postgresql",
                        "php52-postgresql",
                        "wt",
                        "qt511-psql-plugin",
                        "qt53-psql-plugin",
                        "qt56-psql-plugin",
                        "qt55-psql-plugin",
                        "qt57-psql-plugin",
                        "qt58-psql-plugin",
                        "pg_rman",
                        "qt59-psql-plugin",
                        "p5.28-dbd-pg",
                        "p5.30-dbd-pg",
                        "p5.32-dbd-pg",
                        "p5.34-dbd-pg",
                        "py37-psycopg2",
                        "py312-pygresql",
                        "qt5-psql-plugin",
                        "pg16-pgpointcloud",
                        "pg16-timescaledb",
                        "iplike",
                        "pgtcl",
                        "libpqxx",
                        "libgda5",
                        "osm2pgsql-lua",
                        "qt513-psql-plugin",
                        "py38-psycopg2",
                        "tinyows",
                        "gawk-pgsql",
                        "pg16-pgrouting",
                        "libzdb-postgresql16",
                        "pg16-postgis"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql16-server"
                    ]
                }
            ]
        },
        {
            "name": "postgresql15-server",
            "portdir": "databases/postgresql15-server",
            "version": "15.15",
            "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": 37
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql15"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql15-doc",
            "portdir": "databases/postgresql15-doc",
            "version": "15.14",
            "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": 37
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "docbook-xml-4.5",
                        "docbook-xsl-nons",
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql15",
            "portdir": "databases/postgresql15",
            "version": "15.15",
            "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": 142
                },
                {
                    "name": "vital.had",
                    "github": "barracuda156",
                    "ports_count": 2571
                }
            ],
            "variants": [
                "clang13",
                "clang14",
                "clang15",
                "clang16",
                "clang17",
                "clang18",
                "clang19",
                "clang20",
                "clang21",
                "universal",
                "clangdevel",
                "python3",
                "perl",
                "tcl",
                "llvm"
            ],
            "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-RPostgreSQL",
                        "pg15-postgis",
                        "pg15-pgrouting",
                        "qt4-mac-postgresql15-plugin",
                        "PDAL",
                        "pg15-pgpointcloud",
                        "R-RPostgres",
                        "R-adbcpostgresql",
                        "qt64-psql-plugin",
                        "qt67-psql-plugin",
                        "pg15-timescaledb",
                        "grass7",
                        "mapserver",
                        "mosml-dynlibs",
                        "pgmodeler"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql15-server"
                    ]
                }
            ]
        },
        {
            "name": "postgresql14-server",
            "portdir": "databases/postgresql14-server",
            "version": "14.20",
            "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": 37
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql14"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql14-doc",
            "portdir": "databases/postgresql14-doc",
            "version": "14.19",
            "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": 37
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "docbook-xml-4.5",
                        "docbook-xsl-nons",
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql14",
            "portdir": "databases/postgresql14",
            "version": "14.20",
            "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": 142
                },
                {
                    "name": "vital.had",
                    "github": "barracuda156",
                    "ports_count": 2571
                }
            ],
            "variants": [
                "clang13",
                "clang14",
                "clang15",
                "clang16",
                "clang17",
                "clang18",
                "clang19",
                "clang20",
                "clang21",
                "clangdevel",
                "python",
                "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": [
                        "qore-pgsql-module",
                        "pg14-postgis",
                        "pg14-pgrouting",
                        "py36-psycopg2",
                        "pg14-pgpointcloud",
                        "pg14-timescaledb",
                        "py27-psycopg2",
                        "py36-psycopg"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql14-server"
                    ]
                }
            ]
        },
        {
            "name": "postgresql13-server",
            "portdir": "databases/postgresql13-server",
            "version": "13.23",
            "license": "Permissive",
            "platforms": "{darwin any}",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "run postgresql13 as server",
            "long_description": "run postgresql13 as server",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "jwa",
                    "github": "jyrkiwahlstedt",
                    "ports_count": 37
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql13"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql13-doc",
            "portdir": "databases/postgresql13-doc",
            "version": "13.22",
            "license": "Permissive",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "Documentation for the PostgreSQL database version 13",
            "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": 37
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "docbook-xml-4.5",
                        "docbook-xsl-nons",
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql13",
            "portdir": "databases/postgresql13",
            "version": "13.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": [
                {
                    "name": "davidgilman1",
                    "github": "dgilman",
                    "ports_count": 142
                },
                {
                    "name": "vital.had",
                    "github": "barracuda156",
                    "ports_count": 2571
                }
            ],
            "variants": [
                "clang13",
                "clang14",
                "clang15",
                "clang16",
                "clang17",
                "clang18",
                "clang19",
                "clang20",
                "clang21",
                "clangdevel",
                "python",
                "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-13"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "build",
                    "ports": [
                        "pg13-postgis3-doc",
                        "pg13-postgis-doc"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "pg13-postgis",
                        "pg13-timescaledb",
                        "pg13-pgpointcloud",
                        "pg13-pgrouting"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql13-server"
                    ]
                }
            ]
        },
        {
            "name": "postgresql12-server",
            "portdir": "databases/postgresql12-server",
            "version": "12.22",
            "license": "Permissive",
            "platforms": "{darwin any}",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "run postgresql12 as server",
            "long_description": "run postgresql12 as server",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "jwa",
                    "github": "jyrkiwahlstedt",
                    "ports_count": 37
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql12"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql12-doc",
            "portdir": "databases/postgresql12-doc",
            "version": "12.22",
            "license": "Permissive",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "Documentation for the PostgreSQL database version 12",
            "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": 37
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "docbook-xml-4.5",
                        "docbook-xsl-nons",
                        "clang-17"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql12",
            "portdir": "databases/postgresql12",
            "version": "12.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": [
                "clang13",
                "clang14",
                "clang15",
                "clang16",
                "clang17",
                "clang18",
                "clang19",
                "clang20",
                "clang21",
                "clangdevel",
                "python",
                "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-12"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "build",
                    "ports": [
                        "pg12-postgis-doc",
                        "pg12-postgis3-doc"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "pg12-postgis",
                        "pg12-pgrouting",
                        "pg12-pgpointcloud",
                        "postgis2",
                        "timescaledb1",
                        "p5.26-dbd-pg",
                        "pg12-timescaledb"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql12-server"
                    ]
                }
            ]
        },
        {
            "name": "postgresql11-server",
            "portdir": "databases/postgresql11-server",
            "version": "11.14",
            "license": "Permissive",
            "platforms": "{darwin any}",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "run postgresql11 as server",
            "long_description": "run postgresql11 as server",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "jwa",
                    "github": "jyrkiwahlstedt",
                    "ports_count": 37
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql11"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql11-doc",
            "portdir": "databases/postgresql11-doc",
            "version": "11.14",
            "license": "Permissive",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "Documentation for the PostgreSQL database version 11",
            "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": 37
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-16"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql11",
            "portdir": "databases/postgresql11",
            "version": "11.14",
            "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": 37
                }
            ],
            "variants": [
                "clang13",
                "clang14",
                "clang15",
                "clang16",
                "clang17",
                "clang18",
                "clang19",
                "clang20",
                "clang21",
                "clangdevel",
                "python",
                "python27",
                "python3",
                "perl",
                "tcl",
                "llvm",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18",
                        "bison",
                        "pkgconfig"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "kerberos5",
                        "libxml2",
                        "zlib",
                        "openssl11",
                        "libxslt",
                        "icu",
                        "readline"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql_select-11"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "run",
                    "ports": [
                        "postgresql11-server"
                    ]
                }
            ]
        },
        {
            "name": "postgresql10-server",
            "portdir": "databases/postgresql10-server",
            "version": "10.19",
            "license": "Permissive",
            "platforms": "{darwin any}",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "run postgresql10 as server",
            "long_description": "run postgresql10 as server",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "jwa",
                    "github": "jyrkiwahlstedt",
                    "ports_count": 37
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql10"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "amber"
                    ]
                }
            ]
        },
        {
            "name": "postgresql10-doc",
            "portdir": "databases/postgresql10-doc",
            "version": "10.19",
            "license": "Permissive",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "Documentation for the PostgreSQL database version 10",
            "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": 37
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-16"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql10",
            "portdir": "databases/postgresql10",
            "version": "10.19",
            "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": 37
                }
            ],
            "variants": [
                "python",
                "python27",
                "python3",
                "perl",
                "tcl",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18",
                        "bison"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "kerberos5",
                        "libxml2",
                        "zlib",
                        "openssl11",
                        "libxslt",
                        "readline"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql_select-10"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "run",
                    "ports": [
                        "postgresql10-server"
                    ]
                }
            ]
        },
        {
            "name": "postgis3",
            "portdir": "databases/postgis3",
            "version": "3.6.0",
            "license": "GPL-2+",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.macports.org",
            "description": "Obsolete port",
            "long_description": "This port is obsolete.",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "extract",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "fetch",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "patch",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "test",
                    "ports": [
                        null
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgis2",
            "portdir": "databases/postgis2",
            "version": "2.5.11",
            "license": "GPL-2+",
            "platforms": "darwin",
            "epoch": 1,
            "replaced_by": null,
            "homepage": "http://postgis.refractions.net/",
            "description": "PostGIS is the spatial extension to the PostGreSQL database.",
            "long_description": "PostGIS 2 adds geometrical, geographical and topological types, and functions operating thereon, to the PostGreSQL database. The 2.0 release also provides raster handling and basic 3D geometry capacities (TIN and polyhedra).",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "vince",
                    "github": "Veence",
                    "ports_count": 68
                }
            ],
            "variants": [
                "postgresql10",
                "postgresql11",
                "postgresql12",
                "raster",
                "topology",
                "sfcgal",
                "gui",
                "comments",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "libtool",
                        "libxslt",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "libiconv",
                        "postgresql12",
                        "libxml2",
                        "gdal",
                        "proj7",
                        "geos",
                        "json-c"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgis",
            "portdir": "databases/postgis",
            "version": "3.6.1",
            "license": "GPL-2+",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://postgis.net/",
            "description": "PostGIS is the spatial extension to the PostGreSQL database.",
            "long_description": "PostGIS adds geometrical, geographical and topological types, and functions operating thereon, to the PostGreSQL database. It also handles raster tiles and MVT format.",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 105
                },
                {
                    "name": "vince",
                    "github": "Veence",
                    "ports_count": 68
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "postgresql92",
                        "proj4",
                        "geos",
                        "libiconv",
                        "libxml2"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postfixadmin",
            "portdir": "www/postfixadmin",
            "version": "3.2",
            "license": "GPL-2+",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "http://postfixadmin.sourceforge.net/",
            "description": "Web Based Management tool for Postfix",
            "long_description": "Postfix Admin is a Web Based Management tool created for Postfix. It is a PHP based application that handles Postfix Style Virtual Domains and Users that are stored in MySQL.",
            "active": true,
            "categories": [
                "mail",
                "www",
                "php"
            ],
            "maintainers": [],
            "variants": [
                "mysql8",
                "mariadb102",
                "postgresql11"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "mysql8",
                        "php73",
                        "php73-mysql",
                        "postfix",
                        "apache2"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postfix",
            "portdir": "mail/postfix",
            "version": "3.10.7",
            "license": "(IBMPL-1 or EPL-2)",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "http://www.postfix.org/",
            "description": "Fast and robust mail transfer agent",
            "long_description": "Postfix attempts to be fast, easy to administer, and secure, while at the same time being sendmail-compatible enough to not upset existing users. It also offers QMQP and VERP support to let Postfix act as delivery daemon for ezmlm-idx.",
            "active": true,
            "categories": [
                "mail"
            ],
            "maintainers": [
                {
                    "name": "jmr",
                    "github": "jmroot",
                    "ports_count": 349
                }
            ],
            "variants": [
                "universal",
                "dovecot_sasl",
                "ldap",
                "pcre",
                "pcre2",
                "sasl",
                "smtputf8",
                "tls",
                "mariadb10.5",
                "mariadb10.6",
                "mariadb10.11",
                "mariadb11.4",
                "mysql8",
                "postgresql12",
                "postgresql13",
                "postgresql14",
                "postgresql15",
                "postgresql16",
                "postgresql17",
                "postgresql18",
                "mariadb10.4",
                "mysql57",
                "mariadb10.3",
                "mariadb10.7",
                "postgresql11"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "argus-monitor",
                        "mail-server",
                        "mailqfmt",
                        "sympa",
                        "vm-pop3d"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "sqlgrey",
                        "ddclient",
                        "postfixadmin"
                    ]
                }
            ]
        },
        {
            "name": "postfinger",
            "portdir": "mail/postfinger",
            "version": "1.30",
            "license": "GPL-2+",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "http://ftp.wl0.org/postfinger",
            "description": "Postfix Configuration Summary Reporter",
            "long_description": "Postfix Configuration Summary Reporter",
            "active": true,
            "categories": [
                "mail"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-14"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postal",
            "portdir": "mail/postal",
            "version": "0.72",
            "license": "GPL-3",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "http://www.coker.com.au/postal/",
            "description": "Benchmark SMTP/POP servers",
            "long_description": "Postal is a SMTP benchmark. Postal-list will list all the possible expansions for an account name (used for creating a list of accounts to create on your test server). Rabid is the mad Biff, it is a POP benchmark.",
            "active": true,
            "categories": [
                "mail",
                "benchmarks"
            ],
            "maintainers": [],
            "variants": [
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-14"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "gnutls"
                    ]
                }
            ],
            "depends_on": []
        }
    ]
}