fdb=> alter table test_log set logged; ALTER TABLE fdb=> select relname,relpersistence from pg_class where relname='test_log'; relname | relpersistence ----------+---------------- test_log | p (1 row)
备库操作: 查询成功
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
[pg95@db1 ~]$ psql fdb fdb psql (9.5alpha1) Type "help"for help. fdb=> select pg_is_in_recovery(); pg_is_in_recovery ------------------- t (1 row) fdb=> select count(*) from test_log; count ------- 1000 (1 row)