Skip to content

Instantly share code, notes, and snippets.

@dsouzajude

dsouzajude/create-db-replication-user.sql

Created October 21, 2022 15:51
Show Gist options
  • Save dsouzajude/289b1b5f274dacac851f9c627779958f to your computer and use it in GitHub Desktop.
Save dsouzajude/289b1b5f274dacac851f9c627779958f to your computer and use it in GitHub Desktop.
Download ZIP
Create a database replication user
Raw
create-db-replication-user.sql
-- Create replication user
CREATE USER rep_user WITH replication PASSWORD <PASSWORD>;
-- Grant SELECT and USAGE
GRANT SELECT ON ALL TABLES IN SCHEMA <SCHEMA> TO rep_user;
GRANT USAGE ON SCHEMA <SCHEMA> TO rep_user;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment