Compiling pg_tde into PostgreSQL 18.3 from source

PostgreSQL
1

Hello,

We’re a software producer in the Library Management Market and compile PostgreSQL on SuSE Linux Enterprise from source. In the actual used version (16.5) we compiled pg_tde by git cloning it to postgresql-16.5/contrib/pg_tde, running ./configure and gmake there.

It seems that this path does not work anymore for 18.3. Am I wrong? If so, please point me to the installation instruction from source.

Thanks

2

Hey,

pg_tde is only supported with Percona Server for PostgreSQL (PSP) versions 17 and 18. It is not supported for versions 16 and below, as of now. Secondly, pg_tde is not supported with PGDG (community versions) as of now.

To compile pg_tde and make it work, you will need to use PSP (an open-source fork of Postgres by Percona). If you want to build pg_tde, please use the relevant 17 and 18 branches of PSP for building the server. Then, please use the same server for compiling the pg_tde.

For building the server and pg_tde, please use the standard build steps like configure, make, and make install; it should work for you.

For building pg_tde, it doesn’t need to be in contrib specifically; you can have it outside the server, but you just need pg_config to be in the PATH.

I hope the information shared is helpful!.

Cheers,
Naeem Akhter