Striim 3.9.7 documentation

In striim/native/wal2json, find the directory for the operating system of your PostgreSQL host, and copy the file it contains to PostgreSQL's lib directory. If there is no director for your operating system, Contact Striim support.

In Windows, to find the location of the lib directory, open a command prompt, navigate to PostgreSQL's bin directory, and enter the following command:

pg_config --pkglibdir

Edit postgressql.conf, set the following options, and save the file. The values for max_replication_slots and max_wal_senders may be higher but there must be one of each available for each instance of PostgreSQLReader. max_wal_senders cannot exceed the value of max_connections.

wal_level = logical
max_replication_slots = 1
max_wal_senders = 1

Edit pg_hba.conf and add the following record, replacing <IP address> with the Striim server's IP address. If you have a multi-node cluster, add a record for each server that will run PostgreSQLReader. Then save the file and restart PostgreSQL.

local  replication  striim  <IP address>/0  trust

Restart PostgreSQL.

Enter the following command to create the replication slot:

pg_recvlogical -d mydb --slot striim_slot --create-slot -P wal2json

If you plan to use multiple instances of PostgreSQLReader, create a separate slot for each.

Create a role with the REPLICATION attribute for use by PostgreSQLReader and give it select permission on the schema(s) containing the tables to be read. Replace ****** with a strong password and myschema with the name of your schema.

CREATE ROLE striim WITH LOGIN PASSWORD '******' REPLICATION;
GRANT rds_replication TO striim;
GRANT SELECT ON ALL TABLES IN SCHEMA myschema TO striim;

Go to your RDS dashboard, select Parameter groups > Create parameter group, enter posstgres-logical-decoding as the Group name and Description, then click Create.

Click postgres-logical-decoding.

Enter logical_ in the Parameters field to filter the list, set rds.logical_replication to 1, and click Save changes.

In the left column, click Databases, then click the name of your database, click Modify, scroll down to Database options, change DB parameter group to postgres-logical-decoding, then scroll down to the bottom and click Continue.

Select Apply immediately > Modify DB instance.

Reboot the instance.

Restart PostgreSQL.

In PSQL, enter the following command to create the replication slot:

SELECT pg_create_logical_replication_slot('striim_slot', 'wal2json');

Create a role with the REPLICATION attribute for use by PostgreSQLReader and give it select permission on the schema(s) containing the tables to be read. Replace ****** with a strong password and myschema with the name of your schema.

CREATE ROLE striim WITH LOGIN PASSWORD '******';
GRANT rds_replication TO striim;
GRANT SELECT ON ALL TABLES IN SCHEMA myschema TO striim;