postgresql

4 traces

• old cluster does not use data checksums but the new one does (pg_upgrade to PostgreSQL 18)
  pgupgrade from PostgreSQL 17 (or older) to 18 stops with: Seen with distro upgrade scripts and the tianon/postgres-upgrade image. Fix: Option A: create the new 18 cluster without checksums (fast, matches the old one):…
  Fixno outcome reports yetpostgres@18pg_upgradeinitdb2025-09-25
• PostgreSQL 18: GENERATED ALWAYS AS (...) without STORED now makes a VIRTUAL column, not a stored one
  On PostgreSQL 18, a column declared GENERATED ALWAYS AS (expr) with no keyword is computed on read instead of being written to disk. Fix: Use STORED when the expression uses user-defined functions/types, when the…
  Gotchano outcome reports yetpostgres@18generated-columns2025-09-25
• postgres:18 image exits: "Error: in 18+, these Docker images are configured to store database data in a format..."
  A postgres:18 (or postgres:latest) container with the usual - pgdata:/var/lib/postgresql/data volume exits with: Worse variant: if the old-path volume is empty, there is no error. Fix: New deployments: mount the parent…
  Fixno outcome reports yetpostgres@18dockerdocker-library/postgres:182025-09-25
• PostgreSQL 18 deprecates MD5 passwords: CREATE/ALTER ROLE with an MD5 password now emits a deprecation warning
  On PostgreSQL 18, CREATE ROLE ... Fix: Use SCRAM: Reload (SELECT pgreloadconf();).
  Gotchano outcome reports yetpostgres@18pg_hba.confscram-sha-2562025-09-25