The PostgreSQL CREATE DATABASE statement requires a superuser account and the WITH OWNER clause allows you to change ownership to, say, a normal service account.
It would be super nice to have this option in the PostgresqlDatabase method to minimize the use of a superuser connection string.
sqlCommandText = string.Format
(
"create database \"{0}\";",
databaseName
);
https://github.com/DbUp/DbUp/blob/master/src/dbup-postgresql/PostgresqlExtensions.cs#L189-L193
The PostgreSQL CREATE DATABASE statement requires a superuser account and the WITH OWNER clause allows you to change ownership to, say, a normal service account.
It would be super nice to have this option in the
PostgresqlDatabasemethod to minimize the use of a superuser connection string.https://github.com/DbUp/DbUp/blob/master/src/dbup-postgresql/PostgresqlExtensions.cs#L189-L193