limit postgres version in CI

[haritamar]

null

Summary by CodeRabbit

• Chores
  • Updated PostgreSQL version to 15 in test environment.

[linear]

ELE-5147 Fix postgres in OSS CI

[github-actions]

👋 @haritamar
Thank you for raising your pull request.
Please make sure to add tests and document all user-facing changes.
You can do this by editing the docs files in this pull request.

[coderabbitai]

Walkthrough

The PostgreSQL Docker image in the end-to-end test docker-compose configuration was updated from postgres (defaulting to latest) to an explicitly pinned version postgres:15, ensuring consistent container image versions across test runs.

Changes

Cohort / File(s)	Summary
Docker Compose Test Configuration tests/e2e_dbt_project/docker-compose.yml	Updated postgres service image tag from postgres to postgres:15 for explicit version pinning

Estimated code review effort

🎯 1 (Trivial) | ⏱️ ~2 minutes

• Straightforward version pin update in test configuration with no logic modifications

Poem

🐰 A version pinned, precise and clear,
Postgres fifteen stationed here!
No more the latest, wild and free—
Our tests now run consistently. ✨

Pre-merge checks and finishing touches

❌ Failed checks (1 warning)

Check name	Status	Explanation	Resolution
Docstring Coverage	⚠️ Warning	Docstring coverage is 0.00% which is insufficient. The required threshold is 80.00%.	You can run @coderabbitai generate docstrings to improve docstring coverage.

✅ Passed checks (2 passed)

Check name	Status	Explanation
Description Check	✅ Passed	Check skipped - CodeRabbit’s high-level summary is enabled.
Title Check	✅ Passed	The pull request title "limit postgres version in CI" directly and accurately describes the main change in the changeset. The only modification is updating the postgres service image from unversioned postgres to postgres:15 in the E2E test docker-compose file, which is precisely a version constraint (limit) applied to postgres in the CI environment. The title is concise, clear, and specific enough that a teammate scanning the commit history would immediately understand the primary change without ambiguity.

✨ Finishing touches

🧪 Generate unit tests (beta)

• Create PR with unit tests
• Post copyable unit tests in a comment
• Commit unit tests in branch ele-5147-fix-postgres-in-oss-ci

---

📜 Recent review details

Configuration used: CodeRabbit UI

Review profile: CHILL

Plan: Pro

Disabled knowledge base sources:

• Linear integration is disabled by default for public repositories

You can enable these sources in your CodeRabbit configuration.

📥 Commits

Reviewing files that changed from the base of the PR and between ff1fc83 and f07c245.

📒 Files selected for processing (1)

• tests/e2e_dbt_project/docker-compose.yml (1 hunks)

⏰ Context from checks skipped due to timeout of 90000ms. You can increase the timeout in your CodeRabbit configuration to a maximum of 15 minutes (900000ms). (1)

• GitHub Check: code-quality

🔇 Additional comments (1)

tests/e2e_dbt_project/docker-compose.yml (1)

5-5: Pinning PostgreSQL version improves test reproducibility.

The explicit version pin to postgres:15 replaces the implicit latest tag, ensuring consistent test environments across CI runs. PostgreSQL 15 is actively supported through November 11, 2027, making it a solid, stable choice for this test environment. This change prevents non-deterministic test failures from unexpected breaking changes in newer PostgreSQL versions and aligns with CI best practices.

---

_{Comment @coderabbitai help to get the list of available commands and usage tips.}