Revisions to how to match pg_repack binary and db version

added header and some sample apt list -a output and made example have difference version numbers

edited Dec 21, 2022 at 2:06

301
1
5

First, check to see if the package version exists for the current distro version:

apt list -a postgresql-11-repack

the type of output will look something like this:

postgresql-11-repack/buster-pgdg 1.4.4-2.pgdg110+1 amd64 [upgradable from: 1.4.4-1.pgdg110+1] postgresql-11-repack/now 1.4.4-1.pgdg110+1 amd64 [installed,upgradable to: 1.4.4-2.pgdg110+1]

postgresql-11-repack/buster-pgdg 1.4.4-2.pgdg110+1 amd64 [upgradable from: 1.4.3-1.pgdg110+1]
postgresql-11-repack/now 1.4.3-1.pgdg110+1 amd64 [installed,upgradable to: 1.4.4-2.pgdg110+1]

If the package version you need is listed, you can then remove the existing package and install the specific version needed by doing:removing the existing package and installing the targeted version as shown below (here is a good reference on why the debian package for the pg_repack extension version 1.4.4 is numbered 1.4.4-1 or 1.4.4-2 and so on)

this is a bit contrived, but in this example I removed 1.4.3 and installed 1.4.4 (the same procedure would apply if you had 1.4.8-1 debian package already installed and you wanted to install 1.4.4-2 specifically):

sudo apt-get --purge remove postgresql-11-repack sudo apt-get install postgresql-11-repack=1.4.4-2

If the package does not show up, you can alternatively build it from source:

git clone https://github.com/reorg/pg_repack.git cd pg_repack/ git checkout tags/ver_1.4.4 make make install

One reason you might want to build from source is because the version of the package you need is from a previous version of the OS and you do not want to deal with that type of joy specifically (example)

First, check to see if the package version exists for the current distro version:

apt list -a postgresql-11-repack

the type of output will look something like this:

postgresql-11-repack/buster-pgdg 1.4.4-2.pgdg110+1 amd64 [upgradable from: 1.4.4-1.pgdg110+1] postgresql-11-repack/now 1.4.4-1.pgdg110+1 amd64 [installed,upgradable to: 1.4.4-2.pgdg110+1]

If the package version you need is listed, you can then remove the existing package and install the specific version needed by doing:

sudo apt-get --purge remove postgresql-11-repack sudo apt-get install postgresql-11-repack=1.4.4-2

If the package does not show up, you can alternatively build it from source:

git clone https://github.com/reorg/pg_repack.git cd pg_repack/ git checkout tags/ver_1.4.4 make make install

One reason you might want to build from source is because the version of the package you need is from a previous version of the OS and you do not want to deal with that type of joy specifically (example)

First, check to see if the package version exists for the current distro version:

apt list -a postgresql-11-repack

the type of output will look something like this:

postgresql-11-repack/buster-pgdg 1.4.4-2.pgdg110+1 amd64 [upgradable from: 1.4.3-1.pgdg110+1]
postgresql-11-repack/now 1.4.3-1.pgdg110+1 amd64 [installed,upgradable to: 1.4.4-2.pgdg110+1]

If the package version you need is listed, you can then remove the existing package and install the specific version needed by removing the existing package and installing the targeted version as shown below (here is a good reference on why the debian package for the pg_repack extension version 1.4.4 is numbered 1.4.4-1 or 1.4.4-2 and so on)

this is a bit contrived, but in this example I removed 1.4.3 and installed 1.4.4 (the same procedure would apply if you had 1.4.8-1 debian package already installed and you wanted to install 1.4.4-2 specifically):

sudo apt-get --purge remove postgresql-11-repack sudo apt-get install postgresql-11-repack=1.4.4-2

If the package does not show up, you can alternatively build it from source:

git clone https://github.com/reorg/pg_repack.git cd pg_repack/ git checkout tags/ver_1.4.4 make make install

One reason you might want to build from source is because the version of the package you need is from a previous version of the OS and you do not want to deal with that type of joy specifically (example)

added header and some sample apt list -a output

Source Link

edited Dec 21, 2022 at 1:49

justsomeguy

301
1
5

First, check to see if the package version exists for the current distro version:

First, check to see if the package version exists for the current distro version:

apt list -a postgresql-11-repack

If so, then, you can remove the existing package and install the specific version needed by doingtype of output will look something like this:

postgresql-11-repack/buster-pgdg 1.4.4-2.pgdg110+1 amd64 [upgradable from: 1.4.4-1.pgdg110+1] postgresql-11-repack/now 1.4.4-1.pgdg110+1 amd64 [installed,upgradable to: 1.4.4-2.pgdg110+1]

If the package version you need is listed, you can then remove the existing package and install the specific version needed by doing:

sudo apt-get --purge remove postgresql-11-repack sudo apt-get install postgresql-11-repack=1.4.4-2

If not then you can build it from source:If the package does not show up, you can alternatively build it from source:

git clone https://github.com/reorg/pg_repack.git cd pg_repack/ git checkout tags/ver_1.4.4 make make install

One reason you might want to build from source is because the version of the package you need is from a previous version of the OS and you do not want to deal with that type of joy specifically (example)

First, check to see if the package version exists for the current distro version:

apt list -a postgresql-11-repack

If so, then, you can remove the existing package and install the specific version needed by doing:

sudo apt-get --purge remove postgresql-11-repack sudo apt-get install postgresql-11-repack=1.4.4-2

If not then you can build it from source:

git clone https://github.com/reorg/pg_repack.git cd pg_repack/ git checkout tags/ver_1.4.4 make make install

One reason you might want to build from source is because the version of the package you need is from a previous version of the OS and you do not want to deal with that type of joy specifically (example)

First, check to see if the package version exists for the current distro version:

apt list -a postgresql-11-repack

the type of output will look something like this:

postgresql-11-repack/buster-pgdg 1.4.4-2.pgdg110+1 amd64 [upgradable from: 1.4.4-1.pgdg110+1] postgresql-11-repack/now 1.4.4-1.pgdg110+1 amd64 [installed,upgradable to: 1.4.4-2.pgdg110+1]

If the package version you need is listed, you can then remove the existing package and install the specific version needed by doing:

sudo apt-get --purge remove postgresql-11-repack sudo apt-get install postgresql-11-repack=1.4.4-2

If the package does not show up, you can alternatively build it from source:

git clone https://github.com/reorg/pg_repack.git cd pg_repack/ git checkout tags/ver_1.4.4 make make install

One reason you might want to build from source is because the version of the package you need is from a previous version of the OS and you do not want to deal with that type of joy specifically (example)

adding source build to the answer

Source Link

edited Dec 19, 2022 at 22:47

justsomeguy

301
1
5

you can removeFirst, check to see if the existing package by doingversion exists for the current distro version:

sudo apt-get --purgelist remove-a postgresql-11-repack

then If so, then, you can remove the existing package and install the specific version you needneeded by doing:

sudo apt-get --purge remove postgresql-11-repack sudo apt-get install postgresql-11-repack=1.4.4-2

if for some reason the version of the package needed is from a previous version of the OS and you doIf not want to deal with that type of joy specifically (example),then you can build it from source:

git clone https://github.com/reorg/pg_repack.git cd pg_repack/ git checkout tags/ver_1.4.4 make make install

One reason you might want to build from source is because the version of the package you need is from a previous version of the OS and you do not want to deal with that type of joy specifically (example)

you can remove the existing package by doing:

sudo apt-get --purge remove postgresql-11-repack

then, you can install the specific version you need by doing:

sudo apt-get install postgresql-11-repack=1.4.4-2

if for some reason the version of the package needed is from a previous version of the OS and you do not want to deal with that type of joy specifically (example), you can build from source:

git clone https://github.com/reorg/pg_repack.git cd pg_repack/ git checkout tags/ver_1.4.4 make make install

First, check to see if the package version exists for the current distro version:

apt list -a postgresql-11-repack

If so, then, you can remove the existing package and install the specific version needed by doing:

sudo apt-get --purge remove postgresql-11-repack sudo apt-get install postgresql-11-repack=1.4.4-2

If not then you can build it from source:

git clone https://github.com/reorg/pg_repack.git cd pg_repack/ git checkout tags/ver_1.4.4 make make install

One reason you might want to build from source is because the version of the package you need is from a previous version of the OS and you do not want to deal with that type of joy specifically (example)

adding source build to the answer

Source Link

edited Dec 19, 2022 at 22:36

justsomeguy

301
1
5

Loading

Source Link

answered Dec 19, 2022 at 22:12

justsomeguy

301
1
5

Loading

Stack Exchange Network

Return to Answer

First, check to see if the package version exists for the current distro version:

First, check to see if the package version exists for the current distro version:

First, check to see if the package version exists for the current distro version:

First, check to see if the package version exists for the current distro version:

First, check to see if the package version exists for the current distro version: