PostgreSQL Connector

-- Create the user
CREATE USER zwiron WITH PASSWORD 'your_password';

-- Grant access to your schema
GRANT USAGE ON SCHEMA public TO zwiron;

-- Grant read access to all existing tables
GRANT SELECT ON ALL TABLES IN SCHEMA public TO zwiron;

-- Grant read access to future tables
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO zwiron;

CREATE USER zwiron WITH PASSWORD 'your_password';

GRANT USAGE, CREATE ON SCHEMA public TO zwiron;
GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO zwiron;
ALTER DEFAULT PRIVILEGES IN SCHEMA public
  GRANT SELECT, INSERT, UPDATE, DELETE ON TABLES TO zwiron;

-- Must have REPLICATION attribute
ALTER USER zwiron WITH REPLICATION;

-- Create a publication for the tables you want to replicate
CREATE PUBLICATION zwiron_pub FOR ALL TABLES;
-- Or for specific tables:
-- CREATE PUBLICATION zwiron_pub FOR TABLE orders, customers;

wal_level = logical
max_replication_slots = 5
max_wal_senders = 10

SHOW wal_level;  -- should return "logical"

SELECT pg_create_logical_replication_slot('zwiron_slot', 'pgoutput');

GRANT rds_replication TO zwiron;

ALTER USER zwiron WITH REPLICATION;