Question: How to install pg_repack package for old minor versions?

[Medzon888]

Hi!

I have an issue where I need to install oldest minor version of postgresql like 14.14 (every minor but not latest) at debian server. Ubuntu 24.04 for example. When I trying to install pg_repack via apt install postgresql-14-repack its telling me that they will upgrade postgresql-14 but i dont want it to be happens. I want to keep 14.14 for example. How I can avoid this and install repack for oldest minor versions without upgrade? In deps there is no hard code for minor versions. libc and libpq5 is ok
Depends: postgresql-14, libc6 (>= 2.38), libpq5 (>= 9.0~)

apt list --installed | egrep "libc6|libpq5"

libc6-dev/noble-updates,noble-security,now 2.39-0ubuntu8.6 amd64 [installed,automatic]
libc6/noble-updates,noble-security,now 2.39-0ubuntu8.6 amd64 [installed,automatic]
libpq5/noble-pgdg,noble-pgdg-archive,now 18.1-1.pgdg24.04+2 amd64 [installed,automatic]

Is it possible via apt manager or need to build it from source?

Thanks

[andreasscherbaum]

Did you try the --no-upgrade or --nodeps option? This might be an apt-get option, not an apt option, I don't know exactly.

Note that the project does not provide the deb packages, these are provided by the Debian maintainers.

[Medzon888]

Yea, no luck. Also tryed dpkg -i --ignore-depends=postgresql-14 postgresql-14-repack_*.deb but also no luck

[andreasscherbaum]

What exactly are you trying, and does not work? Can you please paste the output?

[Medzon888]

For example:

yes | apt-get install postgresql-client-14=14.14-1.pgdg24.04+1
yes | apt-get install postgresql-14=14.14-1.pgdg24.04+1

# apt list --installed | grep post
postgresql-14/noble-pgdg-archive,now 14.14-1.pgdg24.04+1 amd64 [installed,upgradable to: 14.20-1.pgdg24.04+1]
postgresql-client-14/noble-pgdg-archive,now 14.14-1.pgdg24.04+1 amd64 [installed,upgradable to: 14.20-1.pgdg24.04+1]
postgresql-client-common/noble-pgdg,noble-pgdg-archive,now 287.pgdg24.04+1 all [installed,automatic]
postgresql-common/noble-pgdg,noble-pgdg-archive,now 287.pgdg24.04+1 all [installed,automatic]

apt-get install postgresql-14-repack --no-upgrade

The following packages will be upgraded:
  postgresql-14 postgresql-client-14

...

# apt list --installed | grep post
postgresql-14-repack/noble-pgdg,noble-pgdg-archive,now 1.5.3-1.pgdg24.04+1 amd64 [installed]
postgresql-14/noble-pgdg,noble-pgdg-archive,now 14.20-1.pgdg24.04+1 amd64 [installed]
postgresql-client-14/noble-pgdg,noble-pgdg-archive,now 14.20-1.pgdg24.04+1 amd64 [installed]
postgresql-client-common/noble-pgdg,noble-pgdg-archive,now 287.pgdg24.04+1 all [installed,automatic]
postgresql-common/noble-pgdg,noble-pgdg-archive,now 287.pgdg24.04+1 all [installed,automatic]

[andreasscherbaum]

You might be able to pin (apt-mark hold) the version you have installed.
In general, apt-get install avoids upgrading packages, you might check if one of the other dependencies forces this upgrade.