log repl exercise monitor setup

agora inbox for pgsql-admin@postgresql.org  
help / color / mirror / Atom feed

From: Wim Bertels <wim.bertels@ucll.be>
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: log repl exercise monitor setup
Date: Mon, 10 Mar 2025 12:49:38 +0000
Message-ID: <7c760edb024dc59e92c7c624ae5e00052c8becde.camel@ucll.be> (raw)

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

view thread (2+ messages)  latest in thread

Message-ID: <7c760edb024dc59e92c7c624ae5e00052c8becde.camel@ucll.be>
Permalink:  ../7c760edb024dc59e92c7c624ae5e00052c8becde.camel@ucll.be/
Also on:    postgresql.org/message-id/7c760edb024dc59e92c7c624ae5e00052c8becde.camel@ucll.be

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: wim.bertels@ucll.be, pgsql-admin@lists.postgresql.org
  Subject: Re: log repl exercise monitor setup
  In-Reply-To: <7c760edb024dc59e92c7c624ae5e00052c8becde.camel@ucll.be>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox