PostgreSQL as Target

PostgreSQL is a fully supported migration target. MigratorXpress creates the target schema automatically and streams data via FastTransfer.

For the complete connection reference, authentication modes, and troubleshooting, see the canonical PostgreSQL page.

Target-specific Permissions

-- Grant write access to the migration user
GRANT CREATE ON DATABASE target_db TO migratorxpress_user;
GRANT ALL PRIVILEGES ON SCHEMA public TO migratorxpress_user;

-- If using a custom target schema:
CREATE SCHEMA IF NOT EXISTS target_schema;
GRANT ALL PRIVILEGES ON SCHEMA target_schema TO migratorxpress_user;

Example Auth Entry

{
  "postgres_target": {
    "ds_type": "postgres",
    "auth_mode": "classic",
    "info": {
      "username": "$env{PG_USER}",
      "password": "$env{PG_PASSWORD}",
      "server": "pg-target.company.com",
      "port": 5432,
      "database": "target_db"
    }
  }
}

Reference it on the command line with --target_db_auth_id postgres_target.

See Also

• PostgreSQL -- full connection reference
• Database Connections -- auth file format and security