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

{
    "count": 51929,
    "next": "https://ports.macports.org/api/v1/ports/?format=api&ordering=-name&page=598",
    "previous": "https://ports.macports.org/api/v1/ports/?format=api&ordering=-name&page=596",
    "results": [
        {
            "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": "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.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": "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": "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": [
                        "qgis3",
                        "py39-psycopg2",
                        "qt6-psql-plugin",
                        "qt610-psql-plugin",
                        "qt68-psql-plugin",
                        "qt69-psql-plugin",
                        "pg17-pgpointcloud",
                        "pg17-postgis",
                        "py314-psycopg2",
                        "grass",
                        "py39-psycopg",
                        "pg17-timescaledb",
                        "gdal",
                        "mapnik",
                        "mod_tile",
                        "openstreetmap-carto",
                        "osm2pgrouting",
                        "osm2pgsql",
                        "pdal-pgpointcloud",
                        "pg17-pgrouting",
                        "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-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": "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": "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"
                    ]
                }
            ]
        },
        {
            "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": 44
                }
            ],
            "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": 44
                }
            ],
            "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": 146
                }
            ],
            "variants": [
                "clang13",
                "clang14",
                "clang15",
                "clang16",
                "clang17",
                "clang18",
                "clang19",
                "clang20",
                "clang21",
                "clang22",
                "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-postgis-doc",
                        "pg13-postgis3-doc"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "pg13-postgis",
                        "pg13-pgrouting",
                        "pg13-timescaledb",
                        "pg13-pgpointcloud"
                    ]
                },
                {
                    "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": 44
                }
            ],
            "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": 44
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "docbook-xml-4.5",
                        "docbook-xsl-nons",
                        "clang-18"
                    ]
                }
            ],
            "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",
                "clang22",
                "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-postgis3-doc",
                        "pg12-postgis-doc"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "postgis2",
                        "pg12-postgis",
                        "pg12-pgrouting",
                        "pg12-pgpointcloud",
                        "p5.26-dbd-pg",
                        "timescaledb1",
                        "pg12-timescaledb"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql12-server"
                    ]
                }
            ]
        },
        {
            "name": "postgresql11-server",
            "portdir": "databases/postgresql11-server",
            "version": "11.22",
            "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": 44
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql11"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql11-doc",
            "portdir": "databases/postgresql11-doc",
            "version": "11.22",
            "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": 44
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql11",
            "portdir": "databases/postgresql11",
            "version": "11.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": "jwa",
                    "github": "jyrkiwahlstedt",
                    "ports_count": 44
                }
            ],
            "variants": [
                "clang13",
                "clang14",
                "clang15",
                "clang16",
                "clang17",
                "clang18",
                "clang19",
                "clang20",
                "clang21",
                "clang22",
                "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.23",
            "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": 44
                }
            ],
            "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.23",
            "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": 44
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql10",
            "portdir": "databases/postgresql10",
            "version": "10.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": "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",
                        "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": 25
                }
            ],
            "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.2",
            "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": 107
                }
            ],
            "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.11.2",
            "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": 353
                }
            ],
            "variants": [
                "universal",
                "dovecot_sasl",
                "ldap",
                "pcre",
                "pcre2",
                "sasl",
                "smtputf8",
                "tls",
                "mariadb10.5",
                "mariadb10.6",
                "mariadb10.11",
                "mariadb11.4",
                "mysql8",
                "postgresql13",
                "postgresql14",
                "postgresql15",
                "postgresql16",
                "postgresql17",
                "postgresql18",
                "postgresql12",
                "mariadb10.4"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "mail-server",
                        "mailqfmt",
                        "sympa",
                        "vm-pop3d",
                        "argus-monitor"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "sqlgrey",
                        "postfixadmin",
                        "ddclient"
                    ]
                }
            ]
        },
        {
            "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-18"
                    ]
                }
            ],
            "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-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "gnutls"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "posix-manpages",
            "portdir": "devel/posix-manpages",
            "version": "2017",
            "license": "Permissive",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://pubs.opengroup.org/onlinepubs/9699919799/",
            "description": "POSIX manpages",
            "long_description": "Manpages for POSIX (IEEE Std 1003.1) including headers, utilities and functions.",
            "active": true,
            "categories": [
                "devel"
            ],
            "maintainers": [
                {
                    "name": "makr",
                    "github": "mohd-akram",
                    "ports_count": 84
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "posix-macos-addons",
            "portdir": "devel/posix-macos-addons",
            "version": "20211014",
            "license": "Apache-2",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://github.com/stanislaw/posix-macos-addons",
            "description": "Some missing bits of POSIX for macOS.",
            "long_description": "This is a collection of the POSIX functions which are not available on macOS.",
            "active": true,
            "categories": [
                "devel"
            ],
            "maintainers": [],
            "variants": [
                "debug",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "cmake",
                        "clang-18"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "build",
                    "ports": [
                        "ecgen"
                    ]
                }
            ]
        },
        {
            "name": "posh",
            "portdir": "shells/posh",
            "version": "0.14.1",
            "license": "GPL-3+",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://salsa.debian.org/clint/posh",
            "description": "Policy-compliant ordinary shell",
            "long_description": "posh is a stripped-down version of pdksh that aims for compliance with Debian's policy, and few extra features.",
            "active": true,
            "categories": [
                "shells"
            ],
            "maintainers": [],
            "variants": [
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "libtool",
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "port-whatsnew",
            "portdir": "sysutils/port-whatsnew",
            "version": "0.1",
            "license": "BSD",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://github.com/macports/macports-contrib/blob/master/port-whatsnew",
            "description": "shows a log of what changed since this port was installed",
            "long_description": "port-whatsnew shows a log of what changed since this port was installed.",
            "active": true,
            "categories": [
                "sysutils",
                "macports"
            ],
            "maintainers": [
                {
                    "name": "egall",
                    "github": "cooljeanius",
                    "ports_count": 3
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "portsentry",
            "portdir": "security/portsentry",
            "version": "1.2",
            "license": "CPL-1",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://sourceforge.net/projects/sentrytools/",
            "description": "port scan detection and active defense",
            "long_description": "PortSentry is part of the Abacus Project suite of security tools. It is a program designed to detect and respond to port scans against a target host in real-time. There are other port scan detectors that perform similar detection of scans, but PortSentry has some unique features that may make it worth looking into.",
            "active": true,
            "categories": [
                "security"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        }
    ]
}