postgresql开启archive模式
vi /var/lib/pgsql/{version}/data/postgresql.conf
//设置
wal_level = archive
archive_mode = on
archive_command = ''
//查看状态:
select * FROM pg_settings WHERE name LIKE 'wal_level' OR name LIKE 'archive%'
vi /var/lib/pgsql/{version}/data/postgresql.conf
//设置
wal_level = archive
archive_mode = on
archive_command = ''
//查看状态:
select * FROM pg_settings WHERE name LIKE 'wal_level' OR name LIKE 'archive%'