log repl exercise monitor setup
От | Wim Bertels |
---|---|
Тема | log repl exercise monitor setup |
Дата | |
Msg-id | 7c760edb024dc59e92c7c624ae5e00052c8becde.camel@ucll.be обсуждение исходный текст |
Ответы |
Re: log repl exercise monitor setup
|
Список | 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
В списке pgsql-admin по дате отправления: