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

{
    "count": 50885,
    "next": "https://ports.macports.org/api/v1/ports/?format=api&ordering=name&page=404",
    "previous": "https://ports.macports.org/api/v1/ports/?format=api&ordering=name&page=402",
    "results": [
        {
            "name": "pg12-postgis",
            "portdir": "databases/postgis",
            "version": "3.6.2",
            "license": "GPL-2+",
            "platforms": "darwin",
            "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": [
                "address_standardizer",
                "lto",
                "proj6",
                "proj7",
                "proj8",
                "proj9",
                "raster",
                "sfcgal",
                "topology",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "libxslt",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "libxml2",
                        "postgresql12",
                        "proj9",
                        "protobuf-c",
                        "gdal",
                        "geos",
                        "json-c",
                        "libiconv"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "pg12-pgrouting"
                    ]
                }
            ]
        },
        {
            "name": "pg12-postgis3",
            "portdir": "databases/postgis3",
            "version": "3.6.0",
            "license": "GPL-2+",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": "pg12-postgis",
            "homepage": "https://www.macports.org",
            "description": "Obsolete port, replaced by pg12-postgis",
            "long_description": "This port has been replaced by pg12-postgis.",
            "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": "pg12-postgis3-doc",
            "portdir": "databases/postgis3",
            "version": "3.6.0",
            "license": "GPL-2+",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://postgis.net/",
            "description": "Documentation of PostGIS for PostgreSQL 12",
            "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. This adds documentation.",
            "active": false,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 107
                },
                {
                    "name": "vince",
                    "github": "Veence",
                    "ports_count": 25
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "postgresql12",
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "protobuf-c",
                        "geos",
                        "libxslt",
                        "proj9",
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg12-postgis-doc",
            "portdir": "databases/postgis",
            "version": "3.6.2",
            "license": "GPL-2+",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://postgis.net/",
            "description": "Documentation of PostGIS for PostgreSQL 12",
            "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. This adds documentation.",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 107
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "postgresql12",
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "protobuf-c",
                        "geos",
                        "libxslt",
                        "proj9",
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg12-timescaledb",
            "portdir": "databases/timescaledb",
            "version": "2.11.2",
            "license": "Apache-2",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.timescaledb.com/",
            "description": "A time-series database that integrates with PostgreSQL.",
            "long_description": "TimescaleDB is an open-source database designed to make SQL scalable for time-series data. It is engineered up from PostgreSQL, providing automatic partitioning across time and space (partitioning key), as well as full SQL support. TimescaleDB is packaged as a PostgreSQL extension.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "blair",
                    "github": "blair",
                    "ports_count": 26
                }
            ],
            "variants": [
                "timescale_license",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "cmake",
                        "perl5.34",
                        "p5.34-ipc-run",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "postgresql12"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg13-pgpointcloud",
            "portdir": "databases/pgpointcloud",
            "version": "1.2.5",
            "license": "BSD",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://pgpointcloud.github.io/pointcloud/",
            "description": "pgPointcloud is a PostgreSQL extension for storing point cloud (LIDAR) data",
            "long_description": "pgPointcloud is a PostgreSQL extension for storing point cloud (LIDAR) data",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 107
                }
            ],
            "variants": [
                "tests",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "pkgconfig",
                        "clang-17"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "postgresql13",
                        "libxml2",
                        "zlib"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg13-pgrouting",
            "portdir": "gis/pgrouting",
            "version": "4.0.0",
            "license": "LGPL-2",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "http://www.pgrouting.org/",
            "description": "Routing algorithms for PostgreSQL/PostGIS",
            "long_description": "pgRouting is a PostGreSQL/PostGIS extension that contains a variety of algorithms to solve traditional network problems such as finding shortest paths or the Traveling Sales Person (TSP).",
            "active": true,
            "categories": [
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 107
                }
            ],
            "variants": [
                "debug",
                "doc",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "cmake",
                        "perl5",
                        "clang-20"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "postgresql13",
                        "boost176",
                        "pg13-postgis"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg13-postgis",
            "portdir": "databases/postgis",
            "version": "3.6.2",
            "license": "GPL-2+",
            "platforms": "darwin",
            "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": [
                "address_standardizer",
                "lto",
                "proj6",
                "proj7",
                "proj8",
                "proj9",
                "raster",
                "sfcgal",
                "topology",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "libxslt",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "libxml2",
                        "postgresql13",
                        "proj9",
                        "protobuf-c",
                        "gdal",
                        "geos",
                        "json-c",
                        "libiconv"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "pg13-pgrouting"
                    ]
                }
            ]
        },
        {
            "name": "pg13-postgis3",
            "portdir": "databases/postgis3",
            "version": "3.6.0",
            "license": "GPL-2+",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": "pg13-postgis",
            "homepage": "https://www.macports.org",
            "description": "Obsolete port, replaced by pg13-postgis",
            "long_description": "This port has been replaced by pg13-postgis.",
            "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": "pg13-postgis3-doc",
            "portdir": "databases/postgis3",
            "version": "3.6.0",
            "license": "GPL-2+",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://postgis.net/",
            "description": "Documentation of PostGIS for PostgreSQL 13",
            "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. This adds documentation.",
            "active": false,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 107
                },
                {
                    "name": "vince",
                    "github": "Veence",
                    "ports_count": 25
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "postgresql13",
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "protobuf-c",
                        "geos",
                        "libxslt",
                        "proj9",
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg13-postgis-doc",
            "portdir": "databases/postgis",
            "version": "3.6.2",
            "license": "GPL-2+",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://postgis.net/",
            "description": "Documentation of PostGIS for PostgreSQL 13",
            "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. This adds documentation.",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 107
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "postgresql13",
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "protobuf-c",
                        "geos",
                        "libxslt",
                        "proj9",
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg13-timescaledb",
            "portdir": "databases/timescaledb",
            "version": "2.15.3",
            "license": "Apache-2",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.timescaledb.com/",
            "description": "A time-series database that integrates with PostgreSQL.",
            "long_description": "TimescaleDB is an open-source database designed to make SQL scalable for time-series data. It is engineered up from PostgreSQL, providing automatic partitioning across time and space (partitioning key), as well as full SQL support. TimescaleDB is packaged as a PostgreSQL extension.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "blair",
                    "github": "blair",
                    "ports_count": 26
                }
            ],
            "variants": [
                "timescale_license",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "cmake",
                        "perl5.34",
                        "p5.34-ipc-run",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "postgresql13"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg14-pgpointcloud",
            "portdir": "databases/pgpointcloud",
            "version": "1.2.5",
            "license": "BSD",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://pgpointcloud.github.io/pointcloud/",
            "description": "pgPointcloud is a PostgreSQL extension for storing point cloud (LIDAR) data",
            "long_description": "pgPointcloud is a PostgreSQL extension for storing point cloud (LIDAR) data",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 107
                }
            ],
            "variants": [
                "tests",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "pkgconfig",
                        "clang-17"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "libxml2",
                        "postgresql14",
                        "zlib"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg14-pgrouting",
            "portdir": "gis/pgrouting",
            "version": "4.0.0",
            "license": "LGPL-2",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "http://www.pgrouting.org/",
            "description": "Routing algorithms for PostgreSQL/PostGIS",
            "long_description": "pgRouting is a PostGreSQL/PostGIS extension that contains a variety of algorithms to solve traditional network problems such as finding shortest paths or the Traveling Sales Person (TSP).",
            "active": true,
            "categories": [
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 107
                }
            ],
            "variants": [
                "debug",
                "doc",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "cmake",
                        "perl5",
                        "clang-20"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "boost176",
                        "postgresql14",
                        "pg14-postgis"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg14-postgis",
            "portdir": "databases/postgis",
            "version": "3.6.2",
            "license": "GPL-2+",
            "platforms": "darwin",
            "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": [
                "address_standardizer",
                "lto",
                "proj6",
                "proj7",
                "proj8",
                "proj9",
                "raster",
                "sfcgal",
                "topology",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "libxslt",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "postgresql14",
                        "protobuf-c",
                        "proj9",
                        "gdal",
                        "geos",
                        "json-c",
                        "libiconv",
                        "libxml2"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "pg14-pgrouting"
                    ]
                }
            ]
        },
        {
            "name": "pg14-postgis3",
            "portdir": "databases/postgis3",
            "version": "3.6.0",
            "license": "GPL-2+",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": "pg14-postgis",
            "homepage": "https://www.macports.org",
            "description": "Obsolete port, replaced by pg14-postgis",
            "long_description": "This port has been replaced by pg14-postgis.",
            "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": "pg14-postgis3-doc",
            "portdir": "databases/postgis3",
            "version": "3.6.0",
            "license": "GPL-2+",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://postgis.net/",
            "description": "Documentation of PostGIS for PostgreSQL 14",
            "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. This adds documentation.",
            "active": false,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 107
                },
                {
                    "name": "vince",
                    "github": "Veence",
                    "ports_count": 25
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "protobuf-c",
                        "geos",
                        "libxslt",
                        "postgresql14",
                        "proj9",
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg14-postgis-doc",
            "portdir": "databases/postgis",
            "version": "3.6.2",
            "license": "GPL-2+",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://postgis.net/",
            "description": "Documentation of PostGIS for PostgreSQL 14",
            "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. This adds documentation.",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 107
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "protobuf-c",
                        "geos",
                        "libxslt",
                        "postgresql14",
                        "proj9",
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg14-timescaledb",
            "portdir": "databases/timescaledb",
            "version": "2.19.3",
            "license": "Apache-2",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.timescaledb.com/",
            "description": "A time-series database that integrates with PostgreSQL.",
            "long_description": "TimescaleDB is an open-source database designed to make SQL scalable for time-series data. It is engineered up from PostgreSQL, providing automatic partitioning across time and space (partitioning key), as well as full SQL support. TimescaleDB is packaged as a PostgreSQL extension.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "blair",
                    "github": "blair",
                    "ports_count": 26
                }
            ],
            "variants": [
                "timescale_license",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "cmake",
                        "perl5.34",
                        "p5.34-ipc-run",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "postgresql14"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg15-pgpointcloud",
            "portdir": "databases/pgpointcloud",
            "version": "1.2.5",
            "license": "BSD",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://pgpointcloud.github.io/pointcloud/",
            "description": "pgPointcloud is a PostgreSQL extension for storing point cloud (LIDAR) data",
            "long_description": "pgPointcloud is a PostgreSQL extension for storing point cloud (LIDAR) data",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 107
                }
            ],
            "variants": [
                "tests",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "pkgconfig",
                        "clang-17"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "libxml2",
                        "postgresql15",
                        "zlib"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg15-pgrouting",
            "portdir": "gis/pgrouting",
            "version": "4.0.0",
            "license": "LGPL-2",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "http://www.pgrouting.org/",
            "description": "Routing algorithms for PostgreSQL/PostGIS",
            "long_description": "pgRouting is a PostGreSQL/PostGIS extension that contains a variety of algorithms to solve traditional network problems such as finding shortest paths or the Traveling Sales Person (TSP).",
            "active": true,
            "categories": [
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 107
                }
            ],
            "variants": [
                "debug",
                "doc",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "cmake",
                        "perl5",
                        "clang-20"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "boost176",
                        "postgresql15",
                        "pg15-postgis"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg15-postgis",
            "portdir": "databases/postgis",
            "version": "3.6.2",
            "license": "GPL-2+",
            "platforms": "darwin",
            "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": [
                "address_standardizer",
                "lto",
                "proj6",
                "proj7",
                "proj8",
                "proj9",
                "raster",
                "sfcgal",
                "topology",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "libxslt",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "proj9",
                        "protobuf-c",
                        "postgresql15",
                        "gdal",
                        "geos",
                        "json-c",
                        "libiconv",
                        "libxml2"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "pg15-pgrouting"
                    ]
                }
            ]
        },
        {
            "name": "pg15-postgis3",
            "portdir": "databases/postgis3",
            "version": "3.6.0",
            "license": "GPL-2+",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": "pg15-postgis",
            "homepage": "https://www.macports.org",
            "description": "Obsolete port, replaced by pg15-postgis",
            "long_description": "This port has been replaced by pg15-postgis.",
            "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": "pg15-postgis3-doc",
            "portdir": "databases/postgis3",
            "version": "3.6.0",
            "license": "GPL-2+",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://postgis.net/",
            "description": "Documentation of PostGIS for PostgreSQL 15",
            "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. This adds documentation.",
            "active": false,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 107
                },
                {
                    "name": "vince",
                    "github": "Veence",
                    "ports_count": 25
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "protobuf-c",
                        "geos",
                        "libxslt",
                        "proj9",
                        "postgresql15",
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg15-postgis-doc",
            "portdir": "databases/postgis",
            "version": "3.6.2",
            "license": "GPL-2+",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://postgis.net/",
            "description": "Documentation of PostGIS for PostgreSQL 15",
            "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. This adds documentation.",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 107
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "protobuf-c",
                        "geos",
                        "libxslt",
                        "proj9",
                        "postgresql15",
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg15-timescaledb",
            "portdir": "databases/timescaledb",
            "version": "2.25.0",
            "license": "Apache-2",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.timescaledb.com/",
            "description": "A time-series database that integrates with PostgreSQL.",
            "long_description": "TimescaleDB is an open-source database designed to make SQL scalable for time-series data. It is engineered up from PostgreSQL, providing automatic partitioning across time and space (partitioning key), as well as full SQL support. TimescaleDB is packaged as a PostgreSQL extension.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "blair",
                    "github": "blair",
                    "ports_count": 26
                }
            ],
            "variants": [
                "timescale_license",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "cmake",
                        "perl5.34",
                        "p5.34-ipc-run",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "postgresql15"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg16-pgpointcloud",
            "portdir": "databases/pgpointcloud",
            "version": "1.2.5",
            "license": "BSD",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://pgpointcloud.github.io/pointcloud/",
            "description": "pgPointcloud is a PostgreSQL extension for storing point cloud (LIDAR) data",
            "long_description": "pgPointcloud is a PostgreSQL extension for storing point cloud (LIDAR) data",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 107
                }
            ],
            "variants": [
                "tests",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "pkgconfig",
                        "clang-17"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "libxml2",
                        "postgresql16",
                        "zlib"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg16-pgrouting",
            "portdir": "gis/pgrouting",
            "version": "4.0.0",
            "license": "LGPL-2",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "http://www.pgrouting.org/",
            "description": "Routing algorithms for PostgreSQL/PostGIS",
            "long_description": "pgRouting is a PostGreSQL/PostGIS extension that contains a variety of algorithms to solve traditional network problems such as finding shortest paths or the Traveling Sales Person (TSP).",
            "active": true,
            "categories": [
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 107
                }
            ],
            "variants": [
                "debug",
                "doc",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "cmake",
                        "perl5",
                        "clang-20"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "boost176",
                        "postgresql16",
                        "pg16-postgis"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg16-postgis",
            "portdir": "databases/postgis",
            "version": "3.6.2",
            "license": "GPL-2+",
            "platforms": "darwin",
            "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": [
                "address_standardizer",
                "lto",
                "proj6",
                "proj7",
                "proj8",
                "proj9",
                "raster",
                "sfcgal",
                "topology",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "libxslt",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "proj9",
                        "protobuf-c",
                        "postgresql16",
                        "gdal",
                        "geos",
                        "json-c",
                        "libiconv",
                        "libxml2"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "pg16-pgrouting",
                        "tinyows"
                    ]
                }
            ]
        },
        {
            "name": "pg16-postgis3",
            "portdir": "databases/postgis3",
            "version": "3.6.0",
            "license": "GPL-2+",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": "pg16-postgis",
            "homepage": "https://www.macports.org",
            "description": "Obsolete port, replaced by pg16-postgis",
            "long_description": "This port has been replaced by pg16-postgis.",
            "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": [
                {
                    "type": "lib",
                    "ports": [
                        "osm2pgsql-lua"
                    ]
                }
            ]
        },
        {
            "name": "pg16-postgis3-doc",
            "portdir": "databases/postgis3",
            "version": "3.6.0",
            "license": "GPL-2+",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://postgis.net/",
            "description": "Documentation of PostGIS for PostgreSQL 16",
            "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. This adds documentation.",
            "active": false,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 107
                },
                {
                    "name": "vince",
                    "github": "Veence",
                    "ports_count": 25
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "protobuf-c",
                        "geos",
                        "libxslt",
                        "proj9",
                        "postgresql16",
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg16-postgis-doc",
            "portdir": "databases/postgis",
            "version": "3.6.2",
            "license": "GPL-2+",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://postgis.net/",
            "description": "Documentation of PostGIS for PostgreSQL 16",
            "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. This adds documentation.",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 107
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "protobuf-c",
                        "geos",
                        "libxslt",
                        "proj9",
                        "postgresql16",
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg16-timescaledb",
            "portdir": "databases/timescaledb",
            "version": "2.25.0",
            "license": "Apache-2",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.timescaledb.com/",
            "description": "A time-series database that integrates with PostgreSQL.",
            "long_description": "TimescaleDB is an open-source database designed to make SQL scalable for time-series data. It is engineered up from PostgreSQL, providing automatic partitioning across time and space (partitioning key), as well as full SQL support. TimescaleDB is packaged as a PostgreSQL extension.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "blair",
                    "github": "blair",
                    "ports_count": 26
                }
            ],
            "variants": [
                "timescale_license",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "cmake",
                        "perl5.34",
                        "p5.34-ipc-run",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "postgresql16"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg17-pgpointcloud",
            "portdir": "databases/pgpointcloud",
            "version": "1.2.5",
            "license": "BSD",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://pgpointcloud.github.io/pointcloud/",
            "description": "pgPointcloud is a PostgreSQL extension for storing point cloud (LIDAR) data",
            "long_description": "pgPointcloud is a PostgreSQL extension for storing point cloud (LIDAR) data",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 107
                }
            ],
            "variants": [
                "tests",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "pkgconfig",
                        "clang-17"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "libxml2",
                        "postgresql17",
                        "zlib"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "pdal-pgpointcloud"
                    ]
                }
            ]
        },
        {
            "name": "pg17-pgrouting",
            "portdir": "gis/pgrouting",
            "version": "4.0.0",
            "license": "LGPL-2",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "http://www.pgrouting.org/",
            "description": "Routing algorithms for PostgreSQL/PostGIS",
            "long_description": "pgRouting is a PostGreSQL/PostGIS extension that contains a variety of algorithms to solve traditional network problems such as finding shortest paths or the Traveling Sales Person (TSP).",
            "active": true,
            "categories": [
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 107
                }
            ],
            "variants": [
                "debug",
                "doc",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "cmake",
                        "perl5",
                        "clang-20"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "boost176",
                        "postgresql17",
                        "pg17-postgis"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg17-postgis",
            "portdir": "databases/postgis",
            "version": "3.6.2",
            "license": "GPL-2+",
            "platforms": "darwin",
            "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": [
                "address_standardizer",
                "lto",
                "proj6",
                "proj7",
                "proj8",
                "proj9",
                "raster",
                "sfcgal",
                "topology",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "libxslt",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "proj9",
                        "protobuf-c",
                        "postgresql17",
                        "gdal",
                        "geos",
                        "json-c",
                        "libiconv",
                        "libxml2"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "mod_tile",
                        "pg17-pgrouting",
                        "osm2pgrouting",
                        "osm2pgsql"
                    ]
                }
            ]
        },
        {
            "name": "pg17-postgis3",
            "portdir": "databases/postgis3",
            "version": "3.6.0",
            "license": "GPL-2+",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": "pg17-postgis",
            "homepage": "https://www.macports.org",
            "description": "Obsolete port, replaced by pg17-postgis",
            "long_description": "This port has been replaced by pg17-postgis.",
            "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": "pg17-postgis3-doc",
            "portdir": "databases/postgis3",
            "version": "3.6.0",
            "license": "GPL-2+",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://postgis.net/",
            "description": "Documentation of PostGIS for PostgreSQL 17",
            "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. This adds documentation.",
            "active": false,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 107
                },
                {
                    "name": "vince",
                    "github": "Veence",
                    "ports_count": 25
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "protobuf-c",
                        "geos",
                        "libxslt",
                        "proj9",
                        "clang-18",
                        "postgresql17"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg17-postgis-doc",
            "portdir": "databases/postgis",
            "version": "3.6.2",
            "license": "GPL-2+",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://postgis.net/",
            "description": "Documentation of PostGIS for PostgreSQL 17",
            "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. This adds documentation.",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 107
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "protobuf-c",
                        "geos",
                        "libxslt",
                        "proj9",
                        "clang-18",
                        "postgresql17"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg17-timescaledb",
            "portdir": "databases/timescaledb",
            "version": "2.25.0",
            "license": "Apache-2",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.timescaledb.com/",
            "description": "A time-series database that integrates with PostgreSQL.",
            "long_description": "TimescaleDB is an open-source database designed to make SQL scalable for time-series data. It is engineered up from PostgreSQL, providing automatic partitioning across time and space (partitioning key), as well as full SQL support. TimescaleDB is packaged as a PostgreSQL extension.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "blair",
                    "github": "blair",
                    "ports_count": 26
                }
            ],
            "variants": [
                "timescale_license",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "cmake",
                        "perl5.34",
                        "p5.34-ipc-run",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "postgresql17"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg18-timescaledb",
            "portdir": "databases/timescaledb",
            "version": "2.25.0",
            "license": "Apache-2",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.timescaledb.com/",
            "description": "A time-series database that integrates with PostgreSQL.",
            "long_description": "TimescaleDB is an open-source database designed to make SQL scalable for time-series data. It is engineered up from PostgreSQL, providing automatic partitioning across time and space (partitioning key), as well as full SQL support. TimescaleDB is packaged as a PostgreSQL extension.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "blair",
                    "github": "blair",
                    "ports_count": 26
                }
            ],
            "variants": [
                "timescale_license",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "cmake",
                        "perl5.34",
                        "p5.34-ipc-run",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "postgresql18"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "timescaledb"
                    ]
                }
            ]
        },
        {
            "name": "pg2xbase",
            "portdir": "databases/pg2xbase",
            "version": "2.4.1",
            "license": "unknown",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://web.archive.org/web/20080504010314/http://www.klaban.torun.pl/prog/pg2xbase/",
            "description": "Convert data between PostgreSQL and DBF files",
            "long_description": "pg2xbase provides utilities for converting between PostgreSQL databases and DBF files.",
            "active": false,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-15"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "postgresql81",
                        "xbase"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pgAdmin3",
            "portdir": "aqua/pgAdmin3",
            "version": "1.22.2",
            "license": "Permissive",
            "platforms": "macosx",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.pgadmin.org",
            "description": "An administration program to PostgreSQL",
            "long_description": "pgAdmin III is a powerful administration and development platform for the PostgreSQL database, free for any use. The application works on several platforms, e.g. GNU/Linux, FreeBSD, OS X and Windows 2000/XP. This port is for OS X.",
            "active": true,
            "categories": [
                "aqua"
            ],
            "maintainers": [],
            "variants": [
                "postgresql91",
                "postgresql92",
                "postgresql93",
                "postgresql94",
                "postgresql95",
                "postgresql96",
                "debug"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-17"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "libgcrypt",
                        "openssl",
                        "postgresql96",
                        "libxml2",
                        "libxslt",
                        "wxWidgets-3.0"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg_back",
            "portdir": "databases/pg_back",
            "version": "2.6.0",
            "license": "MIT",
            "platforms": "darwin freebsd linux",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://github.com/orgrim/pg_back",
            "description": "Simple backup tool for PostgreSQL",
            "long_description": "pg_back is a dump tool for PostgreSQL. The goal is to dump all or some databases with globals at once in the format you want, because a simple call to pg_dumpall only dumps databases in the plain SQL format. Behind the scene, pg_back uses pg_dumpall to dump roles and tablespaces definitions, pg_dump to dump all or each selected database to a separate file in the custom format. It also extract database level ACL and configuration that is not dumped by pg_dump older than 11. Finally, it dumps all configuration options of the PostgreSQL instance.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "herby.gillot",
                    "github": "herbygillot",
                    "ports_count": 1031
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "go",
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pgbadger",
            "portdir": "databases/pgbadger",
            "version": "13.2",
            "license": "BSD",
            "platforms": "{darwin any}",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://pgbadger.darold.net/",
            "description": "PostgreSQL log analyzer with fully detailed reports and graphs.",
            "long_description": "pgBadger is a PostgreSQL log analyzer built for speed with fully reports from your PostgreSQL log file. It's a single and small Perl script that outperforms any other PostgreSQL log analyzer.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [
                "perl5_28",
                "perl5_30",
                "perl5_32",
                "perl5_34"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "perl5.34",
                        "p5.34-json-xs",
                        "p5.34-text-csv_xs"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pgbouncer",
            "portdir": "databases/pgbouncer",
            "version": "1.23.1",
            "license": "ISC",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.pgbouncer.org",
            "description": "Lightweight connection pooler for PostgreSQL",
            "long_description": "pgbouncer is a PostgreSQL connection pooler. Any target application can be connected to pgbouncer as if it were a PostgreSQL server, and pgbouncer will manage to connect to the server, or to reuse one of its existing connections.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "herby.gillot",
                    "github": "herbygillot",
                    "ports_count": 1031
                }
            ],
            "variants": [
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "gmake",
                        "pkgconfig",
                        "clang-16"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "libevent",
                        "openssl",
                        "c-ares"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pgcli",
            "portdir": "databases/pgcli",
            "version": "4.3.0",
            "license": "BSD",
            "platforms": "{darwin any}",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://pgcli.com",
            "description": "Postgres CLI with autocompletion and syntax highlighting",
            "long_description": "Postgres CLI with autocompletion and syntax highlighting",
            "active": true,
            "categories": [
                "databases",
                "python"
            ],
            "maintainers": [],
            "variants": [
                "python310",
                "python311",
                "python312",
                "python313"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18",
                        "py313-build",
                        "py313-installer",
                        "py313-setuptools",
                        "py313-wheel"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "py313-keyring",
                        "py313-configobj",
                        "py313-setproctitle",
                        "python313",
                        "py313-cli-helpers",
                        "py313-pgspecial",
                        "py313-psycopg",
                        "py313-tzlocal",
                        "py313-prompt_toolkit",
                        "py313-pygments",
                        "py313-click",
                        "py313-sqlparse"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pgf",
            "portdir": "tex/pgf",
            "version": "3.1.5b",
            "license": "none",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": "texlive-pictures",
            "homepage": "https://www.macports.org",
            "description": "Obsolete port, replaced by texlive-pictures",
            "long_description": "This port has been replaced by texlive-pictures.",
            "active": false,
            "categories": [],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-9.0"
                    ]
                },
                {
                    "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": "pgFormatter",
            "portdir": "databases/pgFormatter",
            "version": "5.9",
            "license": "PostgreSQL",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://github.com/darold/pgFormatter",
            "description": "PostgreSQL SQL syntax beautifier",
            "long_description": "This SQL formatter/beautifier supports keywords from SQL-92, SQL-99, SQL-2003, SQL-2008, SQL-2011 and PostgreSQL specifics keywords. Works with any other databases too. pgFormatter can work as a console program or as a CGI. It will automatically detect its environment and format output as text or as HTML following the context. It can also return a JSON-formatted response if used as CGI with 'Accept: application/json'. Keywords highlighting will only be available in CGI context.",
            "active": true,
            "categories": [
                "devel",
                "databases",
                "textproc"
            ],
            "maintainers": [
                {
                    "name": "danchr",
                    "github": "danchr",
                    "ports_count": 175
                }
            ],
            "variants": [
                "perl5_34"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "perl5.34"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pgintcl",
            "portdir": "databases/pgintcl",
            "version": "3.4.0",
            "license": "unknown",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "http://pgintcl.sourceforge.net/",
            "description": "Pure Tcl PostgreSQL interface",
            "long_description": "This is a Tcl interface to PostgreSQL, which is itself written entirely in Tcl, and does not rely on libpq. It is highly but not entirely compatible with other Tcl interfaces, although it is slower.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-9.0"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "tcl"
                    ]
                }
            ],
            "depends_on": []
        }
    ]
}