Percona Monitoring PostgreSQL

Percona Monitoring PostgreSQL

mkdir /data/pmm3

wget https://downloads.percona.com/downloads/pmm3/3.1.0/docker/pmm-server-3.1.0.docker?_gl=1er2wxi_gcl_au*NzE2MzE4ODQuMTc0ODQyNjQyNg..

mv pmm-server-3.1.0.docker

docker load < pmm-server-3.1.0.docker
docker volume create pmm-data

docker run --detach --restart always \
--publish 443:8443 \
--env PMM_WATCHTOWER_HOST=your_watchtower_host \
--env PMM_WATCHTOWER_TOKEN=your_watchtower_token \
--volume pmm-data:/data/pmm3 \
--network=pmm-network \
--name pmm-server \
percona/pmm-server:3.1.0

wget https://downloads.percona.com/downloads/pmm3/3.1.0/binary/redhat/8/x86_64/pmm-client-3.1.0-7.el8.x86_64.rpm?_gl=110e98tt_gcl_au*NzE2MzE4ODQuMTc0ODQyNjQyNg..

mv pmm-client-3.1.0-7.el8.x86_64.rpm

rpm -ivh pmm-client-3.1.0-7.el8.x86_64.rpm

pmm-admin config --server-insecure-tls --server-url=https://admin:admin@10.0.0.62:443

dnf install -y pg_stat_monitor_15

They will be made in PostgreSQL

CREATE USER pmm WITH SUPERUSER ENCRYPTED PASSWORD '';

local all pmm md5

shared_preload_libraries = 'pg_stat_monitor'
pg_stat_monitor.pgsm_query_max_len = 2048

CREATE EXTENSION pg_stat_monitor;

sudo pmm-admin add postgresql --username=pmm --password=password
PostgreSQL Service added.
Service ID : ffd2966c-589f-4b93-a913-356a6b40603e
Service name: nubesbilisim-96924-postgresql

For more details, visit Percona PMM Documentation.

Also read: Vector Search with AI in PostgreSQL

Bir yanıt yazın

E-posta adresiniz yayınlanmayacak. Gerekli alanlar * ile işaretlenmişlerdir

Back To Top