Description:
How to install percona repostories on amazon linux 2023 for taking backup of full config and shard servers
Steps to Reproduce:
[Step-by-step instructions on how to reproduce the issue, including any specific settings or configurations]
Version:
[Insert the version number of the software]
Logs:
[If applicable, include any relevant log files or error messages]
Expected Result:
[What the user expected to see or happen before the issue occurred]
Actual Result:
[What actually happened when the user encountered the issue]
Additional Information:
[Include any additional information that could be helpful to diagnose the issue, such as browser or device information]
Hi @Anikessh
Installing Percona software via the system’s corresponding package manager is recommended.
yum install -y https://repo.percona.com/yum/percona-release-latest.noarch.rpm
Hello Anikessh,
Unfortunately, while Percona postgres is supported on various linux flavours of Debian and Redhat derivatives, Amazon Linux 2023 is not one of them as it is a hybrid of redhat/centos/fedora.
However, that being said you CAN install our tarball which does have everything you need and will work on Amazon Linux 2023
Beware, there are caveats that you should read about first. The openssl version for instance is something to keep in mind.
In addition to reading the aforementioned documentation you can install the tarball distribution in the following manner on Amazon Linux 2023.
dnf install -y net-tools less wget acl readline-devel passwd openssl tar
useradd postgres -m
passwd postgres
mkdir -p /opt/pgdistro/
chown postgres:postgres /opt/pgdistro/
wget https://downloads.percona.com/downloads/postgresql-distribution-17/17.7/binary/tarball/percona-postgresql-17.7-ssl3-linux-x86_64.tar.gz
tar -xvf percona-postgresql-17.7-ssl3-linux-x86_64.tar.gz -C /opt/pgdistro/
mkdir -p /usr/local/pgsql/data
chown postgres:postgres /usr/local/pgsql/data
sudo as postgres and execute the following:
/opt/pgdistro/percona-postgresql17/bin/initdb -D /usr/local/pgsql/data
/opt/pgdistro/percona-postgresql17/bin/pg_ctl -D /usr/local/pgsql/data -l logfile start
export PATH=:/opt/pgdistro/percona-haproxy/sbin/:/opt/pgdistro/percona-patroni/bin/:/opt/pgdistro/percona-pgbackrest/bin/:/opt/pgdistro/percona-pgbadger/:/opt/pgdistro/percona-pgbouncer/bin/:/opt/pgdistro/percona-pgpool-II/bin/:/opt/pgdistro/percona-postgresql17/bin/:/opt/pgdistro/percona-etcd/bin/:/opt/percona-perl/bin/:/opt/percona-tcl/bin/:/opt/percona-python3/bin/:$PATH
export PAGER=less
Finally, test
psql --version
regards
Robert
