
Values on all segments are consistent
2
GUC : log_rotation_age
3
Master value: 1d
4
Segment value: 1d
5
[gpadmin@master ~]$ gpconfig -s log_rotation_size
1
Values on all segments are consistent
2
GUC : log_rotation_size
3
Master value: 30MB
4
Segment value: 1GB
5
[gpadmin@master ~]$ gpconfig -c log_rotation_size -v 0
6
20240130:11:13:11:014128 gpconfig:master:gpadmin-[INFO]:-completed successfully with
parameters '-c log_rotation_size -v 0'
7
记录执行5秒及以上的语句,跟踪慢查询语句,单位为毫秒。
[gpadmin@master ~]$ gpconfig -s log_min_duration_statement
1
Values on all segments are consistent
2
GUC : log_min_duration_statement
3
Master value: 5s
4
Segment value: 5s
5
[gpadmin@master ~]$ gpconfig -c log_min_duration_statement -v 5000
6
20240130:11:14:09:014525 gpconfig:master:gpadmin-[INFO]:-completed successfully with
parameters '-c log_min_duration_statement -v 5000'
7
日志名称,以周几为单位
删除log_filename 参数
[gpadmin@master gpconfigs]$ gpssh -f hostlist
1
=> sed -i '/log_filename/d' /u05/data/*/*/postgresql.conf
2
[segment2]
3
[segment3]
4
[segment4]
5
[ master]
6
文档被以下合辑收录
评论