Can't install percona-ppg-server

Hello, there. I’ve an open source project that uses postgres and I’m trying to add percona to my tech stack. I’m following the official documentation and there it is written I should be able to install one of the packages by doing:

sudo apt install percona-ppg-server

Nevertheless, when I ran that code inside my docker container I received the following error:

E: Unable to locate package percona-ppg-server

Link to the documentation: Install on Debian and Ubuntu - Percona Distribution for PostgreSQL
Link to my project: feat(docker): Start percona integration WIP (0e90d779) · Commits · Gustavo Figueira Olegário / hireme · GitLab

Please, let me know if I’m doing something wrong. I’m running Ubuntu 22.04 and I’m trying to use percona along with postgres 14.

1 Like

Hi @olegario96,
Thank you for reporting this issue. It seems that there is a mistake in the documentation.
Please try to run the following command for ppg-14 packages installation:

apt install percona-ppg-server-14

Also, please ensure that you have configured and enabled the ppg-14 repository per the documentation.

From our end, we’ll report this issue to our TW team to fix it.

1 Like

Hey @Alex_Miroshnychenko thanks for the suggestion. However, Ubuntu still says that package doesn’t exist:

#7 10.48 E: Unable to locate package percona-ppg-server-14
1 Like

Hi @olegario96
It looks like you haven’t enabled the needed repository before installing the percona-ppg-server-14 package(Install on Debian and Ubuntu - Percona Distribution for PostgreSQL).
Please take a look at the following output with commands that were used for installing percona-ppg-server-14 into ubuntu:jammy docker container.

percona-ppg-server-14 installation: ubuntu:jammy
root@0c617d17500a:/# apt update && apt install wget lsb-release gnupg curl -y
Get:1 http://archive.ubuntu.com/ubuntu jammy InRelease [270 kB]
...
Running hooks in /etc/ca-certificates/update.d...
done.

root@0c617d17500a:/# wget https://repo.percona.com/apt/percona-release_latest.$(lsb_release -sc)_all.deb
--2023-01-23 10:45:38--  https://repo.percona.com/apt/percona-release_latest.jammy_all.deb
Resolving repo.percona.com (repo.percona.com)... 74.121.199.235
Connecting to repo.percona.com (repo.percona.com)|74.121.199.235|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 11804 (12K) [application/x-debian-package]
Saving to: 'percona-release_latest.jammy_all.deb'

percona-release_latest.jammy_all.deb                        100%[=========================================================================================================================================>]  11.53K  --.-KB/s    in 0.01s

2023-01-23 10:45:38 (1007 KB/s) - 'percona-release_latest.jammy_all.deb' saved [11804/11804]


root@0c617d17500a:/# dpkg -i percona-release_latest.$(lsb_release -sc)_all.deb
Selecting previously unselected package percona-release.
(Reading database ... 5960 files and directories currently installed.)
Preparing to unpack percona-release_latest.jammy_all.deb ...
Unpacking percona-release (1.0-27.generic) ...
Setting up percona-release (1.0-27.generic) ...
* Enabling the Percona Original repository
<*> All done!
==> Please run "apt-get update" to apply changes
* Enabling the Percona Release repository
<*> All done!
==> Please run "apt-get update" to apply changes
The percona-release package now contains a percona-release script that can enable additional repositories for our newer products.

For example, to enable the Percona Server 8.0 repository use:

  percona-release setup ps80

Note: To avoid conflicts with older product versions, the percona-release setup command may disable our original repository for some products.

For more information, please visit:
  https://www.percona.com/doc/percona-repo-config/percona-release.html


root@0c617d17500a:/# apt update
Get:1 http://repo.percona.com/percona/apt jammy InRelease [15.7 kB]
Hit:2 http://security.ubuntu.com/ubuntu jammy-security InRelease
Get:3 http://repo.percona.com/prel/apt jammy InRelease [15.7 kB]
Hit:4 http://archive.ubuntu.com/ubuntu jammy InRelease
Hit:5 http://archive.ubuntu.com/ubuntu jammy-updates InRelease
Hit:6 http://archive.ubuntu.com/ubuntu jammy-backports InRelease
Get:7 http://repo.percona.com/percona/apt jammy/main Sources [2020 B]
Get:8 http://repo.percona.com/percona/apt jammy/main amd64 Packages [4075 B]
Get:9 http://repo.percona.com/prel/apt jammy/main amd64 Packages [415 B]
Fetched 37.9 kB in 1s (41.1 kB/s)
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
2 packages can be upgraded. Run 'apt list --upgradable' to see them.


root@0c617d17500a:/# percona-release setup ppg-14
* Disabling all Percona Repositories
* Enabling the Percona Distribution for PostgreSQL 1.4 repository
Hit:1 http://archive.ubuntu.com/ubuntu jammy InRelease
Get:2 http://repo.percona.com/ppg-14/apt jammy InRelease [15.7 kB]
Hit:3 http://archive.ubuntu.com/ubuntu jammy-updates InRelease
Hit:4 http://repo.percona.com/prel/apt jammy InRelease
Hit:5 http://archive.ubuntu.com/ubuntu jammy-backports InRelease
Hit:6 http://security.ubuntu.com/ubuntu jammy-security InRelease
Get:7 http://repo.percona.com/ppg-14/apt jammy/main Sources [7328 B]
Get:8 http://repo.percona.com/ppg-14/apt jammy/main amd64 Packages [47.5 kB]
Fetched 70.6 kB in 1s (76.2 kB/s)
Reading package lists... Done


root@0c617d17500a:/# apt install percona-ppg-server-14
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
The following additional packages will be installed:
  cron libbsd0 libcommon-sense-perl libedit2 libgdbm-compat4 libgdbm6 libicu70 libjson-perl libjson-xs-perl libllvm11 libmd0 libperl5.34 libpopt0 libpq5 libsensors-config libsensors5 libtypes-serialiser-perl libxml2 libxslt1.1 locales
  logrotate netbase percona-pg-stat-monitor14 percona-postgresql-14 percona-postgresql-14-pgaudit percona-postgresql-14-repack percona-postgresql-14-wal2json percona-postgresql-client-14 percona-postgresql-common
  percona-postgresql-contrib perl perl-modules-5.34 postgresql-client-common postgresql-common ssl-cert sysstat tzdata ucf xz-utils
Suggested packages:
  anacron checksecurity default-mta | mail-transport-agent gdbm-l10n lm-sensors bsd-mailx | mailx percona-postgresql-doc-14 perl-doc libterm-readline-gnu-perl | libterm-readline-perl-perl make libtap-harness-archive-perl isag
The following NEW packages will be installed:
  cron libbsd0 libcommon-sense-perl libedit2 libgdbm-compat4 libgdbm6 libicu70 libjson-perl libjson-xs-perl libllvm11 libmd0 libperl5.34 libpopt0 libpq5 libsensors-config libsensors5 libtypes-serialiser-perl libxml2 libxslt1.1 locales
  logrotate netbase percona-pg-stat-monitor14 percona-postgresql-14 percona-postgresql-14-pgaudit percona-postgresql-14-repack percona-postgresql-14-wal2json percona-postgresql-client-14 percona-postgresql-common
  percona-postgresql-contrib percona-ppg-server-14 perl perl-modules-5.34 postgresql-client-common postgresql-common ssl-cert sysstat tzdata ucf xz-utils
0 upgraded, 40 newly installed, 0 to remove and 2 not upgraded.
Need to get 71.5 MB of archives.
After this operation, 256 MB of additional disk space will be used.
Do you want to continue? [Y/n]
Get:1 http://repo.percona.com/ppg-14/apt jammy/main amd64 postgresql-client-common all 1:241-6.jammy [33.5 kB]
Get:2 http://archive.ubuntu.com/ubuntu jammy/main amd64 cron amd64 3.0pl1-137ubuntu3 [73.7 kB]
Get:3 http://repo.percona.com/ppg-14/apt jammy/main amd64 postgresql-common all 1:241-6.jammy [188 kB]
Get:4 http://repo.percona.com/ppg-14/apt jammy/main amd64 percona-postgresql-common all 1:241-6.jammy [5876 B]
Get:5 http://archive.ubuntu.com/ubuntu jammy-updates/main amd64 perl-modules-5.34 all 5.34.0-3ubuntu1.1 [2976 kB]
Get:6 http://repo.percona.com/ppg-14/apt jammy/main amd64 libpq5 amd64 2:14.6-1.jammy [261 kB]
Get:7 http://repo.percona.com/ppg-14/apt jammy/main amd64 percona-postgresql-client-14 amd64 2:14.6-1.jammy [2724 kB]
Get:8 http://repo.percona.com/ppg-14/apt jammy/main amd64 percona-postgresql-14 amd64 2:14.6-1.jammy [23.0 MB]
Get:9 http://repo.percona.com/ppg-14/apt jammy/main amd64 percona-pg-stat-monitor14 amd64 1:1.1.1-1.jammy [90.5 kB]
Get:10 http://repo.percona.com/ppg-14/apt jammy/main amd64 percona-postgresql-14-pgaudit amd64 1:1.6.2-4.jammy [55.4 kB]
Get:11 http://repo.percona.com/ppg-14/apt jammy/main amd64 percona-postgresql-14-repack amd64 1:1.4.8-1.jammy [115 kB]
Get:12 http://repo.percona.com/ppg-14/apt jammy/main amd64 percona-postgresql-14-wal2json amd64 1:2.5-2.jammy [72.1 kB]
Get:13 http://repo.percona.com/ppg-14/apt jammy/main amd64 percona-postgresql-contrib all 1:241-6.jammy [3376 B]
Get:14 http://repo.percona.com/ppg-14/apt jammy/main amd64 percona-ppg-server-14 amd64 1:14.6-1.jammy [2580 B]
Get:15 http://archive.ubuntu.com/ubuntu jammy/main amd64 libgdbm6 amd64 1.23-1 [33.9 kB]
Get:16 http://archive.ubuntu.com/ubuntu jammy/main amd64 libgdbm-compat4 amd64 1.23-1 [6606 B]
Get:17 http://archive.ubuntu.com/ubuntu jammy-updates/main amd64 libperl5.34 amd64 5.34.0-3ubuntu1.1 [4819 kB]
Get:18 http://archive.ubuntu.com/ubuntu jammy-updates/main amd64 perl amd64 5.34.0-3ubuntu1.1 [232 kB]
Get:19 http://archive.ubuntu.com/ubuntu jammy/main amd64 libjson-perl all 4.04000-1 [81.8 kB]
Get:20 http://archive.ubuntu.com/ubuntu jammy/main amd64 netbase all 6.3 [12.9 kB]
Get:21 http://archive.ubuntu.com/ubuntu jammy/main amd64 ssl-cert all 1.1.2 [17.4 kB]
Get:22 http://archive.ubuntu.com/ubuntu jammy/main amd64 ucf all 3.0043 [56.1 kB]
Get:23 http://archive.ubuntu.com/ubuntu jammy/main amd64 libmd0 amd64 1.0.4-1build1 [23.0 kB]
Get:24 http://archive.ubuntu.com/ubuntu jammy/main amd64 libbsd0 amd64 0.11.5-1 [44.8 kB]
Get:25 http://archive.ubuntu.com/ubuntu jammy/main amd64 libicu70 amd64 70.1-2 [10.6 MB]
Get:26 http://archive.ubuntu.com/ubuntu jammy/main amd64 libpopt0 amd64 1.18-3build1 [28.2 kB]
Get:27 http://archive.ubuntu.com/ubuntu jammy-updates/main amd64 libxml2 amd64 2.9.13+dfsg-1ubuntu0.2 [764 kB]
Get:28 http://archive.ubuntu.com/ubuntu jammy-updates/main amd64 locales all 2.35-0ubuntu3.1 [4249 kB]
Get:29 http://archive.ubuntu.com/ubuntu jammy-updates/main amd64 logrotate amd64 3.19.0-1ubuntu1.1 [54.3 kB]
Get:30 http://archive.ubuntu.com/ubuntu jammy-updates/main amd64 tzdata all 2022g-0ubuntu0.22.04.1 [333 kB]
Get:31 http://archive.ubuntu.com/ubuntu jammy/main amd64 libedit2 amd64 3.1-20210910-1build1 [96.8 kB]
Get:32 http://archive.ubuntu.com/ubuntu jammy/main amd64 xz-utils amd64 5.2.5-2ubuntu1 [84.8 kB]
Get:33 http://archive.ubuntu.com/ubuntu jammy/main amd64 libcommon-sense-perl amd64 3.75-2build1 [21.1 kB]
Get:34 http://archive.ubuntu.com/ubuntu jammy/main amd64 libtypes-serialiser-perl all 1.01-1 [11.6 kB]
Get:35 http://archive.ubuntu.com/ubuntu jammy/main amd64 libjson-xs-perl amd64 4.030-1build3 [87.2 kB]
Get:36 http://archive.ubuntu.com/ubuntu jammy/universe amd64 libllvm11 amd64 1:11.1.0-6 [19.6 MB]
Get:37 http://archive.ubuntu.com/ubuntu jammy/main amd64 libsensors-config all 1:3.6.0-7ubuntu1 [5274 B]
Get:38 http://archive.ubuntu.com/ubuntu jammy/main amd64 libsensors5 amd64 1:3.6.0-7ubuntu1 [26.3 kB]
Get:39 http://archive.ubuntu.com/ubuntu jammy-updates/main amd64 libxslt1.1 amd64 1.1.34-4ubuntu0.22.04.1 [164 kB]
Get:40 http://archive.ubuntu.com/ubuntu jammy-updates/main amd64 sysstat amd64 12.5.2-2ubuntu0.1 [487 kB]
Fetched 71.5 MB in 2s (34.8 MB/s)```
2 Likes

Hmm that’s weird. I did exactly what you said, but still getting the same error:

FROM ubuntu:22.04

ARG DEBIAN_FRONTEND=noninteractive

# Skipping version check here since postgres package
# does not support = operator
# hadolint ignore=DL3008
RUN apt-get update \
    && apt-get install -y --no-install-recommends \
    software-properties-common \
    wget \
    curl \
    gnupg \
    lsb-release

RUN wget https://repo.percona.com/apt/percona-release_latest.$(lsb_release -sc)_all.deb \
    && dpkg -i percona-release_latest.$(lsb_release -sc)_all.deb \
    && apt-get update \
    && percona-release setup -y ppg-14 \
    && apt-get install -y --no-install-recommends \
    percona-ppg-server-14 \
    && apt-get clean \
    && rm -rf /var/lib/apt/lists/*
1 Like

That’s really weird because I’m able to create a docker image using your Dockerfile:

Long output
[root@alex-psmdb tmp]# date; cat Dockerfile ; date; docker build --no-cache -t pg-14-test:latest .; date
Mon Jan 23 14:39:07 UTC 2023
FROM ubuntu:22.04

ARG DEBIAN_FRONTEND=noninteractive

# Skipping version check here since postgres package
# does not support = operator
# hadolint ignore=DL3008
RUN apt-get update \
    && apt-get install -y --no-install-recommends \
    software-properties-common \
    wget \
    curl \
    gnupg \
    lsb-release

RUN wget https://repo.percona.com/apt/percona-release_latest.$(lsb_release -sc)_all.deb \
    && dpkg -i percona-release_latest.$(lsb_release -sc)_all.deb \
    && apt-get update \
    && percona-release setup -y ppg-14 \
    && apt-get install -y --no-install-recommends \
    percona-ppg-server-14 \
    && apt-get clean \
    && rm -rf /var/lib/apt/lists/*

# User created by the `postgres` package
USER postgres

RUN /etc/init.d/postgresql start \
    && psql --command "ALTER USER postgres PASSWORD 'postgres';" \
    && psql --command "CREATE DATABASE hireme;" \
    && psql --command "ALTER USER postgres SET timezone='GMT';" \
    && echo "host all  all    0.0.0.0/0  md5" >> /etc/postgresql/14/main/pg_hba.conf \
    && echo "listen_addresses='*'" >> /etc/postgresql/14/main/postgresql.conf

EXPOSE 5432

VOLUME [ \
    "/etc/postgresql", \
    "/var/log/postgresql", \
    "/var/lib/postgresql" \
]

CMD [ \
    "/usr/lib/postgresql/14/bin/postgres", \
    "-D", "/var/lib/postgresql/14/main", \
    "-c", "config_file=/etc/postgresql/14/main/postgresql.conf" \
]

Mon Jan 23 14:39:07 UTC 2023
Sending build context to Docker daemon  5.413GB
Step 1/9 : FROM ubuntu:22.04
 ---> 6b7dfa7e8fdb
Step 2/9 : ARG DEBIAN_FRONTEND=noninteractive
 ---> Running in 2ce3feeff4e7
Removing intermediate container 2ce3feeff4e7
 ---> 85df5ddba676
Step 3/9 : RUN apt-get update     && apt-get install -y --no-install-recommends     software-properties-common     wget     curl     gnupg     lsb-release
 ---> Running in 58ce43d3677f
...
Updating certificates in /etc/ssl/certs...
0 added, 0 removed; done.
Running hooks in /etc/ca-certificates/update.d...
done.
Processing triggers for dbus (1.12.20-2ubuntu4.1) ...
Removing intermediate container 58ce43d3677f
 ---> a7276f6b9c5f
Step 4/9 : RUN wget https://repo.percona.com/apt/percona-release_latest.$(lsb_release -sc)_all.deb     && dpkg -i percona-release_latest.$(lsb_release -sc)_all.deb     && apt-get update     && percona-release setup -y ppg-14     && apt-get install -y --no-install-recommends     percona-ppg-server-14     && apt-get clean     && rm -rf /var/lib/apt/lists/*
 ---> Running in ef7c5572dcd6
--2023-01-23 14:40:23--  https://repo.percona.com/apt/percona-release_latest.jammy_all.deb
Resolving repo.percona.com (repo.percona.com)... 74.121.199.235
Connecting to repo.percona.com (repo.percona.com)|74.121.199.235|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 11804 (12K) [application/x-debian-package]
Saving to: 'percona-release_latest.jammy_all.deb'

     0K .......... .                                          100% 1.03M=0.01s

2023-01-23 14:40:23 (1.03 MB/s) - 'percona-release_latest.jammy_all.deb' saved [11804/11804]

Selecting previously unselected package percona-release.
(Reading database ... 9224 files and directories currently installed.)
Preparing to unpack percona-release_latest.jammy_all.deb ...
Unpacking percona-release (1.0-27.generic) ...
Setting up percona-release (1.0-27.generic) ...
* Enabling the Percona Original repository
<*> All done!
==> Please run "apt-get update" to apply changes
* Enabling the Percona Release repository
<*> All done!
==> Please run "apt-get update" to apply changes
The percona-release package now contains a percona-release script that can enable additional repositories for our newer products.

For example, to enable the Percona Server 8.0 repository use:

  percona-release setup ps80

Note: To avoid conflicts with older product versions, the percona-release setup command may disable our original repository for some products.

For more information, please visit:
  https://www.percona.com/doc/percona-repo-config/percona-release.html

Get:1 http://repo.percona.com/percona/apt jammy InRelease [15.7 kB]
Get:2 http://repo.percona.com/prel/apt jammy InRelease [15.7 kB]
Hit:3 http://archive.ubuntu.com/ubuntu jammy InRelease
Hit:4 http://security.ubuntu.com/ubuntu jammy-security InRelease
Get:5 http://repo.percona.com/percona/apt jammy/main Sources [2018 B]
Hit:6 http://archive.ubuntu.com/ubuntu jammy-updates InRelease
Get:7 http://repo.percona.com/percona/apt jammy/main amd64 Packages [4080 B]
Hit:8 http://archive.ubuntu.com/ubuntu jammy-backports InRelease
Get:9 http://repo.percona.com/prel/apt jammy/main amd64 Packages [415 B]
Fetched 37.9 kB in 1s (41.1 kB/s)
Reading package lists...
* Disabling all Percona Repositories
* Enabling the Percona Distribution for PostgreSQL 1.4 repository
Get:1 http://repo.percona.com/ppg-14/apt jammy InRelease [15.7 kB]
Hit:2 http://security.ubuntu.com/ubuntu jammy-security InRelease
Hit:3 http://repo.percona.com/prel/apt jammy InRelease
Hit:4 http://archive.ubuntu.com/ubuntu jammy InRelease
Hit:5 http://archive.ubuntu.com/ubuntu jammy-updates InRelease
Hit:6 http://archive.ubuntu.com/ubuntu jammy-backports InRelease
Get:7 http://repo.percona.com/ppg-14/apt jammy/main Sources [7328 B]
Get:8 http://repo.percona.com/ppg-14/apt jammy/main amd64 Packages [47.5 kB]
Fetched 70.6 kB in 1s (76.3 kB/s)
Reading package lists...
Reading package lists...
Building dependency tree...
Reading state information...
The following additional packages will be installed:
  libbsd0 libedit2 libgdbm-compat4 libgdbm6 libjson-perl libllvm11 libmd0
  libperl5.34 libpq5 libxslt1.1 locales netbase percona-pg-stat-monitor14
  percona-postgresql-14 percona-postgresql-14-pgaudit
  percona-postgresql-14-repack percona-postgresql-14-wal2json
  percona-postgresql-client-14 percona-postgresql-common
  percona-postgresql-contrib perl perl-modules-5.34 postgresql-client-common
  postgresql-common ssl-cert tzdata ucf
Suggested packages:
  gdbm-l10n percona-postgresql-doc-14 perl-doc libterm-readline-gnu-perl
  | libterm-readline-perl-perl make libtap-harness-archive-perl
Recommended packages:
  libjson-xs-perl sysstat logrotate
The following NEW packages will be installed:
  libbsd0 libedit2 libgdbm-compat4 libgdbm6 libjson-perl libllvm11 libmd0
  libperl5.34 libpq5 libxslt1.1 locales netbase percona-pg-stat-monitor14
  percona-postgresql-14 percona-postgresql-14-pgaudit
  percona-postgresql-14-repack percona-postgresql-14-wal2json
  percona-postgresql-client-14 percona-postgresql-common
  percona-postgresql-contrib percona-ppg-server-14 perl perl-modules-5.34
  postgresql-client-common postgresql-common ssl-cert tzdata ucf
0 upgraded, 28 newly installed, 0 to remove and 0 not upgraded.
Need to get 59.3 MB of archives.
After this operation, 216 MB of additional disk space will be used.
Get:1 http://repo.percona.com/ppg-14/apt jammy/main amd64 postgresql-client-common all 1:241-6.jammy [33.5 kB]
Get:2 http://repo.percona.com/ppg-14/apt jammy/main amd64 postgresql-common all 1:241-6.jammy [188 kB]
Get:3 http://archive.ubuntu.com/ubuntu jammy-updates/main amd64 perl-modules-5.34 all 5.34.0-3ubuntu1.1 [2976 kB]
Get:4 http://repo.percona.com/ppg-14/apt jammy/main amd64 percona-postgresql-common all 1:241-6.jammy [5876 B]
Get:5 http://repo.percona.com/ppg-14/apt jammy/main amd64 libpq5 amd64 2:14.6-1.jammy [261 kB]
Get:6 http://repo.percona.com/ppg-14/apt jammy/main amd64 percona-postgresql-client-14 amd64 2:14.6-1.jammy [2724 kB]
Get:7 http://repo.percona.com/ppg-14/apt jammy/main amd64 percona-postgresql-14 amd64 2:14.6-1.jammy [23.0 MB]
Get:8 http://archive.ubuntu.com/ubuntu jammy/main amd64 libgdbm6 amd64 1.23-1 [33.9 kB]
Get:9 http://archive.ubuntu.com/ubuntu jammy/main amd64 libgdbm-compat4 amd64 1.23-1 [6606 B]
Get:10 http://archive.ubuntu.com/ubuntu jammy-updates/main amd64 libperl5.34 amd64 5.34.0-3ubuntu1.1 [4819 kB]
Get:11 http://archive.ubuntu.com/ubuntu jammy-updates/main amd64 perl amd64 5.34.0-3ubuntu1.1 [232 kB]
Get:12 http://archive.ubuntu.com/ubuntu jammy/main amd64 libjson-perl all 4.04000-1 [81.8 kB]
Get:13 http://archive.ubuntu.com/ubuntu jammy/main amd64 netbase all 6.3 [12.9 kB]
Get:14 http://archive.ubuntu.com/ubuntu jammy/main amd64 ssl-cert all 1.1.2 [17.4 kB]
Get:15 http://archive.ubuntu.com/ubuntu jammy/main amd64 ucf all 3.0043 [56.1 kB]
Get:16 http://archive.ubuntu.com/ubuntu jammy/main amd64 libmd0 amd64 1.0.4-1build1 [23.0 kB]
Get:17 http://archive.ubuntu.com/ubuntu jammy/main amd64 libbsd0 amd64 0.11.5-1 [44.8 kB]
Get:18 http://archive.ubuntu.com/ubuntu jammy-updates/main amd64 locales all 2.35-0ubuntu3.1 [4249 kB]
Get:19 http://archive.ubuntu.com/ubuntu jammy-updates/main amd64 tzdata all 2022g-0ubuntu0.22.04.1 [333 kB]
Get:20 http://archive.ubuntu.com/ubuntu jammy/main amd64 libedit2 amd64 3.1-20210910-1build1 [96.8 kB]
Get:21 http://archive.ubuntu.com/ubuntu jammy/universe amd64 libllvm11 amd64 1:11.1.0-6 [19.6 MB]
Get:22 http://archive.ubuntu.com/ubuntu jammy-updates/main amd64 libxslt1.1 amd64 1.1.34-4ubuntu0.22.04.1 [164 kB]
Get:23 http://repo.percona.com/ppg-14/apt jammy/main amd64 percona-pg-stat-monitor14 amd64 1:1.1.1-1.jammy [90.5 kB]
Get:24 http://repo.percona.com/ppg-14/apt jammy/main amd64 percona-postgresql-14-pgaudit amd64 1:1.6.2-4.jammy [55.4 kB]
Get:25 http://repo.percona.com/ppg-14/apt jammy/main amd64 percona-postgresql-14-repack amd64 1:1.4.8-1.jammy [115 kB]
Get:26 http://repo.percona.com/ppg-14/apt jammy/main amd64 percona-postgresql-14-wal2json amd64 1:2.5-2.jammy [72.1 kB]
Get:27 http://repo.percona.com/ppg-14/apt jammy/main amd64 percona-postgresql-contrib all 1:241-6.jammy [3376 B]
Get:28 http://repo.percona.com/ppg-14/apt jammy/main amd64 percona-ppg-server-14 amd64 1:14.6-1.jammy [2580 B]
debconf: delaying package configuration, since apt-utils is not installed
Fetched 59.3 MB in 2s (27.1 MB/s)
Selecting previously unselected package perl-modules-5.34.
(Reading database ... 9229 files and directories currently installed.)
Preparing to unpack .../00-perl-modules-5.34_5.34.0-3ubuntu1.1_all.deb ...
Unpacking perl-modules-5.34 (5.34.0-3ubuntu1.1) ...
Selecting previously unselected package libgdbm6:amd64.
Preparing to unpack .../01-libgdbm6_1.23-1_amd64.deb ...
Unpacking libgdbm6:amd64 (1.23-1) ...
Selecting previously unselected package libgdbm-compat4:amd64.
Preparing to unpack .../02-libgdbm-compat4_1.23-1_amd64.deb ...
Unpacking libgdbm-compat4:amd64 (1.23-1) ...
Selecting previously unselected package libperl5.34:amd64.
Preparing to unpack .../03-libperl5.34_5.34.0-3ubuntu1.1_amd64.deb ...
Unpacking libperl5.34:amd64 (5.34.0-3ubuntu1.1) ...
Selecting previously unselected package perl.
Preparing to unpack .../04-perl_5.34.0-3ubuntu1.1_amd64.deb ...
Unpacking perl (5.34.0-3ubuntu1.1) ...
Selecting previously unselected package libjson-perl.
Preparing to unpack .../05-libjson-perl_4.04000-1_all.deb ...
Unpacking libjson-perl (4.04000-1) ...
Selecting previously unselected package netbase.
Preparing to unpack .../06-netbase_6.3_all.deb ...
Unpacking netbase (6.3) ...
Selecting previously unselected package postgresql-client-common.
Preparing to unpack .../07-postgresql-client-common_1%3a241-6.jammy_all.deb ...
Unpacking postgresql-client-common (1:241-6.jammy) ...
Selecting previously unselected package ssl-cert.
Preparing to unpack .../08-ssl-cert_1.1.2_all.deb ...
Unpacking ssl-cert (1.1.2) ...
Selecting previously unselected package ucf.
Preparing to unpack .../09-ucf_3.0043_all.deb ...
Moving old data out of the way
Unpacking ucf (3.0043) ...
Selecting previously unselected package postgresql-common.
Preparing to unpack .../10-postgresql-common_1%3a241-6.jammy_all.deb ...
Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common'
Unpacking postgresql-common (1:241-6.jammy) ...
Setting up perl-modules-5.34 (5.34.0-3ubuntu1.1) ...
Setting up libgdbm6:amd64 (1.23-1) ...
Setting up libgdbm-compat4:amd64 (1.23-1) ...
Setting up libperl5.34:amd64 (5.34.0-3ubuntu1.1) ...
Setting up perl (5.34.0-3ubuntu1.1) ...
Setting up libjson-perl (4.04000-1) ...
Setting up netbase (6.3) ...
Setting up postgresql-client-common (1:241-6.jammy) ...
Setting up ssl-cert (1.1.2) ...
Setting up ucf (3.0043) ...
Setting up postgresql-common (1:241-6.jammy) ...
Adding user postgres to group ssl-cert

Creating config file /etc/postgresql-common/createcluster.conf with new version
Building PostgreSQL dictionaries from installed myspell/hunspell packages...
Removing obsolete dictionary files:
Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /lib/systemd/system/postgresql.service.
Selecting previously unselected package percona-postgresql-common.
(Reading database ... 11464 files and directories currently installed.)
Preparing to unpack .../00-percona-postgresql-common_1%3a241-6.jammy_all.deb ...
Unpacking percona-postgresql-common (1:241-6.jammy) ...
Selecting previously unselected package libmd0:amd64.
Preparing to unpack .../01-libmd0_1.0.4-1build1_amd64.deb ...
Unpacking libmd0:amd64 (1.0.4-1build1) ...
Selecting previously unselected package libbsd0:amd64.
Preparing to unpack .../02-libbsd0_0.11.5-1_amd64.deb ...
Unpacking libbsd0:amd64 (0.11.5-1) ...
Selecting previously unselected package locales.
Preparing to unpack .../03-locales_2.35-0ubuntu3.1_all.deb ...
Unpacking locales (2.35-0ubuntu3.1) ...
Selecting previously unselected package tzdata.
Preparing to unpack .../04-tzdata_2022g-0ubuntu0.22.04.1_all.deb ...
Unpacking tzdata (2022g-0ubuntu0.22.04.1) ...
Selecting previously unselected package libedit2:amd64.
Preparing to unpack .../05-libedit2_3.1-20210910-1build1_amd64.deb ...
Unpacking libedit2:amd64 (3.1-20210910-1build1) ...
Selecting previously unselected package libllvm11:amd64.
Preparing to unpack .../06-libllvm11_1%3a11.1.0-6_amd64.deb ...
Unpacking libllvm11:amd64 (1:11.1.0-6) ...
Selecting previously unselected package libpq5:amd64.
Preparing to unpack .../07-libpq5_2%3a14.6-1.jammy_amd64.deb ...
Unpacking libpq5:amd64 (2:14.6-1.jammy) ...
Selecting previously unselected package libxslt1.1:amd64.
Preparing to unpack .../08-libxslt1.1_1.1.34-4ubuntu0.22.04.1_amd64.deb ...
Unpacking libxslt1.1:amd64 (1.1.34-4ubuntu0.22.04.1) ...
Selecting previously unselected package percona-postgresql-client-14.
Preparing to unpack .../09-percona-postgresql-client-14_2%3a14.6-1.jammy_amd64.deb ...
Unpacking percona-postgresql-client-14 (2:14.6-1.jammy) ...
Selecting previously unselected package percona-postgresql-14.
Preparing to unpack .../10-percona-postgresql-14_2%3a14.6-1.jammy_amd64.deb ...
Unpacking percona-postgresql-14 (2:14.6-1.jammy) ...
Selecting previously unselected package percona-pg-stat-monitor14.
Preparing to unpack .../11-percona-pg-stat-monitor14_1%3a1.1.1-1.jammy_amd64.deb ...
Unpacking percona-pg-stat-monitor14 (1:1.1.1-1.jammy) ...
Selecting previously unselected package percona-postgresql-14-pgaudit.
Preparing to unpack .../12-percona-postgresql-14-pgaudit_1%3a1.6.2-4.jammy_amd64.deb ...
Unpacking percona-postgresql-14-pgaudit (1:1.6.2-4.jammy) ...
Selecting previously unselected package percona-postgresql-14-repack.
Preparing to unpack .../13-percona-postgresql-14-repack_1%3a1.4.8-1.jammy_amd64.deb ...
Unpacking percona-postgresql-14-repack (1:1.4.8-1.jammy) ...
Selecting previously unselected package percona-postgresql-14-wal2json.
Preparing to unpack .../14-percona-postgresql-14-wal2json_1%3a2.5-2.jammy_amd64.deb ...
Unpacking percona-postgresql-14-wal2json (1:2.5-2.jammy) ...
Selecting previously unselected package percona-postgresql-contrib.
Preparing to unpack .../15-percona-postgresql-contrib_1%3a241-6.jammy_all.deb ...
Unpacking percona-postgresql-contrib (1:241-6.jammy) ...
Selecting previously unselected package percona-ppg-server-14.
Preparing to unpack .../16-percona-ppg-server-14_1%3a14.6-1.jammy_amd64.deb ...
Unpacking percona-ppg-server-14 (1:14.6-1.jammy) ...
Setting up libpq5:amd64 (2:14.6-1.jammy) ...
Setting up locales (2.35-0ubuntu3.1) ...
Generating locales (this might take a while)...
Generation complete.
Setting up tzdata (2022g-0ubuntu0.22.04.1) ...

Current default time zone: 'Etc/UTC'
Local time is now:      Mon Jan 23 14:40:39 UTC 2023.
Universal Time is now:  Mon Jan 23 14:40:39 UTC 2023.
Run 'dpkg-reconfigure tzdata' if you wish to change it.

Setting up percona-postgresql-common (1:241-6.jammy) ...
Setting up percona-postgresql-client-14 (2:14.6-1.jammy) ...
update-alternatives: using /usr/share/postgresql/14/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode
Setting up libmd0:amd64 (1.0.4-1build1) ...
Setting up libxslt1.1:amd64 (1.1.34-4ubuntu0.22.04.1) ...
Setting up libbsd0:amd64 (0.11.5-1) ...
Setting up libedit2:amd64 (3.1-20210910-1build1) ...
Setting up libllvm11:amd64 (1:11.1.0-6) ...
Setting up percona-postgresql-14 (2:14.6-1.jammy) ...
Creating new PostgreSQL cluster 14/main ...
/usr/lib/postgresql/14/bin/initdb -D /var/lib/postgresql/14/main --auth-local peer --auth-host scram-sha-256 --no-instructions
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale "C.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

fixing permissions on existing directory /var/lib/postgresql/14/main ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
invoke-rc.d: could not determine current runlevel
invoke-rc.d: policy-rc.d denied execution of start.
Setting up percona-pg-stat-monitor14 (1:1.1.1-1.jammy) ...
Setting up percona-postgresql-14-wal2json (1:2.5-2.jammy) ...
Setting up percona-postgresql-14-pgaudit (1:1.6.2-4.jammy) ...
Setting up percona-postgresql-14-repack (1:1.4.8-1.jammy) ...
update-alternatives: using /usr/lib/postgresql/14/bin/pg_repack to provide /usr/bin/pg_repack (pg_repack) in auto mode
Setting up percona-postgresql-contrib (1:241-6.jammy) ...
Setting up percona-ppg-server-14 (1:14.6-1.jammy) ...
Processing triggers for postgresql-common (1:241-6.jammy) ...
Building PostgreSQL dictionaries from installed myspell/hunspell packages...
Removing obsolete dictionary files:
Processing triggers for libc-bin (2.35-0ubuntu3.1) ...
Removing intermediate container ef7c5572dcd6
 ---> 04d530bf29e5
Step 5/9 : USER postgres
 ---> Running in 4380bcb788e0
Removing intermediate container 4380bcb788e0
 ---> a46b9ac0d7b5
Step 6/9 : RUN /etc/init.d/postgresql start     && psql --command "ALTER USER postgres PASSWORD 'postgres';"     && psql --command "CREATE DATABASE hireme;"     && psql --command "ALTER USER postgres SET timezone='GMT';"     && echo "host all  all    0.0.0.0/0  md5" >> /etc/postgresql/14/main/pg_hba.conf     && echo "listen_addresses='*'" >> /etc/postgresql/14/main/postgresql.conf
 ---> Running in 1047360c0be8
 * Starting PostgreSQL 14 database server
   ...done.
ALTER ROLE
CREATE DATABASE
ALTER ROLE
Removing intermediate container 1047360c0be8
 ---> 63177df7bcea
Step 7/9 : EXPOSE 5432
 ---> Running in c3207d08d03a
Removing intermediate container c3207d08d03a
 ---> b36708950491
Step 8/9 : VOLUME [     "/etc/postgresql",     "/var/log/postgresql",     "/var/lib/postgresql" ]
 ---> Running in 2fe4c3029069
Removing intermediate container 2fe4c3029069
 ---> c55fdebf1b00
Step 9/9 : CMD [     "/usr/lib/postgresql/14/bin/postgres",     "-D", "/var/lib/postgresql/14/main",     "-c", "config_file=/etc/postgresql/14/main/postgresql.conf" ]
 ---> Running in be65af97509b
Removing intermediate container be65af97509b
 ---> 3a280e526a08
Successfully built 3a280e526a08
Successfully tagged pg-14-test:latest
Mon Jan 23 14:40:52 UTC 2023
[root@alex-psmdb tmp]#

And as a result of image creation I got:

[root@alex-psmdb tmp]# docker run pg-14-test:latest sh -c "usr/lib/postgresql/14/bin/postgres --version"
postgres (PostgreSQL) 14.6 - Percona Distribution (Ubuntu 2:14.6-1.jammy)

Don’t you have any firewalls or filters that can prevent packages from being downloaded?
Could you please check if you can access Percona Repo and download packages manually?

I’m running docker from a M1 Apple machine. Do you think that could be a problem?

Hi @olegario96
Yes, this is the main reason for the issue you have.
For now, we have support for x86_64 architecture, and adding aarch64 support is in progress right now, but there is no exact ETA for it at this time.
Once we have a complete aarch64 support this will be announced via a blog post and on this forum.

There is a apt(-get) update needed after the percona-release setup before the apt-get install… (well, at least with enable - not sure how setup differs)

(the architecture might be an issue as well though)

Edit: it seems like the enable_alias function called by percona-release setup does run apt-get update, unlike percona-release enable.

1 Like