Medium · published August 13, 2026
Cleartext storage in PostgreSQL pgcrypto disabled ciphers allows a user to recover cleartext, via direct observation of the faulty ciphertext. The OpenSSL version and OpenSSL configuration determine the disabled ciphers. If the application accepts encrypted data as input, decryption will succeed even with the wrong key. This in turn loses the modest protection from the Modification Detection Code (MDC). Affected functions are pgp_sym_encrypt, pgp_sym_decrypt, pgp_pub_encrypt, pgp_pub_decrypt, pgp_sym_encrypt_bytea, pgp_sym_decrypt_bytea, pgp_pub_encrypt_bytea, and pgp_pub_decrypt_bytea. Versions before PostgreSQL 18.6, 17.11, 16.15, 15.19, and 14.24 are affected.
| Product | Versions | Fixed in |
|---|---|---|
| postgresql/postgresql | ≥ 14.0, < 14.24 | 14.24 |
| postgresql/postgresql | ≥ 15.0, < 15.19 | 15.19 |
| postgresql/postgresql | ≥ 16.0, < 16.15 | 16.15 |
| postgresql/postgresql | ≥ 17.0, < 17.11 | 17.11 |
| postgresql/postgresql | ≥ 18.0, < 18.5 | 18.5 |