HTTP 200 OK
Allow: GET, HEAD, OPTIONS
Content-Type: application/json
Vary: Accept
{
"count": 51562,
"next": "https://ports.macports.org/api/v1/ports/?format=api&ordering=-created_at&page=1006",
"previous": "https://ports.macports.org/api/v1/ports/?format=api&ordering=-created_at&page=1004",
"results": [
{
"name": "postgresql91-server",
"portdir": "databases/postgresql91-server",
"version": "9.1.24",
"license": "Permissive",
"platforms": "{darwin any}",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.postgresql.org/",
"description": "run postgresql91 as server",
"long_description": "run postgresql91 as server",
"active": true,
"categories": [
"databases"
],
"maintainers": [],
"variants": [],
"dependencies": [
{
"type": "build",
"ports": [
"clang-18"
]
},
{
"type": "run",
"ports": [
"postgresql91"
]
}
],
"depends_on": []
},
{
"name": "postgresql91-doc",
"portdir": "databases/postgresql91-doc",
"version": "9.1.24",
"license": "Permissive",
"platforms": "any",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.postgresql.org/",
"description": "Documentation for the PostgreSQL database version 9.1",
"long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity. This is the documentation.",
"active": true,
"categories": [
"databases"
],
"maintainers": [],
"variants": [],
"dependencies": [
{
"type": "build",
"ports": [
"clang-18"
]
}
],
"depends_on": []
},
{
"name": "postgresql91",
"portdir": "databases/postgresql91",
"version": "9.1.24",
"license": "Permissive",
"platforms": "darwin",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.postgresql.org/",
"description": "The most advanced open-source database available anywhere.",
"long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity.",
"active": true,
"categories": [
"databases"
],
"maintainers": [],
"variants": [
"python",
"python27",
"krb5",
"perl",
"tcl",
"universal"
],
"dependencies": [
{
"type": "build",
"ports": [
"clang-18",
"bison"
]
},
{
"type": "lib",
"ports": [
"ossp-uuid",
"readline",
"zlib",
"libxslt",
"libxml2",
"openssl10"
]
},
{
"type": "run",
"ports": [
"postgresql_select-91"
]
}
],
"depends_on": [
{
"type": "lib",
"ports": [
"qt4-mac-postgresql91-plugin",
"libzdb-postgresql91"
]
},
{
"type": "run",
"ports": [
"postgresql91-server"
]
}
]
},
{
"name": "postgresql90-server",
"portdir": "databases/postgresql90-server",
"version": "9.0.23",
"license": "Permissive",
"platforms": "{darwin any}",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.postgresql.org/",
"description": "run postgresql90 as server",
"long_description": "run postgresql90 as server",
"active": true,
"categories": [
"databases"
],
"maintainers": [],
"variants": [],
"dependencies": [
{
"type": "build",
"ports": [
"clang-18"
]
},
{
"type": "run",
"ports": [
"postgresql90"
]
}
],
"depends_on": [
{
"type": "run",
"ports": [
"iplike"
]
}
]
},
{
"name": "postgresql90-doc",
"portdir": "databases/postgresql90-doc",
"version": "9.0.23",
"license": "Permissive",
"platforms": "any",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.postgresql.org/",
"description": "Documentation for the PostgreSQL database version 9.0",
"long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity. This is the documentation.",
"active": true,
"categories": [
"databases"
],
"maintainers": [],
"variants": [],
"dependencies": [
{
"type": "build",
"ports": [
"clang-18"
]
}
],
"depends_on": []
},
{
"name": "postgresql90",
"portdir": "databases/postgresql90",
"version": "9.0.23",
"license": "Permissive",
"platforms": "darwin",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.postgresql.org/",
"description": "The most advanced open-source database available anywhere.",
"long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity.",
"active": true,
"categories": [
"databases"
],
"maintainers": [],
"variants": [
"python",
"python27",
"krb5",
"perl",
"tcl",
"universal"
],
"dependencies": [
{
"type": "build",
"ports": [
"clang-18",
"bison"
]
},
{
"type": "lib",
"ports": [
"ossp-uuid",
"readline",
"zlib",
"libxslt",
"libxml2",
"openssl10"
]
},
{
"type": "run",
"ports": [
"postgresql_select-90"
]
}
],
"depends_on": [
{
"type": "build",
"ports": [
"postgresql-unaccent"
]
},
{
"type": "lib",
"ports": [
"qt4-mac-postgresql90-plugin",
"libzdb-postgresql90"
]
},
{
"type": "run",
"ports": [
"postgresql90-server"
]
}
]
},
{
"name": "postgresql84-server",
"portdir": "databases/postgresql84-server",
"version": "8.4.22",
"license": "Permissive",
"platforms": "{darwin any}",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.postgresql.org/",
"description": "run postgresql84 as server",
"long_description": "run postgresql84 as server",
"active": true,
"categories": [
"databases"
],
"maintainers": [],
"variants": [],
"dependencies": [
{
"type": "build",
"ports": [
"clang-18"
]
},
{
"type": "run",
"ports": [
"postgresql84"
]
}
],
"depends_on": []
},
{
"name": "postgresql84-doc",
"portdir": "databases/postgresql84-doc",
"version": "8.4.22",
"license": "Permissive",
"platforms": "any",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.postgresql.org/",
"description": "Documentation for the PostgreSQL database version 8.4",
"long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity. This is the documentation.",
"active": true,
"categories": [
"databases"
],
"maintainers": [],
"variants": [],
"dependencies": [
{
"type": "build",
"ports": [
"clang-18"
]
}
],
"depends_on": []
},
{
"name": "postgresql84",
"portdir": "databases/postgresql84",
"version": "8.4.22",
"license": "Permissive",
"platforms": "darwin",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.postgresql.org/",
"description": "The most advanced open-source database available anywhere.",
"long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity.",
"active": true,
"categories": [
"databases"
],
"maintainers": [],
"variants": [
"python",
"python27",
"krb5",
"perl",
"tcl",
"earthdistance",
"universal"
],
"dependencies": [
{
"type": "build",
"ports": [
"clang-18",
"bison"
]
},
{
"type": "lib",
"ports": [
"ossp-uuid",
"readline",
"zlib",
"libxslt",
"libxml2",
"openssl10"
]
},
{
"type": "run",
"ports": [
"postgresql_select-84"
]
}
],
"depends_on": [
{
"type": "lib",
"ports": [
"BiggerSQL",
"py27-pgsql",
"qt4-mac-postgresql84-plugin",
"libzdb-postgresql84"
]
},
{
"type": "run",
"ports": [
"postgresql84-server"
]
}
]
},
{
"name": "postgresql83-server",
"portdir": "databases/postgresql83-server",
"version": "8.3.23",
"license": "Permissive",
"platforms": "{darwin any}",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.postgresql.org/",
"description": "run postgresql83 as server",
"long_description": "run postgresql83 as server",
"active": true,
"categories": [
"databases"
],
"maintainers": [],
"variants": [],
"dependencies": [
{
"type": "build",
"ports": [
"clang-18"
]
},
{
"type": "run",
"ports": [
"postgresql83"
]
}
],
"depends_on": []
},
{
"name": "postgresql83-doc",
"portdir": "databases/postgresql83-doc",
"version": "8.3.23",
"license": "Permissive",
"platforms": "any",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.postgresql.org/",
"description": "Documentation for the PostgreSQL database version 8.3",
"long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity. This is the documentation.",
"active": true,
"categories": [
"databases"
],
"maintainers": [],
"variants": [],
"dependencies": [
{
"type": "build",
"ports": [
"clang-18"
]
}
],
"depends_on": []
},
{
"name": "postgresql83",
"portdir": "databases/postgresql83",
"version": "8.3.23",
"license": "Permissive",
"platforms": "darwin",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.postgresql.org/",
"description": "The most advanced open-source database available anywhere.",
"long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity.",
"active": true,
"categories": [
"databases"
],
"maintainers": [],
"variants": [
"python",
"python27",
"krb5",
"perl",
"tcl"
],
"dependencies": [
{
"type": "build",
"ports": [
"bison",
"clang-18"
]
},
{
"type": "lib",
"ports": [
"ossp-uuid",
"readline",
"zlib",
"libxslt",
"libxml2",
"openssl10"
]
}
],
"depends_on": [
{
"type": "lib",
"ports": [
"BigSQL",
"libpqxx26",
"qt4-mac-postgresql83-plugin",
"libzdb-postgresql83",
"rb-postgres"
]
},
{
"type": "run",
"ports": [
"postgresql83-server"
]
}
]
},
{
"name": "postgresql82-server",
"portdir": "databases/postgresql82-server",
"version": "8.2.23",
"license": "Permissive",
"platforms": "{darwin any}",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.postgresql.org/",
"description": "run postgresql82 as server",
"long_description": "run postgresql82 as server",
"active": true,
"categories": [
"databases"
],
"maintainers": [],
"variants": [],
"dependencies": [
{
"type": "build",
"ports": [
"clang-18"
]
},
{
"type": "run",
"ports": [
"postgresql82"
]
}
],
"depends_on": []
},
{
"name": "postgresql82-doc",
"portdir": "databases/postgresql82-doc",
"version": "8.2.23",
"license": "Permissive",
"platforms": "any",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.postgresql.org/",
"description": "Documentation for the PostgreSQL database version 8.2",
"long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity. This is the documentation.",
"active": true,
"categories": [
"databases"
],
"maintainers": [],
"variants": [],
"dependencies": [
{
"type": "build",
"ports": [
"clang-18"
]
}
],
"depends_on": []
},
{
"name": "postgresql82",
"portdir": "databases/postgresql82",
"version": "8.2.23",
"license": "Permissive",
"platforms": "darwin",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.postgresql.org/",
"description": "The most advanced open-source database available anywhere",
"long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity.",
"active": true,
"categories": [
"databases"
],
"maintainers": [],
"variants": [
"python",
"krb5",
"tcl",
"perl",
"universal"
],
"dependencies": [
{
"type": "build",
"ports": [
"bison",
"clang-18"
]
},
{
"type": "lib",
"ports": [
"readline",
"zlib",
"libxslt",
"libxml2",
"openssl10"
]
}
],
"depends_on": [
{
"type": "lib",
"ports": [
"qt4-mac-postgresql82-plugin",
"libzdb-postgresql82"
]
},
{
"type": "run",
"ports": [
"postgresql82-server"
]
}
]
},
{
"name": "postgresql81-server",
"portdir": "databases/postgresql81-server",
"version": "8.1.23",
"license": "Permissive",
"platforms": "darwin",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.postgresql.org/",
"description": "run postgresql81 as server",
"long_description": "run postgresql81 as server",
"active": false,
"categories": [
"databases"
],
"maintainers": [],
"variants": [],
"dependencies": [
{
"type": "build",
"ports": [
"clang-9.0"
]
},
{
"type": "run",
"ports": [
"postgresql81"
]
}
],
"depends_on": []
},
{
"name": "postgresql81-doc",
"portdir": "databases/postgresql81-doc",
"version": "8.1.23",
"license": "Permissive",
"platforms": "darwin",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.postgresql.org/",
"description": "Documentation for the postgresql database",
"long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity. This is the documentation.",
"active": false,
"categories": [
"databases"
],
"maintainers": [],
"variants": [
"universal"
],
"dependencies": [
{
"type": "build",
"ports": [
"clang-9.0"
]
}
],
"depends_on": []
},
{
"name": "postgresql81",
"portdir": "databases/postgresql81",
"version": "8.1.23",
"license": "Permissive",
"platforms": "darwin",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.postgresql.org/",
"description": "The most advanced open-source database available anywhere",
"long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity.",
"active": false,
"categories": [
"databases"
],
"maintainers": [],
"variants": [
"python",
"krb5",
"perl",
"universal"
],
"dependencies": [
{
"type": "build",
"ports": [
"bison",
"clang-9.0"
]
},
{
"type": "lib",
"ports": [
"readline",
"zlib",
"libxslt",
"libxml2",
"openssl"
]
}
],
"depends_on": [
{
"type": "lib",
"ports": [
"pg2xbase",
"qt4-mac-postgresql81-plugin",
"libzdb-postgresql81"
]
},
{
"type": "run",
"ports": [
"postgresql81-server"
]
}
]
},
{
"name": "postgresql80-server",
"portdir": "databases/postgresql80-server",
"version": "8.0.26",
"license": "Permissive",
"platforms": "darwin",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.postgresql.org/",
"description": "run postgresql80 as server",
"long_description": "run postgresql80 as server",
"active": false,
"categories": [
"databases"
],
"maintainers": [],
"variants": [],
"dependencies": [
{
"type": "build",
"ports": [
"clang-9.0"
]
},
{
"type": "run",
"ports": [
"postgresql80"
]
}
],
"depends_on": []
},
{
"name": "postgresql80-doc",
"portdir": "databases/postgresql80-doc",
"version": "8.0.26",
"license": "Permissive",
"platforms": "darwin",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.postgresql.org/",
"description": "Documentation for the postgresql database",
"long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity. This is the documentation.",
"active": false,
"categories": [
"databases"
],
"maintainers": [],
"variants": [
"universal"
],
"dependencies": [
{
"type": "build",
"ports": [
"clang-9.0"
]
}
],
"depends_on": []
},
{
"name": "postgresql80",
"portdir": "databases/postgresql80",
"version": "8.0.26",
"license": "Permissive",
"platforms": "darwin",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.postgresql.org/",
"description": "The most advanced open-source database available anywhere",
"long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity.",
"active": false,
"categories": [
"databases"
],
"maintainers": [],
"variants": [
"python",
"krb5",
"perl",
"universal"
],
"dependencies": [
{
"type": "build",
"ports": [
"bison",
"clang-9.0"
]
},
{
"type": "lib",
"ports": [
"zlib",
"openssl",
"readline"
]
}
],
"depends_on": [
{
"type": "lib",
"ports": [
"qt4-mac-postgresql80-plugin",
"libzdb-postgresql80"
]
},
{
"type": "run",
"ports": [
"postgresql80-server"
]
}
]
},
{
"name": "postgresql13-server",
"portdir": "databases/postgresql13-server",
"version": "13.23",
"license": "Permissive",
"platforms": "{darwin any}",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.postgresql.org/",
"description": "run postgresql13 as server",
"long_description": "run postgresql13 as server",
"active": true,
"categories": [
"databases"
],
"maintainers": [
{
"name": "jwa",
"github": "jyrkiwahlstedt",
"ports_count": 44
}
],
"variants": [],
"dependencies": [
{
"type": "build",
"ports": [
"clang-18"
]
},
{
"type": "run",
"ports": [
"postgresql13"
]
}
],
"depends_on": []
},
{
"name": "postgresql13-doc",
"portdir": "databases/postgresql13-doc",
"version": "13.22",
"license": "Permissive",
"platforms": "any",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.postgresql.org/",
"description": "Documentation for the PostgreSQL database version 13",
"long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity. This is the documentation.",
"active": true,
"categories": [
"databases"
],
"maintainers": [
{
"name": "jwa",
"github": "jyrkiwahlstedt",
"ports_count": 44
}
],
"variants": [],
"dependencies": [
{
"type": "build",
"ports": [
"docbook-xml-4.5",
"docbook-xsl-nons",
"clang-18"
]
}
],
"depends_on": []
},
{
"name": "postgresql13",
"portdir": "databases/postgresql13",
"version": "13.23",
"license": "Permissive",
"platforms": "darwin",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.postgresql.org/",
"description": "The most advanced open-source database available anywhere.",
"long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity.",
"active": true,
"categories": [
"databases"
],
"maintainers": [
{
"name": "davidgilman1",
"github": "dgilman",
"ports_count": 146
},
{
"name": "vital.had",
"github": "barracuda156",
"ports_count": 2571
}
],
"variants": [
"clang13",
"clang14",
"clang15",
"clang16",
"clang17",
"clang18",
"clang19",
"clang20",
"clang21",
"clang22",
"clangdevel",
"python",
"python27",
"python3",
"perl",
"tcl",
"llvm",
"universal"
],
"dependencies": [
{
"type": "build",
"ports": [
"clang-18",
"bison",
"pkgconfig"
]
},
{
"type": "lib",
"ports": [
"kerberos5",
"libxml2",
"zlib",
"openssl3",
"libxslt",
"icu",
"readline"
]
},
{
"type": "run",
"ports": [
"postgresql_select-13"
]
}
],
"depends_on": [
{
"type": "build",
"ports": [
"pg13-postgis3-doc",
"pg13-postgis-doc"
]
},
{
"type": "lib",
"ports": [
"pg13-pgrouting",
"pg13-postgis",
"pg13-pgpointcloud",
"pg13-timescaledb"
]
},
{
"type": "run",
"ports": [
"postgresql13-server"
]
}
]
},
{
"name": "postgresql12-server",
"portdir": "databases/postgresql12-server",
"version": "12.22",
"license": "Permissive",
"platforms": "{darwin any}",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.postgresql.org/",
"description": "run postgresql12 as server",
"long_description": "run postgresql12 as server",
"active": true,
"categories": [
"databases"
],
"maintainers": [
{
"name": "jwa",
"github": "jyrkiwahlstedt",
"ports_count": 44
}
],
"variants": [],
"dependencies": [
{
"type": "build",
"ports": [
"clang-18"
]
},
{
"type": "run",
"ports": [
"postgresql12"
]
}
],
"depends_on": []
},
{
"name": "postgresql12-doc",
"portdir": "databases/postgresql12-doc",
"version": "12.22",
"license": "Permissive",
"platforms": "any",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.postgresql.org/",
"description": "Documentation for the PostgreSQL database version 12",
"long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity. This is the documentation.",
"active": true,
"categories": [
"databases"
],
"maintainers": [
{
"name": "jwa",
"github": "jyrkiwahlstedt",
"ports_count": 44
}
],
"variants": [],
"dependencies": [
{
"type": "build",
"ports": [
"docbook-xml-4.5",
"docbook-xsl-nons",
"clang-17"
]
}
],
"depends_on": []
},
{
"name": "postgresql12",
"portdir": "databases/postgresql12",
"version": "12.22",
"license": "Permissive",
"platforms": "darwin",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.postgresql.org/",
"description": "The most advanced open-source database available anywhere.",
"long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity.",
"active": true,
"categories": [
"databases"
],
"maintainers": [],
"variants": [
"clang13",
"clang14",
"clang15",
"clang16",
"clang17",
"clang18",
"clang19",
"clang20",
"clang21",
"clang22",
"clangdevel",
"python",
"python27",
"python3",
"perl",
"tcl",
"llvm",
"universal"
],
"dependencies": [
{
"type": "build",
"ports": [
"clang-18",
"bison",
"pkgconfig"
]
},
{
"type": "lib",
"ports": [
"kerberos5",
"libxml2",
"zlib",
"openssl3",
"libxslt",
"icu",
"readline"
]
},
{
"type": "run",
"ports": [
"postgresql_select-12"
]
}
],
"depends_on": [
{
"type": "build",
"ports": [
"pg12-postgis-doc",
"pg12-postgis3-doc"
]
},
{
"type": "lib",
"ports": [
"pg12-pgrouting",
"pg12-timescaledb",
"pg12-pgpointcloud",
"pg12-postgis",
"postgis2",
"timescaledb1",
"p5.26-dbd-pg"
]
},
{
"type": "run",
"ports": [
"postgresql12-server"
]
}
]
},
{
"name": "postgresql11-server",
"portdir": "databases/postgresql11-server",
"version": "11.22",
"license": "Permissive",
"platforms": "{darwin any}",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.postgresql.org/",
"description": "run postgresql11 as server",
"long_description": "run postgresql11 as server",
"active": true,
"categories": [
"databases"
],
"maintainers": [
{
"name": "jwa",
"github": "jyrkiwahlstedt",
"ports_count": 44
}
],
"variants": [],
"dependencies": [
{
"type": "build",
"ports": [
"clang-18"
]
},
{
"type": "run",
"ports": [
"postgresql11"
]
}
],
"depends_on": []
},
{
"name": "postgresql11-doc",
"portdir": "databases/postgresql11-doc",
"version": "11.22",
"license": "Permissive",
"platforms": "any",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.postgresql.org/",
"description": "Documentation for the PostgreSQL database version 11",
"long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity. This is the documentation.",
"active": true,
"categories": [
"databases"
],
"maintainers": [
{
"name": "jwa",
"github": "jyrkiwahlstedt",
"ports_count": 44
}
],
"variants": [],
"dependencies": [
{
"type": "build",
"ports": [
"clang-18"
]
}
],
"depends_on": []
},
{
"name": "postgresql11",
"portdir": "databases/postgresql11",
"version": "11.22",
"license": "Permissive",
"platforms": "darwin",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.postgresql.org/",
"description": "The most advanced open-source database available anywhere.",
"long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity.",
"active": true,
"categories": [
"databases"
],
"maintainers": [
{
"name": "jwa",
"github": "jyrkiwahlstedt",
"ports_count": 44
}
],
"variants": [
"clang13",
"clang14",
"clang15",
"clang16",
"clang17",
"clang18",
"clang19",
"clang20",
"clang21",
"clang22",
"clangdevel",
"python",
"python27",
"python3",
"perl",
"tcl",
"llvm",
"universal"
],
"dependencies": [
{
"type": "build",
"ports": [
"clang-18",
"bison",
"pkgconfig"
]
},
{
"type": "lib",
"ports": [
"kerberos5",
"libxml2",
"zlib",
"openssl11",
"libxslt",
"icu",
"readline"
]
},
{
"type": "run",
"ports": [
"postgresql_select-11"
]
}
],
"depends_on": [
{
"type": "run",
"ports": [
"postgresql11-server"
]
}
]
},
{
"name": "postgresql10-server",
"portdir": "databases/postgresql10-server",
"version": "10.23",
"license": "Permissive",
"platforms": "{darwin any}",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.postgresql.org/",
"description": "run postgresql10 as server",
"long_description": "run postgresql10 as server",
"active": true,
"categories": [
"databases"
],
"maintainers": [
{
"name": "jwa",
"github": "jyrkiwahlstedt",
"ports_count": 44
}
],
"variants": [],
"dependencies": [
{
"type": "build",
"ports": [
"clang-18"
]
},
{
"type": "run",
"ports": [
"postgresql10"
]
}
],
"depends_on": [
{
"type": "lib",
"ports": [
"amber"
]
}
]
},
{
"name": "postgresql10-doc",
"portdir": "databases/postgresql10-doc",
"version": "10.23",
"license": "Permissive",
"platforms": "any",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.postgresql.org/",
"description": "Documentation for the PostgreSQL database version 10",
"long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity. This is the documentation.",
"active": true,
"categories": [
"databases"
],
"maintainers": [
{
"name": "jwa",
"github": "jyrkiwahlstedt",
"ports_count": 44
}
],
"variants": [],
"dependencies": [
{
"type": "build",
"ports": [
"clang-18"
]
}
],
"depends_on": []
},
{
"name": "postgresql10",
"portdir": "databases/postgresql10",
"version": "10.23",
"license": "Permissive",
"platforms": "darwin",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.postgresql.org/",
"description": "The most advanced open-source database available anywhere.",
"long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity.",
"active": true,
"categories": [
"databases"
],
"maintainers": [
{
"name": "jwa",
"github": "jyrkiwahlstedt",
"ports_count": 44
}
],
"variants": [
"python",
"python27",
"python3",
"perl",
"tcl",
"universal"
],
"dependencies": [
{
"type": "build",
"ports": [
"clang-18",
"bison"
]
},
{
"type": "lib",
"ports": [
"kerberos5",
"libxml2",
"zlib",
"openssl11",
"libxslt",
"readline"
]
},
{
"type": "run",
"ports": [
"postgresql_select-10"
]
}
],
"depends_on": [
{
"type": "run",
"ports": [
"postgresql10-server"
]
}
]
},
{
"name": "postgresql-unaccent",
"portdir": "databases/postgresql-unaccent",
"version": "0.1",
"license": "unknown",
"platforms": "darwin",
"epoch": 0,
"replaced_by": null,
"homepage": "http://launchpad.net/postgresql-unaccent/",
"description": "PostgreSQL extension that provides a function to remove accents from characters",
"long_description": "postgresql-unaccent is a PostgreSQL extension that provides a function to remove accents from characters (not compatible with the version bundled in postgresql90)",
"active": false,
"categories": [
"databases"
],
"maintainers": [],
"variants": [
"postgresql82",
"postgresql83",
"postgresql84",
"postgresql90",
"postgresql91"
],
"dependencies": [
{
"type": "build",
"ports": [
"postgresql90",
"clang-9.0"
]
},
{
"type": "lib",
"ports": [
"unac"
]
}
],
"depends_on": []
},
{
"name": "postgis3",
"portdir": "databases/postgis3",
"version": "3.6.0",
"license": "GPL-2+",
"platforms": "any",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.macports.org",
"description": "Obsolete port",
"long_description": "This port is obsolete.",
"active": true,
"categories": [
"databases",
"gis"
],
"maintainers": [],
"variants": [],
"dependencies": [
{
"type": "build",
"ports": [
"clang-18"
]
},
{
"type": "extract",
"ports": [
null
]
},
{
"type": "fetch",
"ports": [
null
]
},
{
"type": "lib",
"ports": [
null
]
},
{
"type": "patch",
"ports": [
null
]
},
{
"type": "run",
"ports": [
null
]
},
{
"type": "test",
"ports": [
null
]
}
],
"depends_on": []
},
{
"name": "postgis2",
"portdir": "databases/postgis2",
"version": "2.5.11",
"license": "GPL-2+",
"platforms": "darwin",
"epoch": 1,
"replaced_by": null,
"homepage": "http://postgis.refractions.net/",
"description": "PostGIS is the spatial extension to the PostGreSQL database.",
"long_description": "PostGIS 2 adds geometrical, geographical and topological types, and functions operating thereon, to the PostGreSQL database. The 2.0 release also provides raster handling and basic 3D geometry capacities (TIN and polyhedra).",
"active": true,
"categories": [
"databases",
"gis"
],
"maintainers": [
{
"name": "vince",
"github": "Veence",
"ports_count": 25
}
],
"variants": [
"postgresql10",
"postgresql11",
"postgresql12",
"raster",
"universal",
"topology",
"sfcgal",
"gui",
"comments"
],
"dependencies": [
{
"type": "build",
"ports": [
"autoconf",
"automake",
"libtool",
"libxslt",
"clang-18"
]
},
{
"type": "lib",
"ports": [
"libiconv",
"postgresql12",
"libxml2",
"gdal",
"proj7",
"geos",
"json-c"
]
}
],
"depends_on": []
},
{
"name": "postgis",
"portdir": "databases/postgis",
"version": "3.6.2",
"license": "GPL-2+",
"platforms": "any",
"epoch": 0,
"replaced_by": null,
"homepage": "https://postgis.net/",
"description": "PostGIS is the spatial extension to the PostGreSQL database.",
"long_description": "PostGIS adds geometrical, geographical and topological types, and functions operating thereon, to the PostGreSQL database. It also handles raster tiles and MVT format.",
"active": true,
"categories": [
"databases",
"gis"
],
"maintainers": [
{
"name": "n_larsson",
"github": "nilason",
"ports_count": 107
}
],
"variants": [],
"dependencies": [
{
"type": "build",
"ports": [
"clang-18"
]
},
{
"type": "lib",
"ports": [
"postgresql92",
"proj4",
"geos",
"libiconv",
"libxml2"
]
}
],
"depends_on": []
},
{
"name": "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": "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": "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": 1041
}
],
"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": "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": 1041
}
],
"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": "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": "percona-toolkit",
"portdir": "databases/percona-toolkit",
"version": "3.3.1",
"license": "(GPL-2 or Artistic-1)",
"platforms": "{darwin any}",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.percona.com/software/database-tools/percona-toolkit",
"description": "Collection of essential command-line utilities for MySQL",
"long_description": "Collection of essential command-line utilities for MySQL",
"active": true,
"categories": [
"databases"
],
"maintainers": [],
"variants": [
"perl5_28",
"perl5_30",
"perl5_32",
"perl5_34"
],
"dependencies": [
{
"type": "build",
"ports": [
"clang-16"
]
},
{
"type": "lib",
"ports": [
"perl5.34",
"p5.34-dbd-mysql",
"p5.34-dbi",
"p5.34-term-readkey",
"p5.34-time-hires"
]
}
],
"depends_on": []
},
{
"name": "percona-server",
"portdir": "databases/percona",
"version": "8.0.16-7",
"license": "BSD",
"platforms": "darwin",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.percona.com/",
"description": "Run percona as server",
"long_description": "Run percona as server",
"active": false,
"categories": [
"databases"
],
"maintainers": [],
"variants": [],
"dependencies": [
{
"type": "build",
"ports": [
"clang-17"
]
},
{
"type": "run",
"ports": [
"percona"
]
}
],
"depends_on": []
},
{
"name": "percona",
"portdir": "databases/percona",
"version": "8.0.16-7",
"license": "GPL-2",
"platforms": "darwin",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.percona.com/",
"description": "Multithreaded SQL database server",
"long_description": "Percona is a fork of the MySQL server, a multi-threaded SQL database.",
"active": false,
"categories": [
"databases"
],
"maintainers": [],
"variants": [
"debug",
"openssl",
"system_readline",
"universal"
],
"dependencies": [
{
"type": "build",
"ports": [
"clang-17",
"cmake"
]
},
{
"type": "lib",
"ports": [
"icu",
"libevent",
"openssl",
"protobuf3-cpp",
"lz4",
"tcp_wrappers",
"cyrus-sasl2",
"re2",
"zlib"
]
},
{
"type": "run",
"ports": [
"mysql_select"
]
}
],
"depends_on": [
{
"type": "lib",
"ports": [
"percona-lib_mysqludf_preg",
"percona-lib_mysqludf_json",
"percona-lib_mysqludf_xql",
"libzdb-percona",
"qt4-mac-percona-plugin",
"percona-connector-cpp",
"percona-lib_mysqludf_fPROJ4"
]
},
{
"type": "run",
"ports": [
"percona-server"
]
}
]
}
]
}