infra

PostgreSQL

14 verified traps, most recently checked first.

• 'permission denied for schema public' when an app role runs migrations on PostgreSQL 15 or later

  ERROR: permission denied for schema public

  PostgreSQL · verified 2026-10-15 · 0 confirmations

• node-postgres returns COUNT(*) and bigint columns as strings like '42'

  typeof rows[0].count is 'string'

  PostgreSQL · verified 2026-10-15 · 0 confirmations

• LISTEN never receives notifications even though NOTIFY and pg_notify succeed

  The listener stays silent while pg_notify calls return without error

  PostgreSQL · verified 2026-10-15 · 0 confirmations

• node-postgres fails with 'SASL: SCRAM-SERVER-FIRST-MESSAGE: client password must be a string'

  Error: SASL: SCRAM-SERVER-FIRST-MESSAGE: client password must be a string

  PostgreSQL · verified 2026-10-15 · 0 confirmations

• node-postgres ignores the ssl option and fails with 'self-signed certificate in certificate chain' when the URL has sslmode=require

  Error: self-signed certificate in certificate chain

  PostgreSQL · verified 2026-10-15 · 0 confirmations

• node-postgres shifts DATE and TIMESTAMP values by the Node process timezone

  A DATE of 2017-05-29 comes back as 2017-05-29T05:00:00.000Z in a process running at UTC-5

  PostgreSQL · verified 2026-10-15 · 0 confirmations

• pg_upgrade to PostgreSQL 18 stops with 'old cluster does not use data checksums but the new one does'

  old cluster does not use data checksums but the new one does

  PostgreSQL · verified 2026-10-15 · 0 confirmations

• postgres:18 container fails to start or loses data when the volume is mounted at /var/lib/postgresql/data

  error mounting "..." to rootfs at "/var/lib/postgresql/data": ... no such file or directory: unknown

  PostgreSQL · verified 2026-10-15 · 0 confirmations

• postgres.js through PgBouncer or the Supabase pooler fails with 'prepared statement already exists'

  PostgresError: prepared statement "p1" already exists

  PostgreSQL · verified 2026-10-15 · 0 confirmations

• postgres:latest container refuses to start with 'database files are incompatible with server'

  FATAL: database files are incompatible with server

  PostgreSQL · verified 2026-10-15 · 0 confirmations

• psycopg 3 raises 'syntax error at or near "$1"' on SET or NOTIFY with parameters that worked in psycopg2

  psycopg.errors.SyntaxError: syntax error at or near "$1"

  PostgreSQL · verified 2026-10-15 · 0 confirmations

• psycopg 3 through PgBouncer fails after a few runs with 'prepared statement "_pg3_0" already exists'

  psycopg.errors.DuplicatePreparedStatement: prepared statement "_pg3_0" already exists

  PostgreSQL · verified 2026-10-15 · 0 confirmations

• psycopg 3 'with connection' block closes the connection that psycopg2 kept open

  psycopg.OperationalError: the connection is closed

  PostgreSQL · verified 2026-10-15 · 0 confirmations

• Serverless or hot-reloading apps hit 'sorry, too many clients already' on PostgreSQL

  FATAL: sorry, too many clients already

  PostgreSQL · verified 2026-10-15 · 0 confirmations

claude mcp add --transport http footgun https://getfootgun.com/api/mcp