Skip to main content

StreamShift Documentation

PostgreSQL setup

Source setup

If the source and target are both PostgreSQL and you are doing a "Lift and Shift only" migration, create a user for use by Striim and grant it SELECT privileges on all tables to be migrated.

In all other cases, set up the source as described in PosgreSQL setup.

Target setup

  1. If you are migrating only one schema and plan to use the default public schema, skip this step. Otherwise, create the target schema(s).

  2. Create a CHKPOINT table in one of the target schemas:

    create table chkpoint (
  id character varying(100) primary key,
  sourceposition bytea,
  pendingddl numeric(1), 
  ddl text);

  3. Create a role for use by Striim as follows, replacing ******** with a strong password. You may use any role name you wish.

    CREATE ROLE striim WITH LOGIN PASSWORD '******';
GRANT CONNECT ON DATABASE <database name> TO striim;
GRANT CREATE ON DATABASE <database name> TO striim;
In this section: