Introduction
This article will cover the steps for creating a Remote Debian repository on your Artifactory instance to proxy the APT repository of PostgreSQL packages for Debian and Ubuntu.
Step 1
Create a Remote Debian repository.
Step 2
Under the URL, insert: “https://apt.postgresql.org/pub/repos/apt/” if you wish to proxy PostgreSQL packages for versions newer than 8.3.
PostgreSQL versions up to 8.2 exist in the following URL: “https://apt-archive.postgresql.org/”
Step 3
Configure the Remote Repository on your Debian/Ubuntu instance
- Starting with Ubuntu 24.04, a change has been implemented in managing APT repositories. The system now utilizes the ‘deb822 .sources’ format, located in /etc/apt/sources.list.d/ (e.g., ubuntu.sources).
- To configure an Artifactory APT repository in the new format, create a file named artifactory.sources in the /etc/apt/sources.list.d/ directory. This differs from the older .list format.
- More information can be found in our documentation.
After following the steps above, you should be able to perform “apt install <PACKAGE>”.
For example:
$ apt install postgresql-16 -y
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
The following additional packages will be installed:
…
…
Processing triggers for libc-bin (2.36-9+deb12u13) ...
root@edenb-debian:/home/edenb#