1-- 2-- Hot Standby tests 3-- 4-- hs_standby_functions.sql 5-- 6 7-- should fail 8select pg_current_xact_id(); 9 10select length(pg_current_snapshot()::text) >= 4; 11 12select pg_start_backup('should fail'); 13select pg_switch_wal(); 14select pg_stop_backup(); 15 16-- should return no rows 17select * from pg_prepared_xacts; 18 19-- just the startup process 20select locktype, virtualxid, virtualtransaction, mode, granted 21from pg_locks where virtualxid = '1/1'; 22 23-- suicide is painless 24select pg_cancel_backend(pg_backend_pid()); 25