X
Xata•2mo ago
Oleksandr

pgroll.is_active_migration_period Error

I just started to use pgroll, and tried it initially with local postgres 16 in docker. All works fine. After that, I decided to apply the same migration to the my db in XATA and as a result get this error: Failed to start migration: pq: function [pgroll.is_active_migration_period] is unknown or not allowed What did I do wrong? Maybe someone has faced it before?
1 Reply
cmck
cmck•3w ago
Hi Oleksandr, thanks for reaching out. Could you share a bit more information on how you applied the migration? Xata already uses pgroll in the background and you can use the migration editor in the UI or the Xata CLI with xata migrate 
USAGE
  $ xata migrate [--no-input] [--profile <profile-name>]

COMMON FLAGS
  --no-input                Will not prompt interactively for missing values
  --profile=<profile-name>  Profile name to use

DESCRIPTION
  Execute multi-schema migrations with complete, rollback, start, list, status commands.

COMMANDS
  migrate complete  Complete an active migration
  migrate list      List migrations for a database branch
  migrate rollback  Rollback an active migration
  migrate start     Start a new migration
  migrate status    Get the status of the last pgroll migration
USAGE
  $ xata migrate [--no-input] [--profile <profile-name>]

COMMON FLAGS
  --no-input                Will not prompt interactively for missing values
  --profile=<profile-name>  Profile name to use

DESCRIPTION
  Execute multi-schema migrations with complete, rollback, start, list, status commands.

COMMANDS
  migrate complete  Complete an active migration
  migrate list      List migrations for a database branch
  migrate rollback  Rollback an active migration
  migrate start     Start a new migration
  migrate status    Get the status of the last pgroll migration

Did you find this page helpful?