On Fri, May 12, 2023 at 5:25 PM Ajin Cherian <itsa...@gmail.com> wrote: > > On Fri, May 12, 2023 at 1:49 PM Amit Kapila <amit.kapil...@gmail.com> wrote: > > > > I tried the following test: > > ==================== > Repeat On the publisher and subscriber: > /* Create role regress_alice with NOSUPERUSER on > publisher and subscriber and a table for replication */ > > CREATE ROLE regress_alice NOSUPERUSER LOGIN; > CREATE ROLE regress_admin SUPERUSER LOGIN; > GRANT CREATE ON DATABASE postgres TO regress_alice; > SET SESSION AUTHORIZATION regress_alice; > CREATE SCHEMA alice; > GRANT USAGE ON SCHEMA alice TO regress_admin; > CREATE TABLE alice.test (i INTEGER); > ALTER TABLE alice.test REPLICA IDENTITY FULL; >
Why do we need a schema and following grant statement for this test? > On the publisher: > postgres=> insert into alice.test values(1); > postgres=> insert into alice.test values(2); > postgres=> insert into alice.test values(3); > postgres=> CREATE PUBLICATION alice FOR TABLE alice.test > WITH (publish_via_partition_root = true); > Again, 'publish_via_partition_root' doesn't seem to be required. Let's try to write a minimal test for the initial sync behaviour. -- With Regards, Amit Kapila.