Database Setup

PowerSync currently supports Postgres as backend database.
Configuring your Postgres database with PowerSync generally involves four tasks:
  • Enable logical replication
  • Create a PowerSync database user
  • Create powersync publication
  • Connect PowerSync to your database
We have documented steps for some hosting providers:
For other providers and self-hosting, see:

Unsupported Hosting Providers

Due to the logical replication requirement, not all hosting providers are supported.
Notably, some "serverless Postgres" providers do not support logical replication, and are therefore not supported by PowerSync yet.