Direkt zum Inhalt

Aurora DSQL Liquibase Support

0

Has anyone tried Liquibase with DSQL? I've tried Flyway and that currently isn't supported.

gefragt vor 2 Monaten43 Aufrufe
1 Antwort
0

Based on the available information, there is no specific mention of Liquibase support for Aurora DSQL.

Aurora DSQL has several compatibility limitations with PostgreSQL that might affect database migration tools like Liquibase. For instance, Aurora DSQL doesn't support certain PostgreSQL features such as:

  • Running GRANT [permission] ON DATABASE commands
  • Non-admin users creating schemas
  • The ALTER ROLE [] CONNECTION LIMIT command
  • The asyncpg driver for Python

For database connectivity, Aurora DSQL supports various database drivers for different programming languages including C++, C#, Go, Java, JavaScript, and others. However, Liquibase is not specifically mentioned among the supported tools.

Given that you've already tried Flyway and found it's not supported, and considering the compatibility limitations of Aurora DSQL, it's possible that Liquibase might face similar challenges. If you need to use database migration tools with Aurora DSQL, you might need to consider alternative approaches such as using pg_dump and pg_restore for migrations, or contacting AWS Support for specific guidance on working with schema migration tools in Aurora DSQL.
Sources
Unsupported PostgreSQL features in Aurora DSQL - Amazon Aurora DSQL
Amazon Aurora DSQL cluster connectivity tools - Amazon Aurora DSQL
Recommended process to migrate an existing rds postgres db to aurora dsql | AWS re:Post

beantwortet vor 2 Monaten

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.