​
Required settings

  • Host name
  • Port (default is 5432)
  • Service account

​
Creating a service account

Please make sure you create a service account that has the ability to create on the database and is the owner of all the schemas you plan to sync into.
-- Create a service account
CREATE USER artie WITH PASSWORD 'password';

-- Grant create on database to the service account, so we can handle creating the necessary schemas.
GRANT CREATE ON DATABASE your_database TO artie;

-- If the schema exists, change the owner to the service account.
-- This is because there are certain DDL operations such as "ALTER TABLE" or "DROP TABLE" that is restricted to the owner.
ALTER SCHEMA schema_name OWNER TO artie;