Задание 4: Изменение настроек кластера
Получение настроек кластера
Получите текущие настройки кластера:
[postgres@srv1 ~]$ pangolin-manager-ctl -c /etc/pangolin-manager/postgres.yml show-config $CLNAME
loop_wait: 10
maximum_lag_on_failover: 1048576
postgresql:
parameters:
auth_activity_period: '60'
authentication_max_workers: '16'
logical_decoding_work_mem: 64MB
max_connections: 111
max_locks_per_transaction: '64'
max_prepared_transactions: '3'
max_replication_slots: '10'
max_wal_senders: '10'
max_worker_processes: '32'
track_commit_timestamp: false
wal_keep_size: 8GB
wal_level: replica
wal_log_hints: true
use_pg_rewind: true
use_slots: true
retry_timeout: 60
synchronous_mode: true
synchronous_mode_strict: false
ttl: 135
Используя псевдоним pgconfig сделайте то же самое:
[postgres@srv1 ~]$ pgconfig
{
"ttl": 135,
"retry_timeout": 60,
"loop_wait": 10,
"maximum_lag_on_failover": 1048576,
"synchronous_mode": true,
"synchronous_mode_strict": false,
"postgresql": {
"parameters": {
"max_connections": 111,
"max_locks_per_transaction": "64",
"max_worker_processes": "32",
"max_prepared_transactions": "3",
"wal_level": "replica",
"wal_log_hints": true,
"track_commit_timestamp": false,
"wal_keep_size": "8GB",
"max_wal_senders": "10",
"max_replication_slots": "10",
"logical_decoding_work_mem": "64MB",
"auth_activity_period": "60",
"authentication_max_workers": "16"
},
"use_pg_rewind": true,
"use_slots": true
}
}
Изменение настроек кластера
Измените настройку max_wal_sebders:
[postgres@srv1 ~]$ pangolin-manager-ctl -c /etc/pangolin-manager/postgres.yml edit-config $CLNAME --pg max_wal_senders="12" --force
---
+++
@@ -8,7 +8,7 @@
max_connections: '110'
max_prepared_transactions: '6'
max_replication_slots: '10'
- max_wal_senders: '10'
+ max_wal_senders: 12
max_worker_processes: '32'
track_commit_timestamp: false
wal_keep_size: 8GB
Configuration changed
Перезагрузите узлы кластера:
[postgres@srv1 ~]$ pangolin-manager-ctl -c /etc/pangolin-manager/postgres.yml restart $CLNAME
+ Cluster: Pobeda (7683495148262105741) ------------+-----------+----+-----------+-----------------+
| Member | Host | Role | State | TL | Lag in MB | Pending restart |
+---------------+--------------------+--------------+-----------+----+-----------+-----------------+
| <IP-Address1> | <IP-Address1>:5433 | Leader | running | 6 | | * |
| <IP-Address2> | <IP-Address2>:5433 | Sync Standby | streaming | 6 | 0 | * |
+---------------+--------------------+--------------+-----------+----+-----------+-----------------+
When should the restart take place (e.g. 2026-09-09T13:23) [now]:
Are you sure you want to restart members <IP-Address2>, <IP-Address1>? [y/N]: y
Restart if the PostgreSQL version is less than provided (e.g. 9.5.2) []:
Success: restart on member <IP-Address2>
Success: restart on member <IP-Address1>
Проверьте результат:
[postgres@srv1 ~]$ psql
psql (15.5)
Введите "help", чтобы получить справку.
postgres=# \dconfig max_wal_senders
Список параметров конфигурации
Параметр | Значение
-----------------+----------
max_wal_senders | 12
(1 строка)
postgres=# \q
[postgres@srv1 ~]$ exit