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

{
    "count": 50173,
    "next": "https://ports.macports.org/api/v1/ports/?format=api&page=978",
    "previous": "https://ports.macports.org/api/v1/ports/?format=api&page=976",
    "results": [
        {
            "name": "postgresql95-doc",
            "portdir": "databases/postgresql95-doc",
            "version": "9.5.25",
            "license": "Permissive",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "Documentation for the PostgreSQL database version 9.5",
            "long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity. This is the documentation.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "jwa",
                    "github": "jyrkiwahlstedt",
                    "ports_count": 37
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-16"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql95",
            "portdir": "databases/postgresql95",
            "version": "9.5.25",
            "license": "Permissive",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "The most advanced open-source database available anywhere.",
            "long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "jwa",
                    "github": "jyrkiwahlstedt",
                    "ports_count": 37
                }
            ],
            "variants": [
                "python",
                "python27",
                "python3",
                "perl",
                "tcl",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18",
                        "bison"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "libxml2",
                        "libxslt",
                        "zlib",
                        "openssl3",
                        "readline"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql_select-95"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "run",
                    "ports": [
                        "postgresql95-server"
                    ]
                }
            ]
        },
        {
            "name": "postgresql94-server",
            "portdir": "databases/postgresql94-server",
            "version": "9.4.26",
            "license": "Permissive",
            "platforms": "{darwin any}",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "run postgresql94 as server",
            "long_description": "run postgresql94 as server",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "jwa",
                    "github": "jyrkiwahlstedt",
                    "ports_count": 37
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql94"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql94-doc",
            "portdir": "databases/postgresql94-doc",
            "version": "9.4.26",
            "license": "Permissive",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "Documentation for the PostgreSQL database version 9.4",
            "long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity. This is the documentation.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "jwa",
                    "github": "jyrkiwahlstedt",
                    "ports_count": 37
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-16"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql94",
            "portdir": "databases/postgresql94",
            "version": "9.4.26",
            "license": "Permissive",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "The most advanced open-source database available anywhere.",
            "long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "jwa",
                    "github": "jyrkiwahlstedt",
                    "ports_count": 37
                }
            ],
            "variants": [
                "python",
                "python27",
                "perl",
                "tcl",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18",
                        "bison"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "libxml2",
                        "libxslt",
                        "zlib",
                        "openssl11",
                        "readline"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql_select-94"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "run",
                    "ports": [
                        "postgresql94-server"
                    ]
                }
            ]
        },
        {
            "name": "postgresql93-server",
            "portdir": "databases/postgresql93-server",
            "version": "9.3.25",
            "license": "Permissive",
            "platforms": "{darwin any}",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "run postgresql93 as server",
            "long_description": "run postgresql93 as server",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "jwa",
                    "github": "jyrkiwahlstedt",
                    "ports_count": 37
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql93"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql93-doc",
            "portdir": "databases/postgresql93-doc",
            "version": "9.3.25",
            "license": "Permissive",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "Documentation for the PostgreSQL database version 9.3",
            "long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity. This is the documentation.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "jwa",
                    "github": "jyrkiwahlstedt",
                    "ports_count": 37
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-16"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql93",
            "portdir": "databases/postgresql93",
            "version": "9.3.25",
            "license": "Permissive",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "The most advanced open-source database available anywhere.",
            "long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "jwa",
                    "github": "jyrkiwahlstedt",
                    "ports_count": 37
                }
            ],
            "variants": [
                "python",
                "python27",
                "krb5",
                "perl",
                "tcl",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18",
                        "bison"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "readline",
                        "libxml2",
                        "zlib",
                        "openssl11",
                        "libxslt",
                        "ossp-uuid"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql_select-93"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "run",
                    "ports": [
                        "postgresql93-server"
                    ]
                }
            ]
        },
        {
            "name": "postgresql92-server",
            "portdir": "databases/postgresql92-server",
            "version": "9.2.24",
            "license": "Permissive",
            "platforms": "{darwin any}",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "run postgresql92 as server",
            "long_description": "run postgresql92 as server",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql92"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql92-doc",
            "portdir": "databases/postgresql92-doc",
            "version": "9.2.24",
            "license": "Permissive",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "Documentation for the PostgreSQL database version 9.2",
            "long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity. This is the documentation.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql92",
            "portdir": "databases/postgresql92",
            "version": "9.2.24",
            "license": "Permissive",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "The most advanced open-source database available anywhere.",
            "long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [
                "python",
                "python27",
                "krb5",
                "perl",
                "tcl",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18",
                        "bison"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "readline",
                        "libxml2",
                        "zlib",
                        "openssl11",
                        "libxslt",
                        "ossp-uuid"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql_select-92"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "py27-pygresql",
                        "postgis",
                        "py37-pygresql",
                        "qt4-mac-postgresql92-plugin",
                        "libzdb-postgresql92"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql92-server"
                    ]
                }
            ]
        },
        {
            "name": "postgresql91-server",
            "portdir": "databases/postgresql91-server",
            "version": "9.1.24",
            "license": "Permissive",
            "platforms": "{darwin any}",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "run postgresql91 as server",
            "long_description": "run postgresql91 as server",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql91"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql91-doc",
            "portdir": "databases/postgresql91-doc",
            "version": "9.1.24",
            "license": "Permissive",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "Documentation for the PostgreSQL database version 9.1",
            "long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity. This is the documentation.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql91",
            "portdir": "databases/postgresql91",
            "version": "9.1.24",
            "license": "Permissive",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "The most advanced open-source database available anywhere.",
            "long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [
                "python",
                "python27",
                "krb5",
                "perl",
                "tcl",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18",
                        "bison"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "ossp-uuid",
                        "readline",
                        "zlib",
                        "libxslt",
                        "libxml2",
                        "openssl10"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql_select-91"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "qt4-mac-postgresql91-plugin",
                        "libzdb-postgresql91"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql91-server"
                    ]
                }
            ]
        },
        {
            "name": "postgresql90-server",
            "portdir": "databases/postgresql90-server",
            "version": "9.0.23",
            "license": "Permissive",
            "platforms": "{darwin any}",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "run postgresql90 as server",
            "long_description": "run postgresql90 as server",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql90"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "run",
                    "ports": [
                        "iplike"
                    ]
                }
            ]
        },
        {
            "name": "postgresql90-doc",
            "portdir": "databases/postgresql90-doc",
            "version": "9.0.23",
            "license": "Permissive",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "Documentation for the PostgreSQL database version 9.0",
            "long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity. This is the documentation.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql90",
            "portdir": "databases/postgresql90",
            "version": "9.0.23",
            "license": "Permissive",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "The most advanced open-source database available anywhere.",
            "long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [
                "python",
                "python27",
                "krb5",
                "perl",
                "tcl",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18",
                        "bison"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "ossp-uuid",
                        "readline",
                        "zlib",
                        "libxslt",
                        "libxml2",
                        "openssl10"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql_select-90"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "build",
                    "ports": [
                        "postgresql-unaccent"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "qt4-mac-postgresql90-plugin",
                        "libzdb-postgresql90"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql90-server"
                    ]
                }
            ]
        },
        {
            "name": "postgresql84-server",
            "portdir": "databases/postgresql84-server",
            "version": "8.4.22",
            "license": "Permissive",
            "platforms": "{darwin any}",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "run postgresql84 as server",
            "long_description": "run postgresql84 as server",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql84"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql84-doc",
            "portdir": "databases/postgresql84-doc",
            "version": "8.4.22",
            "license": "Permissive",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "Documentation for the PostgreSQL database version 8.4",
            "long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity. This is the documentation.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql84",
            "portdir": "databases/postgresql84",
            "version": "8.4.22",
            "license": "Permissive",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "The most advanced open-source database available anywhere.",
            "long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [
                "python",
                "python27",
                "krb5",
                "perl",
                "tcl",
                "earthdistance",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18",
                        "bison"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "ossp-uuid",
                        "readline",
                        "zlib",
                        "libxslt",
                        "libxml2",
                        "openssl10"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql_select-84"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "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": "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": "postgresql-unaccent",
            "portdir": "databases/postgresql-unaccent",
            "version": "0.1",
            "license": "unknown",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "http://launchpad.net/postgresql-unaccent/",
            "description": "PostgreSQL extension that provides a function to remove accents from characters",
            "long_description": "postgresql-unaccent is a PostgreSQL extension that provides a function to remove accents from characters (not compatible with the version bundled in postgresql90)",
            "active": false,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [
                "postgresql82",
                "postgresql83",
                "postgresql84",
                "postgresql90",
                "postgresql91"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "postgresql90",
                        "clang-9.0"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "unac"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "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": "pgtcl",
            "portdir": "databases/pgtcl",
            "version": "3.1.1",
            "license": "BSD",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://flightaware.github.io/Pgtcl/",
            "description": "Tcl PostgreSQL interface",
            "long_description": "Tcl client interface to PostgreSQL",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "libtool",
                        "clang-17"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "tcl",
                        "postgresql16",
                        "sqlite3"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pgsqlclient",
            "portdir": "databases/pgsqlclient",
            "version": "1.0-Beta6",
            "license": "LGPL-2.1+",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "http://pgsqlclient.sourceforge.net/",
            "description": "ADO.NET adapter for PostgreSQL",
            "long_description": "ADO.NET adapter for PostgreSQL",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-9.0"
                    ]
                },
                {
                    "type": "extract",
                    "ports": [
                        "unzip"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "mono"
                    ]
                }
            ],
            "depends_on": []
        }
    ]
}