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

[BUG] Postgesql version install 14 instead of 13 #324

Open
teankie opened this issue May 17, 2022 · 0 comments
Open

[BUG] Postgesql version install 14 instead of 13 #324

teankie opened this issue May 17, 2022 · 0 comments
Labels

Comments

@teankie
Copy link
Contributor

teankie commented May 17, 2022

Your setup

Formula commit hash / release tag

Release 0.44

Versions reports (master & minion)

Salt Version:
Salt: 3004.1

Pillar / config used


      ID: postgresql-repo
Function: pkgrepo.managed
    Name: deb [signed-by=/usr/share/postgresql-common/pgdg/apt.postgresql.org.gpg] http://apt.postgresql.org/pub/repos/apt focal-pgdg main
  Result: True
 Comment: Configured package repo 'deb [signed-by=/usr/share/postgresql-common/pgdg/apt.postgresql.org.gpg] http://apt.postgresql.org/pub/repos/apt focal-pgdg main'
 Started: 12:16:23.219029
Duration: 10943.796 ms
 Changes:   
          ----------
          repo:
              deb [signed-by=/usr/share/postgresql-common/pgdg/apt.postgresql.org.gpg] http://apt.postgresql.org/pub/repos/apt focal-pgdg main

      ID: postgresql-server
Function: pkg.installed
  Result: True
 Comment: The following packages were installed/updated: postgresql-contrib
          The following packages were already installed: postgresql-13
 Started: 12:16:34.163722
Duration: 21929.67 ms
 Changes:   
          ----------
          postgresql-14:
              ----------
              new:
                  14.3-1.pgdg20.04+1
              old:
          postgresql-client-14:
              ----------
              new:
                  14.3-1.pgdg20.04+1
              old:
          postgresql-contrib:
              ----------
              new:
                  14+241.pgdg20.04+1
              old:

Bug details

Describe the bug

We see that when we put version: 13 into the pillar we still see at Ubunut 20.04 LTS that also Postgresql-14 will be installed.

dpkg -l | grep postgres

ii pgdg-keyring 2018.2 all keyring for apt.postgresql.org
ii postgresql-13 13.7-1.pgdg20.04+1 amd64 The World's Most Advanced Open Source Relational Database
ii postgresql-14 14.3-1.pgdg20.04+1 amd64 The World's Most Advanced Open Source Relational Database
ii postgresql-client-13 13.7-1.pgdg20.04+1 amd64 front-end programs for PostgreSQL 13
ii postgresql-client-14 14.3-1.pgdg20.04+1 amd64 front-end programs for PostgreSQL 14
ii postgresql-client-common 241.pgdg20.04+1 all manager for multiple PostgreSQL client versions
ii postgresql-common 241.pgdg20.04+1 all PostgreSQL database-cluster manager
ii postgresql-contrib 14+241.pgdg20.04+1 all additional facilities for PostgreSQL (supported version)

Steps to reproduce the bug

salt-call state.sls postgres.server

Expected behaviour

We think dat de postgresql-repo must be used the version so OS do not install postgres-14 version

Attempts to fix the bug

You should could update the postgresql-repo with 'deb [signed-by=/usr/share/postgresql-common/pgdg/apt.postgresql.org.gpg] http://apt.postgresql.org/pub/repos/apt focal-pgdg main {version}'.
In this case this will be 13.

Additional context

@teankie teankie added the bug label May 17, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant