src/test/regress/sql/hs_standby_functions.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

--
-- Hot Standby tests
--
-- hs_standby_functions.sql
--

-- should fail
select pg_current_xact_id();

select length(pg_current_snapshot()::text) >= 4;

select pg_start_backup('should fail');
select pg_switch_wal();
select pg_stop_backup();

-- should return no rows
select * from pg_prepared_xacts;

-- just the startup process
select locktype, virtualxid, virtualtransaction, mode, granted
from pg_locks where virtualxid = '1/1';

-- suicide is painless
select pg_cancel_backend(pg_backend_pid());