pgxman – npm for Postgres extensions
pgxman is npm for Postgres extensions, simplifying the discovery and use of extensions so you can easily enhance your applications. Installing and updating Postgres extensions is an uphill battle. You're left searching for the right build tools and grappling with often unclear and incomplete compiling instructions to even try one out. But with pgxman, we've streamlined the process to one simple step: pgxman install [extension name]. For example, to build parquet_s3_fdw manually, you'd need to: 1. Download the parquet_s3_fdw source code; 2. Figure out how to build it by looking at README.…
In plain words
pgxman is a package manager for Postgres extensions that simplifies installation and discovery. Instead of manually downloading source code, identifying build tools, and resolving dependencies, users can install extensions with a single command: pgxman install [extension name]. The tool is designed for developers and database administrators who want to enhance their Postgres applications without the complexity of traditional compilation workflows.
written from the facts on this page · September 2026
From the sources
In the maker’s words, at launch
pgxman is npm for Postgres extensions, simplifying the discovery and use of extensions so you can easily enhance your applications. Installing and updating Postgres extensions is an uphill battle. You're left searching for the right build tools and grappling with often unclear and incomplete compiling instructions to even try one out. But with pgxman, we've streamlined the process to one simple step: pgxman install [extension name]. For example, to build parquet_s3_fdw manually, you'd need to: 1. Download the parquet_s3_fdw source code; 2. Figure out how to build it by looking at README. When unclear, look at the source code how to build it. The README of parquet_s3_fdw says it needs libarrow, libparquet & aws_sdk. Readme doesn’t say where to get them. 3. Make sure all dependencies are available to build the project. Either install them from apt, if available, or build them manually if not. For parquet_s3_fdw aws_sdk has to be built manually — it’s not available in any apt repos 4. Build the extension targeting the correct OS, CPU architecture and Postgres version. 5. Determine and build to the right path /usr/lib/postgresql/15/lib - otherwise, Postgres wouldn’t be able to find them. 6. Repeat across all relevant Postgres instances. Hopefully, these Postgres versions are recent or else you’ll have to update postgres, set maintenance window, etc. * Added friction: Since parquet_s3_fdw is not designed to use in a cloud environment, and we forked it to make changes to make it possible to use. Using pgxman, you can just do: pgxman install s3_parquet_fdw pgxman integrates with your system package manager, ensuring the correct versions are installed without extra packages from any shared dependencies between extensions. pgxman’s automated build system creates [APT] packages for each Postgres version, platform, and OS supported by the extension. Extensions are built from a “buildkit” formula, written in YAML, and are contributed through GitHub. To install pgxman, you can do brew install pgxman/tap/pgxman or, if you don't mind pipe-to-shell, curl -sfl https://install.pgx.sh | sh - If you'd like to learn more, we have an extensive blog post here: https://www.hydra.so/blog-posts/the-design-of-postgres-exten....
More dev tools this month
the category →
Open-source GTM skills for technical founders
Dev tools · 29d ago · gtmcofounder.com
OpenTrailPaper is open-source bike computer firmware for the LilyGO T5S3 4.7" E-Paper PRO. It supports offline maps, GPX routes, FIT recording and Bluetooth sensors.
Dev tools · 2d ago · opentrailpaper.com
Launched alongside, November 2023
the whole month →
Discover & book top creators to promote your product
Growth · 2023 · passionfroot.me
