Trending on GitHub

The pglayers project publishes minimal Docker images for 53 PostgreSQL extensions, built from scratch and containing only necessary binaries and scripts. Users can stack these layers onto the official postgres image using COPY --from directives, eliminating the need for compilation or apt-get in the final container. This approach results in smaller, immutable images where extensions are activated via standard CREATE EXTENSION commands.

• Eliminates build tools and apt-get from final images, reducing attack surface and size.
• Supports 53 extensions including pgvector, PostGIS, and pg_cron out of the box.
• Simplifies deployment by allowing stackable, pre-built extension layers via Docker COPY.
• No compilation required; extensions are ready to use after standard CREATE EXTENSION.

PDU is an open-source tool that reconstructs metadata and exports tables from offline PostgreSQL data files and WAL archives without modifying the original directory. It supports exporting entire databases, specific schemas, or individual tables as CSV for inspection or migration to another instance. The tool also facilitates targeted recovery of rows affected by accidental DELETE or UPDATE operations by parsing WAL logs.

• Recovers data from crashed PostgreSQL instances by reading data files directly.
• Exports offline database structures and content as CSV without server restart.
• Enables targeted row recovery from WAL archives for accidental DML errors.
• Operates without modifying the original data directory, preserving evidence.