HTTP 200 OK
Allow: GET, HEAD, OPTIONS
Content-Type: application/json
Vary: Accept
{
"count": 51640,
"next": "https://ports.macports.org/api/v1/ports/?format=api&ordering=-name&page=630",
"previous": "https://ports.macports.org/api/v1/ports/?format=api&ordering=-name&page=628",
"results": [
{
"name": "phetch",
"portdir": "net/phetch",
"version": "1.2.0",
"license": "MIT",
"platforms": "darwin",
"epoch": 0,
"replaced_by": null,
"homepage": "https://github.com/xvxx/phetch",
"description": "A terminal client designed to help you quickly navigate the gophersphere.",
"long_description": "Phetch is a Gopher terminal client written entirely in Rust. It supports Gopher searches, text and menu pages, and downloads. Moreover, Phetch features opt-in history tracking, TLS support, and Tor support.",
"active": true,
"categories": [
"net"
],
"maintainers": [
{
"name": "",
"github": "kakuhen",
"ports_count": 9
}
],
"variants": [
"universal"
],
"dependencies": [
{
"type": "build",
"ports": [
"cargo",
"legacy-support",
"rust",
"clang-17"
]
},
{
"type": "lib",
"ports": [
"libunwind"
]
}
],
"depends_on": []
},
{
"name": "pHash",
"portdir": "multimedia/pHash",
"version": "0.9.6",
"license": "GPL-3",
"platforms": "darwin",
"epoch": 0,
"replaced_by": null,
"homepage": "http://phash.org/",
"description": "Perceptual hash library",
"long_description": "Tool to build hash from multimedia files",
"active": true,
"categories": [
"multimedia"
],
"maintainers": [
{
"name": "bstj",
"github": "",
"ports_count": 3
}
],
"variants": [
"universal"
],
"dependencies": [
{
"type": "build",
"ports": [
"autoconf",
"automake",
"libtool",
"clang-15"
]
},
{
"type": "lib",
"ports": [
"libjpeg-turbo",
"libsamplerate",
"ffmpeg",
"libsndfile",
"mpg123",
"CImg"
]
}
],
"depends_on": []
},
{
"name": "phantomjs-qt-sqlite-plugin",
"portdir": "aqua/phantomjs-qt",
"version": "5.5.1",
"license": "(LGPL-2.1 or LGPL-3 or GPL-3 or OpenSSLException)",
"platforms": "macosx",
"epoch": 0,
"replaced_by": null,
"homepage": "https://github.com/vitallium/qtbase",
"description": "SQLite Database Driver for Qt Tool Kit 5",
"long_description": "SQLite Database Driver for Qt Tool Kit 5",
"active": true,
"categories": [
"aqua",
"www"
],
"maintainers": [
{
"name": "mcalhoun",
"github": "MarcusCalhoun-Lopez",
"ports_count": 1596
}
],
"variants": [
"debug"
],
"dependencies": [
{
"type": "build",
"ports": [
"pkgconfig",
"clang-18"
]
},
{
"type": "fetch",
"ports": [
"git"
]
},
{
"type": "lib",
"ports": [
"phantomjs-qt-qtbase",
"sqlite3"
]
}
],
"depends_on": [
{
"type": "run",
"ports": [
"phantomjs-qt"
]
}
]
},
{
"name": "phantomjs-qt-qtwebkit",
"portdir": "aqua/phantomjs-qt",
"version": "5.5.1",
"license": "(LGPL-2.1 or LGPL-3 or GPL-3 or OpenSSLException)",
"platforms": "macosx",
"epoch": 0,
"replaced_by": null,
"homepage": "https://github.com/vitallium/qtwebkit",
"description": "Tools and Module(s) for Qt Tool Kit 5",
"long_description": "Tools and Module(s) for Qt Tool Kit 5: Qt WebKit and Qt WebKit Widgets",
"active": true,
"categories": [
"aqua",
"www"
],
"maintainers": [
{
"name": "mcalhoun",
"github": "MarcusCalhoun-Lopez",
"ports_count": 1596
}
],
"variants": [
"tests",
"debug"
],
"dependencies": [
{
"type": "build",
"ports": [
"bison",
"pkgconfig",
"python27",
"clang-18"
]
},
{
"type": "fetch",
"ports": [
"git"
]
},
{
"type": "lib",
"ports": [
"fontconfig",
"webp",
"phantomjs-qt-qtbase",
"libxslt",
"libxml2",
"zlib",
"leveldb",
"sqlite3",
"icu"
]
}
],
"depends_on": [
{
"type": "run",
"ports": [
"phantomjs-qt"
]
}
]
},
{
"name": "phantomjs-qt-qtbase",
"portdir": "aqua/phantomjs-qt",
"version": "5.5.1",
"license": "(LGPL-2.1 or LGPL-3 or GPL-3 or OpenSSLException)",
"platforms": "macosx",
"epoch": 0,
"replaced_by": null,
"homepage": "https://github.com/vitallium/qtbase",
"description": "Tools and Module(s) for Qt Tool Kit 5",
"long_description": "Tools and Module(s) for Qt Tool Kit 5: Qt Core",
"active": true,
"categories": [
"aqua",
"www"
],
"maintainers": [
{
"name": "mcalhoun",
"github": "MarcusCalhoun-Lopez",
"ports_count": 1596
}
],
"variants": [],
"dependencies": [
{
"type": "build",
"ports": [
"pkgconfig",
"gawk",
"clang-18"
]
},
{
"type": "fetch",
"ports": [
"git"
]
},
{
"type": "lib",
"ports": [
"fontconfig",
"libjpeg-turbo",
"zlib",
"freetype",
"libpng",
"icu",
"openssl10",
"pcre"
]
}
],
"depends_on": [
{
"type": "lib",
"ports": [
"phantomjs",
"phantomjs-qt-qtwebkit",
"phantomjs-qt-sqlite-plugin"
]
},
{
"type": "run",
"ports": [
"phantomjs-qt"
]
}
]
},
{
"name": "phantomjs-qt",
"portdir": "aqua/phantomjs-qt",
"version": "5.5.1",
"license": "(LGPL-2.1 or LGPL-3 or GPL-3 or OpenSSLException)",
"platforms": "any",
"epoch": 0,
"replaced_by": null,
"homepage": "https://github.com/vitallium/qtbase",
"description": "Qt Tool Kit 5",
"long_description": "Qt Tool Kit: A cross-platform framework (headers, data, and libraries) for writing cross-platform GUI-based applications.",
"active": true,
"categories": [
"aqua",
"www"
],
"maintainers": [
{
"name": "mcalhoun",
"github": "MarcusCalhoun-Lopez",
"ports_count": 1596
}
],
"variants": [],
"dependencies": [
{
"type": "build",
"ports": [
"clang-18"
]
},
{
"type": "run",
"ports": [
"phantomjs-qt-qtbase",
"phantomjs-qt-qtwebkit",
"phantomjs-qt-sqlite-plugin"
]
}
],
"depends_on": [
{
"type": "lib",
"ports": [
"phantomjs"
]
}
]
},
{
"name": "phantomjs",
"portdir": "www/phantomjs",
"version": "2.1.1",
"license": "BSD",
"platforms": "darwin",
"epoch": 0,
"replaced_by": null,
"homepage": "http://www.phantomjs.org/",
"description": "PhantomJS is a minimalistic headless WebKit.",
"long_description": "PhantomJS is a headless WebKit scriptable with a JavaScript API. It has fast and native support for various web standards: DOM handling, CSS selector, JSON, Canvas, and SVG.",
"active": true,
"categories": [
"www"
],
"maintainers": [],
"variants": [
"debug"
],
"dependencies": [
{
"type": "build",
"ports": [
"pkgconfig",
"python38",
"clang-17"
]
},
{
"type": "lib",
"ports": [
"phantomjs-qt",
"phantomjs-qt-qtbase"
]
}
],
"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": []
},
{
"name": "pgrouting",
"portdir": "gis/pgrouting",
"version": "4.0.0",
"license": "LGPL-2",
"platforms": "any",
"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"
],
"dependencies": [
{
"type": "build",
"ports": [
"cmake",
"clang-20"
]
},
{
"type": "lib",
"ports": [
"boost176"
]
}
],
"depends_on": []
},
{
"name": "pgroll",
"portdir": "databases/pgroll",
"version": "0.14.3",
"license": "Apache-2",
"platforms": "darwin freebsd linux",
"epoch": 0,
"replaced_by": null,
"homepage": "https://xata.io/blog/pgroll-schema-migrations-postgres",
"description": "Postgres zero-downtime migrations made easy",
"long_description": "pgroll is an open source command-line tool that offers safe and reversible schema migrations for PostgreSQL by serving multiple schema versions simultaneously. It takes care of the complex migration operations to ensure that client applications continue working while the database schema is being updated. This includes ensuring changes are applied without locking the database, and that both old and new schema versions work simultaneously (even when breaking changes are being made!). This removes risks related to schema migrations, and greatly simplifies client application rollout, also allowing for instant rollbacks.",
"active": true,
"categories": [
"databases"
],
"maintainers": [
{
"name": "herby.gillot",
"github": "herbygillot",
"ports_count": 1044
}
],
"variants": [],
"dependencies": [
{
"type": "build",
"ports": [
"go",
"clang-18"
]
}
],
"depends_on": []
},
{
"name": "pg_rman",
"portdir": "databases/pg_rman",
"version": "1.3.16",
"license": "BSD",
"platforms": "darwin",
"epoch": 0,
"replaced_by": null,
"homepage": "https://ossc-db.github.io/pg_rman/index.html",
"description": "Backup and restore management tool for PostgreSQL",
"long_description": "pg_rman is an online backup and restore tool for PostgreSQL. The goal of the pg_rman project is to provide a method for online backup and PITR that is as easy as pg_dump. Also, it maintains a backup catalog per database cluster. Users can maintain old backups including archive logs with one command.",
"active": true,
"categories": [
"databases"
],
"maintainers": [
{
"name": "herby.gillot",
"github": "herbygillot",
"ports_count": 1044
}
],
"variants": [
"postgresql16",
"postgresql15",
"postgresql14",
"postgresql13",
"postgresql12",
"postgresql11",
"universal"
],
"dependencies": [
{
"type": "build",
"ports": [
"clang-16"
]
},
{
"type": "lib",
"ports": [
"zlib",
"postgresql16"
]
}
],
"depends_on": []
},
{
"name": "pgpool-II",
"portdir": "databases/pgpool-II",
"version": "4.5.2",
"license": "MIT",
"platforms": "darwin",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.pgpool.net/",
"description": "PostgreSQL connection pool server",
"long_description": "pgpool is a connection server program for PostgreSQL. It runs between PostgreSQL's client(frontend) and server(backend). Any PostgreSQL clients can connect to pgpool as if it's a real PostgreSQL server. It supports connection pooling, failover and replication.",
"active": true,
"categories": [
"databases"
],
"maintainers": [],
"variants": [
"universal"
],
"dependencies": [
{
"type": "build",
"ports": [
"clang-16",
"postgresql16"
]
}
],
"depends_on": []
},
{
"name": "pgpool",
"portdir": "databases/pgpool",
"version": "3.4.1",
"license": "BSD",
"platforms": "darwin",
"epoch": 0,
"replaced_by": null,
"homepage": "http://www.pgpool.net/",
"description": "PostgreSQL connection pool server",
"long_description": "pgpool is a connection server program for PostgreSQL. It runs between PostgreSQL's client(frontend) and server(backend). Any PostgreSQL clients can connect to pgpool as if it's a real PostgreSQL server. It supports connection pooling, failover and replication.",
"active": true,
"categories": [
"databases"
],
"maintainers": [],
"variants": [
"universal"
],
"dependencies": [
{
"type": "build",
"ports": [
"clang-9.0"
]
}
],
"depends_on": []
},
{
"name": "pgpointcloud",
"portdir": "databases/pgpointcloud",
"version": "1.2.5",
"license": "BSD",
"platforms": "any",
"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"
],
"dependencies": [
{
"type": "build",
"ports": [
"autoconf",
"automake",
"pkgconfig",
"clang-18"
]
},
{
"type": "lib",
"ports": [
"zlib",
"libxml2"
]
}
],
"depends_on": []
},
{
"name": "pgplot",
"portdir": "graphics/pgplot",
"version": "5.2.2",
"license": "Noncommercial",
"platforms": "darwin",
"epoch": 0,
"replaced_by": null,
"homepage": "http://www.astro.caltech.edu/~tjp/pgplot/",
"description": "C/Fortran graphics library",
"long_description": "The PGPLOT Graphics Subroutine Library is a Fortran- or C-callable, device-independent graphics package for making simple scientific graphs. It is intended for making graphical images of publication quality with minimum effort on the part of the user. For most applications, the program can be device-independent, and the output can be directed to the appropriate device at run time.",
"active": true,
"categories": [
"devel",
"graphics"
],
"maintainers": [
{
"name": "mcalhoun",
"github": "MarcusCalhoun-Lopez",
"ports_count": 1596
}
],
"variants": [
"x11",
"aquaterm",
"g95",
"gcc10",
"gcc11",
"gcc12",
"gcc13",
"gcc14",
"gccdevel",
"docs"
],
"dependencies": [
{
"type": "build",
"ports": [
"gcc14",
"pkgconfig",
"perl5",
"clang-18"
]
},
{
"type": "lib",
"ports": [
"zlib",
"libpng",
"libgcc",
"xorg-libX11"
]
}
],
"depends_on": [
{
"type": "lib",
"ports": [
"p5.26-pdl",
"p5.26-pgplot",
"ortep3",
"LORENE",
"ifeffit",
"p5.28-pgplot",
"p5.30-pgplot",
"p5.32-pgplot",
"p5.34-pgplot"
]
}
]
},
{
"name": "pgpdump",
"portdir": "security/pgpdump",
"version": "0.37",
"license": "BSD",
"platforms": "darwin",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.mew.org/~kazu/proj/pgpdump/en/",
"description": "PGP packet visualizer",
"long_description": "pgpdump is a PGP packet visualizer which displays the packet format of OpenPGP (RFC 4880) and PGP version 2 (RFC 1991).",
"active": true,
"categories": [
"security"
],
"maintainers": [],
"variants": [
"universal"
],
"dependencies": [
{
"type": "build",
"ports": [
"clang-18"
]
},
{
"type": "lib",
"ports": [
"bzip2",
"zlib"
]
}
],
"depends_on": []
},
{
"name": "pgp",
"portdir": "security/pgp",
"version": "50i",
"license": "Restrictive",
"platforms": "darwin",
"epoch": 0,
"replaced_by": null,
"homepage": "http://www.pgpi.org/",
"description": "Public-Key encryption for the masses",
"long_description": "PGP 5.0 contains support for new encryption methods (most notably DSS/Diffie-Hellman), and built-in keyserver support. Also, the command line has been redesigned to be more Unix and scripting friendly. Note: this software is old; you probably want gnupg or gnupg2 instead.",
"active": false,
"categories": [
"security",
"mail"
],
"maintainers": [],
"variants": [
"universal"
],
"dependencies": [
{
"type": "build",
"ports": [
"clang-9.0"
]
}
],
"depends_on": []
},
{
"name": "pgmodeler",
"portdir": "databases/pgmodeler",
"version": "1.2.2",
"license": "GPL-3",
"platforms": "darwin",
"epoch": 0,
"replaced_by": null,
"homepage": "https://github.com/pgmodeler/pgmodeler",
"description": "PostgreSQL Database Modeler",
"long_description": "pgModeler - PostgreSQL Database Modeler - is an open source data modeling tool designed for PostgreSQL.",
"active": true,
"categories": [
"databases"
],
"maintainers": [
{
"name": "l2dy",
"github": "l2dy",
"ports_count": 97
},
{
"name": "herby.gillot",
"github": "herbygillot",
"ports_count": 1044
}
],
"variants": [
"universal"
],
"dependencies": [
{
"type": "build",
"ports": [
"clang-18"
]
},
{
"type": "lib",
"ports": [
"libxml2",
"qt6-qtbase",
"qt6-qtsvg",
"postgresql15"
]
}
],
"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": []
},
{
"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": "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": "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": "pgbouncer",
"portdir": "databases/pgbouncer",
"version": "1.25.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": 1044
}
],
"variants": [
"universal"
],
"dependencies": [
{
"type": "build",
"ports": [
"gmake",
"pkgconfig",
"pandoc",
"clang-18"
]
},
{
"type": "lib",
"ports": [
"openssl",
"c-ares",
"libevent"
]
}
],
"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": "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": 1044
}
],
"variants": [],
"dependencies": [
{
"type": "build",
"ports": [
"go",
"clang-18"
]
}
],
"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-18"
]
},
{
"type": "lib",
"ports": [
"libgcrypt",
"openssl",
"postgresql96",
"libxml2",
"libxslt",
"wxWidgets-3.0"
]
}
],
"depends_on": []
},
{
"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": "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": "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": "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-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-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-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": [
"pg17-pgrouting",
"mod_tile",
"osm2pgrouting",
"osm2pgsql"
]
}
]
},
{
"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-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-18"
]
},
{
"type": "lib",
"ports": [
"libxml2",
"postgresql17",
"zlib"
]
}
],
"depends_on": [
{
"type": "lib",
"ports": [
"pdal-pgpointcloud"
]
}
]
},
{
"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": "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-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-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-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-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-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-18"
]
},
{
"type": "lib",
"ports": [
"libxml2",
"postgresql16",
"zlib"
]
}
],
"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": "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-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-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-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": [
"proj6",
"proj7",
"address_standardizer",
"lto",
"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-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-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": [
"universal",
"tests"
],
"dependencies": [
{
"type": "build",
"ports": [
"autoconf",
"automake",
"pkgconfig",
"clang-18"
]
},
{
"type": "lib",
"ports": [
"libxml2",
"postgresql15",
"zlib"
]
}
],
"depends_on": []
}
]
}