WorkShop Developing Postgres 101 : Postgres

At EDB Offices in Bedford: 34 Crosby Drive.

This meeting will be held in the memory of Simon Riggs, a major contributor and committer, who sadly passed away yesterday. His contributions to PostgreSQL were key to the success of the PostgreSQL community. May he rest in peace.

Please bring a laptop capable of running Docker on x86 (Mac, Linux Windows)

In this event Rahki Grover and Bill Smith will take you step by step through the process of building Postgres from source, applying a patch testing a patch and sending feedback to the Postgres Hacker community.

We will also take you through the process of building a Postgres Extension and fundamental steps on debugging a new patch:

Included below is a rough agenda:

How to setup and build Postgres.

How to setup and build a Postgres Extension.

How to develop a Postgres Extension.

How to submit a patch to the Postgres Community.

How to test, build and review a patch.

Requirements: An x86 laptop capable of running docker. (Windows, Mac, Linux). We expect to encounter some issues with some platforms. However, we will work through them together during the workshop.

Some knowledge of C, will be helpful.

Agenda: Setup your environment, Build and Test

1. Get the docker file.
2. Do pull git pull.
3. Configure
4. Build
5. How to make sure it is working.

Get an upstream PG 17 patch build and test it. Perhaps write feedback.

1. Hackers mailing list.
2. Some candidate patches.
3. How to apply and build.
4. Provide feedback.

Build an extension:

1. Get the code for an extension.
2. How to build an extension.
3. Fundamentals of building an extension.