There are a variety of projects that help provide infrastructure and resources across the community. These projects range from providing event management software that is used by many of the PostgreSQL community events, to package management, to even the PostgreSQL.org website itself!
Much like the core PostgreSQL software, these projects rely on the support of contributors for new features and ongoing maintenance. There are written in a variety of programming languages (or in some cases, natural languages!) and are all ways for people to provide meaningful contributions to the PostgreSQL community. In addition to what each project provides, there are instructions for how you can start contributing to the project.
If you believe a project belongs on this list, please send an email to pgsql-www@lists.postgresql.org.
"pgweb" is the base code for the postgresql.org website and serves as both a content management system and an authentication provider for many other PostgreSQL family websites.
The PostgreSQL website is split into a dynamic and static part:
The site itself runs on the Django web framework. You can get involved in this project by communicating on the pgsql-www mailing list.
Planet PostgreSQL is a blog aggregator for individual blogs where people publish content about PostgreSQL, the PostgreSQL community, and PostgreSQL-related projects. It includes aggregation and distribution software, as well as tools to help with moderation.
You can get involved in this project by communicating on the pgsql-www mailing list.
The PostgreSQL mailing list system is powered by "pglister":
The "pgarchives" codebase powers the display for the PostgreSQL mailing list archives, which are an essential part of the development workflow for the PostgreSQL project.
You can get involved in this project by communicating on the pgsql-www mailing list.
The PostgreSQL Build Farm tests the current PostgreSQL code, and all supported versions, on a great number of devices provided by the community:
PostgreSQL uses a unique system for managing "Commitfests", which is a single development cycle. People who use the Commitfest app discuss their patches on the pgsql-hackers mailing list.
You can get involved in this project by communicating on the pgsql-www mailing list.
The PostgreSQL Performance Farm gathers performance data:
You can get involved in this project by communicating on the pgsql-www mailing list.
The APT repository provides PostgreSQL packages for Debian/Ubuntu based systems:
You can get involved in this project by communicating on the pgsql-pkg-debian mailing list.
The YUM repository provides PostgreSQL packages for Red Hat/Rocky/AlmaLinux/Fedora based systems (and derivatives):
You can get involved in this project by communicating on the pgsql-pkg-yum mailing list.
The Zypper repository provides PostgreSQL packages for Suse Enterprise Linux:
You can get involved in this project by communicating on the pgsql-pkg-yum mailing list.
The "pgeu-system" powers a number of PostgreSQL conferences, including:
The conference system runs on the django web framework, and is Open Source with a MIT License.
The code is hosted on git.postgresql.org, and mirrored to GitHub:
The GitHub mirror can be used to submit Issues and Pull Requests. You can get involved in this project by communicating on the pgeu-system@lists.postgresql.eu mailing list.
The press release repository contains archives of major PostgreSQL releases, their press kits, and translations, as well as the periodic minor updates.
If you are interested in becoming a press release translator, you can get involved in this project by sending an email to press@postgresql.org.