Skip to main content

Import from PostgreSQL

Use a PostgreSQL import job to load existing PostgreSQL data into VeloDB Cloud and keep the target tables updated through CDC.

Prerequisites​

  • PostgreSQL import is supported only for VeloDB Cloud warehouses running the 26.x series.
  • The PostgreSQL source must be version 14 or later.
  • A VeloDB Cloud warehouse that can reach the PostgreSQL host and port.
  • A PostgreSQL user with permissions to read the selected schemas and tables.
  • Logical replication enabled on the PostgreSQL source.
  • A target database in VeloDB Cloud, or permission to create one during the wizard.

For AWS-managed PostgreSQL sources, complete the source-side prerequisites before creating the import job:

Create the import job​

  1. Open Import from the ingestion group, then click + Add Import Job.
  2. Select PostgreSQL.
  3. Enter the job name, PostgreSQL host, port, database, username, password, and SSL settings if required.
  4. If the PostgreSQL source is in a private VPC, enable Private Link and configure the PrivateLink connection in the wizard. For setup details, see Grant VeloDB access to your VPC.
  5. Select the target database.
  6. Choose the sync type:
    • Initial Load + Incremental Sync: loads existing data first, then captures ongoing changes.
    • Incremental Sync only: captures only new changes from the configured offset.
  7. Select the schemas and tables to ingest. Expand a table to configure column-level filtering if needed.
  8. Configure the sync interval and strict mode.
  9. Run the pre-checks. When all checks succeed, start the job.

View job details​

In the import job list, click a PostgreSQL import job to open its details page.

For a PostgreSQL import job, the details page provides monitoring views such as:

  • Sync Rows
  • Imported Size
  • Sync Task Failure Count

You can also configure monitoring for Sync Task Failure and open the corresponding Task Details to inspect failed sync tasks.

Troubleshooting​

  • If connectivity checks fail, verify the host, port, security group, firewall, and PrivateLink configuration.
  • If CDC checks fail, verify logical replication settings and source user permissions.
  • If rows fail to load, review column types, strict-mode behavior, and column filters.