postgres: ensure `data_checksums` is `on` for pg v18+

Open
#2,300 2 comments 0 reactions 0 assignees View on GitHub

Maintainers usually reply within 1 day

Nobody has claimed this yet.

Assessment

Difficulty
3/5
Estimated time
1-2 days
Newbie friendliness
48/100
Issue type
Feature
Clarity
Mostly clear
Activity status
Active
Tech stack
postgresql
Domain
databases

Research direction

Read related issue #2297 and find where ODK Central configures or initializes PostgreSQL. Check how the supported PostgreSQL version is determined and how data_checksums is set. Done means checksums are enabled for PostgreSQL 18 and later, while older versions remain unaffected.

Written by the indexing model from the issue text.

Description

  • off by default for 9.6, 14
  • seems to be on for (some?) RDS instances
  • ensures error thrown when data is corrupted on disk

[!WARNING]
Only enable for postgres 18+

Something like

docker compose exec postgres14 pg_checksums --enable --progress

Add to pg-diagnostics script.

Related
Dominant language
JavaScript
Stars
233
Forks
241
Avg merge
1d 22h
Merged PRs (30d)
13

Getting set up

  • Ships a Dockerfile or Docker Compose file
  • Has a pull request template
  • No contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from getodk/central

All issues in getodk/central

Similar issues

More JavaScript issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.