[BUG] Postgesql version install 14 instead of 13
teankie opened this issue · 0 comments
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.