pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

log repl exercise monitor setup
2+ messages / 2 participants
[nested] [flat]

* log repl exercise monitor setup
@ 2025-03-10 12:49  Wim Bertels <wim.bertels@ucll.be>
  0 siblings, 1 reply; 2+ messages in thread

From: Wim Bertels @ 2025-03-10 12:49 UTC (permalink / raw)
  To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>

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


^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: log repl exercise monitor setup
@ 2025-03-10 13:35  Achilleas Mantzios - cloud <a.mantzios@cloud.gatewaynet.com>
  parent: Wim Bertels <wim.bertels@ucll.be>
  0 siblings, 0 replies; 2+ messages in thread

From: Achilleas Mantzios - cloud @ 2025-03-10 13:35 UTC (permalink / raw)
  To: pgsql-admin@lists.postgresql.org


On 3/10/25 14:49, Wim Bertels wrote:
> 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/..)
Sounds like fun project! My daughter studying in 
https://www.ece.tuc.gr/en/home also had access to a automated personal 
PostgreSQL DB while she was attending the DB course. They only learned 
SQL tho, no admin stuff, it is cool that you guys are teaching this.
> So what would be your suggestion to setup an easy monitoring setup to
> check that the student succeeded in this exercise
I'd create custom scripts with count(*) from all tables, sorted by table 
name and verifying those two match and that the #lines match the 
expected number of tables.
>
> 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





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2025-03-10 13:35 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-03-10 12:49 log repl exercise monitor setup Wim Bertels <wim.bertels@ucll.be>
2025-03-10 13:35 ` Achilleas Mantzios - cloud <a.mantzios@cloud.gatewaynet.com>

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