After you have defined a server, you can run any copy, synchronization request from PostgreSQL as a source to a target.
Note: For PostgreSQL on-prem, You need to set
ALTER SYSTEM SET wal_level to logical otherwise metabase creation will fail. By default, the variable is replica. Also, set the number of max replication slots in the postgresql.conf. PostgreSQL service needs to be restarted to save the changes.- Right-click the server and select Install Source Metabase in the menu that displays.
- Enter a user ID and password with administrative privileges and click OK.
- Specify the password for the replication user (the owner of the database which contains the metabase objects), then click OK.The Install Source Metabase dialog opens with actions that will be performed.
- To complete the operation of installing PostgreSQL as a source, see the above steps 5-7 in Install Target Only Metabase.
PostgreSQL AWS
- Go to Parameter groups and create a new parameter group.
- Choose the Db paramter family as Postgres13(preferred) and keep the type as it is.
- Edit the parameter rds.logical_replication to 1 and Save changes.
- Go to the Rds db instance and select and modify that db instance.
- Go to the parameter groups section and change it to the newly created one.
- Need to reboot the database instance.