Misleading logs on unsupported PostgreSQL version

[steve-chavez]

Problem

This happens when trying a pg 12:

postgrest /nix/store/wa7y1f432g0qqph7sjn30ibl1q38l0v9-pgrst.conf
05/Dec/2025:05:18:43 +0000: Starting PostgREST 14.1...
05/Dec/2025:05:18:43 +0000: Admin server listening on 0.0.0.0:3001
05/Dec/2025:05:18:43 +0000: API server listening on /tmp/pgrst.sock
05/Dec/2025:05:18:43 +0000: Listening for database notifications on the "pgrst" channel
05/Dec/2025:05:18:43 +0000: Cannot run in this PostgreSQL version (12.19), PostgREST needs at least 13.0
05/Dec/2025:05:18:43 +0000: Successfully connected to PostgreSQL 12.19 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 13.2.0, 64-bit
05/Dec/2025:05:18:43 +0000: Connection Pool initialized with a maximum size of 1 connections
postgrest: thread killed

The last two log lines are confusing, for a while I didn't understand why the thread killed but the reason is clear above Cannot run in this PostgreSQL version....

Solution

The log 05/Dec/2025:05:18:43 +0000: Cannot run in this PostgreSQL version (12.19), PostgREST needs at least 13.0 should be the last one.