blob: 83403299fd5e04d9fe9d7dbedb0743fc6463be49 [file] [log] [blame]
--
-- Hot Standby tests
--
-- hs_primary_setup.sql
--
drop table if exists hs1;
create table hs1 (col1 integer primary key);
insert into hs1 values (1);
drop table if exists hs2;
create table hs2 (col1 integer primary key);
insert into hs2 values (12);
insert into hs2 values (13);
drop table if exists hs3;
create table hs3 (col1 integer primary key);
insert into hs3 values (113);
insert into hs3 values (114);
insert into hs3 values (115);
DROP sequence if exists hsseq;
create sequence hsseq;
-- start_ignore
SELECT pg_switch_wal();
-- GPDB: enable hot_standby for this cluster
\! gpconfig -c hot_standby -v on;
\! gpstop -ari;
-- end_ignore