log repl exercise monitor setup

From: Wim Bertels <wim(dot)bertels(at)ucll(dot)be>
To: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: log repl exercise monitor setup
Date: 2025-03-10 12:49:38
Message-ID: 7c760edb024dc59e92c7c624ae5e00052c8becde.camel@ucll.be
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

i would like to setup a mass test environment for 250+ students

for example a setup with two clusters that we manage: cluster PUB and
cluster SUB

goal: on cluster PUB each student has its own database
mirrored/replicated to his own database at cluster SUB

starting point:
* the databases on cluster PUB already exist with content
* the empty databases on cluster SUB already exist (without any
content)
* no publication (and thus subscription is already running)

so the exercise for each student would be:
1. create publication
2. mirror the structure (backup/restore)
3. create subscription
4. test replication (with dml: insert/..)

So what would be your suggestion to setup an easy monitoring setup to
check that the student succeeded in this exercise

background: vanilla debian with postgres apt repository, preferable
with software from these repositories for security and maintenance
reasons

(at the moment i check with some handmade scripts that query the
cluster and the logs)

mvg,
Wim

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Achilleas Mantzios - cloud 2025-03-10 13:35:54 Re: log repl exercise monitor setup
Previous Message Achilleas Mantzios - cloud 2025-03-10 10:56:27 Re: People obsessed with docker - how can I help?