检查pgsql 日志复制级别

发布时间 2023-03-22 21:13:43作者: 一贴灵

修改完postgresql.conf文件,需要重启数据库,再执行以下语句验证下是否生效;

 

 select name,setting from pg_settings where name='wal_level';
select name,setting from pg_settings where name='max_replication_slots';
select name,setting from pg_settings where name='max_wal_senders';