Need Help With Postgresql

5

This is something we should automate, but you can get your DB healthy again by clearing out WAL files.

  1. fly ssh console
  2. Run pg_controldata -D /data/postgres/, then look for a line like this:
    Latest checkpoint's REDO WAL file:    00000001000000020000002F
  3. Then run
    pg_archivecleanup /data/postgres/pg_wal 00000001000000020000002F

Once it’s healthy again, you can add a 3GB volume, temporarily scale to 2 instances, then remove the old volume and scale back to 1 instance.