Deploy PowerSync | (Just Updated) Postgres Sync Engine, Keys And Demo Table Ready

Deploy and Host PowerSync on Railway

PowerSync is an open-source sync engine that streams a Postgres database into SQLite on your users' devices. Apps read and write a local database, work offline, and the engine keeps every client consistent with the server using sync rules you define.

About Hosting PowerSync

The upstream project asks you to supply a replication-ready Postgres, a second database for bucket storage, a publication, a JWT key set, an API token and a YAML config before the service will start. Most hosting attempts fail on the first one: the source database needs wal_level=logical, and the service refuses to run without it.

This template deploys two services with all of that already wired:

• postgres runs with wal_level=logical, a volume at /var/lib/postgresql, a powersync_storage database for bucket storage, a demo lists table and a powersync publication.
• powersync is the sync service pinned to 1.26.1. It is the only service with a public URL. Its config is generated at boot from variables: the database password is shared with Postgres, the JWT signing key (PS_JWKS_KEY) and the admin API token (PS_API_TOKEN) are generated per deploy, and a global bucket syncs the lists table.

Verified on a live deploy: /probes/liveness and /probes/readiness return 200, the diagnostics API reports the connection connected: true, initial replication done, and public.lists replicating with zero lag.

Why Deploy PowerSync on Railway?

Replication, bucket storage and the sync service live in one project with private networking and a volume, so there is no compose file, no TLS to terminate and no secrets to invent. The deploy form asks for nothing.

Common Use Cases

• Offline-first mobile or web apps backed by Postgres
• Local-first apps where reads and writes hit SQLite on the device
• Realtime-feeling UIs without hand-written websocket sync
• Replacing a custom delta-sync endpoint with declarative sync rules

Dependencies for PowerSync Hosting

Deployment Dependencies

• PowerSync service docs
• Sync rules
• Postgres with logical replication (included)