Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Update default PostgreSQL version to newest in Docker builds #3508

Open
mathemancer opened this issue Mar 23, 2024 · 0 comments
Open

Update default PostgreSQL version to newest in Docker builds #3508

mathemancer opened this issue Mar 23, 2024 · 0 comments
Labels
affects: technical debt Improves the state of the codebase needs: product approval It's not yet clear that this issue will actually improve Mathesar from a user's perspective needs: requirements The problem is clear and worth solving, but we're not yet sure of the best solution restricted: maintainers Only maintainers can resolve this issue type: enhancement New feature or request work: docker Related to our production or development docker setup work: installation
Milestone

Comments

@mathemancer
Copy link
Contributor

Problem

Currently, the version of the PostgreSQL server internal to the mathesar/mathesar-prod docker image is 15, and the default version of the PostgreSQL server built as part of our testing, development, and production Docker Compose setups is 13. These are out of date.

Proposed solution

We need to

  • determine the problems for users if we update these.
    • For example, a user who uses the production Docker image will not be able to update easily to the newest Docker image if we change the PostgreSQL version.
    • Perhaps we should publish different editions of production Mathesar docker images for different PG versions.
  • Based on that discussion, update the versions used for building the prod image, and the versions used by default in the docker compose setup.

Additional context

Apparently, PostgreSQL 17 is likely to come out before 0.1.7, so we should consider trying to get that included in our testing matrix and use it by default for image building.

@mathemancer mathemancer added type: enhancement New feature or request needs: triage This issue has not yet been reviewed by a maintainer labels Mar 23, 2024
@mathemancer mathemancer added this to the v0.1.7 milestone Mar 23, 2024
@mathemancer mathemancer added needs: requirements The problem is clear and worth solving, but we're not yet sure of the best solution affects: technical debt Improves the state of the codebase needs: product approval It's not yet clear that this issue will actually improve Mathesar from a user's perspective work: docker Related to our production or development docker setup work: installation restricted: maintainers Only maintainers can resolve this issue and removed needs: triage This issue has not yet been reviewed by a maintainer labels Mar 23, 2024
@kgodey kgodey modified the milestones: v0.1.7, Beta Apr 3, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
affects: technical debt Improves the state of the codebase needs: product approval It's not yet clear that this issue will actually improve Mathesar from a user's perspective needs: requirements The problem is clear and worth solving, but we're not yet sure of the best solution restricted: maintainers Only maintainers can resolve this issue type: enhancement New feature or request work: docker Related to our production or development docker setup work: installation
Projects
None yet
Development

No branches or pull requests

2 participants