Docker

You can run [pgmoneta][pgmoneta] using Docker instead of compiling it manually.

Prerequisites

• [Docker][docker] or [Podman][podman] must be installed on the server where PostgreSQL is running.
• Ensure PostgreSQL is configured to allow external connections.

The image

Enable External PostgreSQL Access

Modify the local PostgreSQL server's postgresql.conf file to allow connections from outside:

listen_addresses = '*'

Update pg_hba.conf to allow remote connections:

host    all    all    0.0.0.0/0    scram-sha-256

Then, restart PostgreSQL for the changes to take effect:

sudo systemctl restart postgresql

Clone the Repository

git clone https://github.com/pgmoneta/pgmoneta.git
cd pgmoneta

Build the Docker Image

There are two Dockerfiles available:

1. Alpine-based image

Using Docker

docker build -t pgmoneta:latest -f ./contrib/docker/Dockerfile.alpine .

Using Podman

podman build -t pgmoneta:latest -f ./contrib/docker/Dockerfile.alpine .

Rocky Linux 9-based image

Using Docker

docker build -t pgmoneta:latest -f ./contrib/docker/Dockerfile.rocky9 .

Using Podman

podman build -t pgmoneta:latest -f ./contrib/docker/Dockerfile.rocky9 .

Run pgmoneta as a Docker Container

Once the image is built, run the container using:

Using Docker

docker run -d --name pgmoneta --network host pgmoneta:latest

Using Podman

podman run -d --name pgmoneta --network host pgmoneta:latest

Verify the Container

Check if the container is running:

Using Docker

docker ps | grep pgmoneta

Using Podman

podman ps | grep pgmoneta

Check logs for any errors:

Using Docker

docker logs pgmoneta

Using Podman

podman logs pgmoneta

You can also inspect the exposed metrics at:

http://localhost:5001/metrics

You can stop the container using

Using Docker

docker stop pgmoneta

Using Podman

podman stop pgmoneta

You can exec into the container and run the cli commands as

docker exec -it pgmoneta /bin/bash
#or using podman
podman exec -it pgmoneta /bin/bash

cd /etc/pgmoneta
/usr/local/bin/pgmoneta-cli -c pgmoneta.conf shutdown

You can access the three binaries at /usr/local/bin