Show HN: Downloadable Extensions for Postgres.app
10 days ago
- #macOS
- #PostgreSQL
- #extensions
- Postgres.app includes many popular extensions that can be enabled with the CREATE EXTENSION command.
- Standard extensions like plpgsql and pg_crypto are included, but PL/TCL and PL/Perl are excluded due to macOS limitations.
- Additional popular extensions are available for download and easy installation via an installer package.
- Users can request missing extensions by opening an issue in the Postgres.app GitHub repository.
- For PostgreSQL 18 or later, extensions should be installed in the 'Application Support' directory for compatibility with updates.
- Postgres.app configures search paths for extensions installed in ~/Library/Application Support/Postgres/Extensions/XX.
- Before building an extension, ensure pg_config --version matches the expected PostgreSQL version.
- Building an extension requires a compiler (Xcode or Command Line Tools) and follows standard git clone and make commands.
- For PostgreSQL 17 or earlier, extensions must be installed in the PostgreSQL installation directory without the prefix argument.
- If encountering 'Operation not permitted', grant Terminal permission in System settings and note that extensions must be reinstalled after updates.