Xata•4mo ago

pgroll with pg-enabled db

I tried using pgroll like shown on github

pgroll init --postgres-url postgres://user:password@host:port/dbname

pgroll init --postgres-url postgres://user:password@host:port/dbname

using the url from pg enabled database but I get an error

Failed to initialize pgroll: pq: unknown statement type, see https://xata.io/sql-support for the support matrix
Error: pq: unknown statement type, see https://xata.io/sql-support for the support matrix

Failed to initialize pgroll: pq: unknown statement type, see https://xata.io/sql-support for the support matrix
Error: pq: unknown statement type, see https://xata.io/sql-support for the support matrix

1 Reply

tsg•4mo ago

Hi, actually you don't need to use pgroll with Xata because it's already built in. See https://xata.io/blog/multi-version-schema-migrations for how to take advantage of the built-in pgroll

Introducing multi-version schema migrations

Today's release of multi-version schema migrations addresses one of the most common pain points of application deployment - keeping your application code and database schema in sync. You can now present two versions of your schema, both old and new, to client applications.

Gaming

Programming

pgroll with pg-enabled db