XataX
Xata•12mo ago
November

CLI/programmatic migrations for pg-enabled dbs

Hey all, I'm looking to try and test out xata, and want to be able to do some migrations programmatically

So far, it looks like re-using my existing Flyway migrations is out (I can't just point it to the xata instance unless it's a dedicated instance), so I figured that pgroll CLI would be the way to go

I know that pgroll is already built-in to the UI itself for managing, and prior questions seem to point to the UI (helppgroll with pg-enabled db), but I was wondering if there was a way to get programmatic or externally-driven migrations working with xata- trying with:

pgroll init --postgres-url <my xata connection string>


results in:

ERROR   Failed to initialize pgroll: pq: unsupported statement [CREATE FUNCTION] on regular level, see https://xata.io/sql-support for the support matrix
Error: pq: unsupported statement [CREATE FUNCTION] on regular level, see https://xata.io/sql-support for the support matrix
Was this page helpful?