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:

pageSupabasepageAWS RDSpageAzure PostgrespageGoogle Cloud SQLpageNeonpageFly Postgres

For other providers and self-hosting, see:

pageOther / Self-hosted

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.