postgresql 开启归档

mkdir -p /var/lib/pgsql/13/archive

chown -R postgres.postgres /var/lib/pgsql/13/archive

cat >> postgresql.conf <<"EOF"

wal_level='replica'

archive_mode='on'

archive_command='test ! -f /var/lib/pgsql/13/archive/%f && cp %p /var/lib/pgsql/13/archive/%f'

restore_command='cp /var/lib/pgsql/13/archive/%f %p'

max_wal_senders=10

wal_keep_size=256

wal_sender_timeout=60s

EOF

pg_ctl  stop
pg_ctl  start

查看归档配置信息：

postgres=# select * from pg_settings where name in ('wal_level','archive_mode','archive_command');

查看归档信息：

postgres=# select * from pg_stat_get_archiver();

切换归档：

postgres=# select pg_switch_wal();