Tested platforms and operating system compatibility

pg_auto_mv's automated test suite runs against the following combinations of PostgreSQL version and operating system:

PostgreSQL version	Ubuntu 24.04 LTS	Rocky Linux 8	Rocky Linux 9	Debian 12
15	✅	✅	✅	✅
16	✅
17	✅
18	✅	✅	✅	✅

All four supported PostgreSQL versions (15–18) are tested on Ubuntu 24.04 LTS. The version endpoints (15 and 18) are additionally tested on Rocky Linux 8, Rocky Linux 9, and Debian 12, since the version-specific SQL behaviour is where real risk surfaces, and the OS-specific install recipe (PGDG repositories, package names, extension directory layout) only needs to be exercised at both ends of the supported range.

Other operating systems (IBM AIX, Solaris, FreeBSD, other Linux distributions, etc.)

pg_auto_mv is a pure SQL / PL/pgSQL extension. It contains no C code, no compiled binary of its own, and no operating-system-specific calls. Every feature it uses — triggers, PL/pgSQL, FOR UPDATE SKIP LOCKED, clock_timestamp(), composite types, SECURITY DEFINER functions — is standard PostgreSQL functionality available identically on every platform PostgreSQL itself supports. There is no reason to expect different behaviour on an operating system outside the tested list above.

If you are running PostgreSQL 15 or later on a platform not listed in the table — IBM AIX, Solaris, FreeBSD, Alpine, SUSE, Amazon Linux, or any other Unix-like system — installation and behaviour should be identical to the tested platforms. There are only two practical considerations, both properties of your PostgreSQL packaging rather than of pg_auto_mv:

1. pg_config must correctly report your extension directory (pg_config --sharedir). make install relies on the standard PGXS build system, which PostgreSQL itself supports on every platform it ships for.
2. If your platform cannot use PGXS-based installation at all (rare — typically only on heavily customised or embedded PostgreSQL builds), you can bypass make install entirely and deploy pg_auto_mv by running its SQL file directly against the database with psql. This works on any platform that can open a PostgreSQL connection, tested or not — see Section 7 and CLOUD_INSTALL.md for the exact steps.

If you do encounter a genuine platform-specific issue, please raise it on the issue tracker (see Support, below) — pg_auto_mv is designed to have zero OS-specific behaviour.

---