CREATE ROLE rep REPLICATION LOGIN PASSWORD 'Password';

CREATE TABLE article(id int);
GRANT ALL ON article TO rep;

-- Populate the table with thousands of rows, so that the sync on secondary
-- will take some time.
INSERT INTO article select generate_series(1, 50000000, 1);

CREATE PUBLICATION mypub FOR TABLE article;

-- Create another publication for a second table
CREATE TABLE article_2(id int);
GRANT ALL ON article_2 TO rep;
CREATE PUBLICATION mypub_2 FOR TABLE article_2;

\dRp+

