Add CLI option to commands dbmate create and dbmate drop to use another database than postgres to create/drop the database
#749
maximilian-hammerl
started this conversation in
Feature Ideas
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
Uh oh!
There was an error while loading. Please reload this page.
-
Supabase uses the
postgresdatabase as the default database. Therefore,dbmate createanddbmate dropfail, because you cannot drop the currently connected database and dbmate always uses thepostgresdatabase to create/drop a database. (I've already run into this problem: #747)It would be great, if one could specify another database than
postgresfor dbmate to use withdbmate createanddbmate drop.(When running
db resetusing the Supabase CLI, it uses thetemplate1database for dropping and creating the database: https://github.com/supabase/cli/blob/develop/internal/db/reset/reset.go#L154)(I am open to implementing this if there is positive feedback on this feature request.)
Beta Was this translation helpful? Give feedback.
All reactions