“Failed to initialize the database” error when using PostgreSQL in FluentCMS

[hyobokkim]

When using PostgreSQL with FluentCMS, the setup process fails during the /setup step with the message “Failed to initialize the database.” The PostgreSQL connection is successful and FluentCmsDbContext is properly initialized, but a System.InvalidOperationException occurs afterward.

It appears that the NuGet package FluentCMS.Repositories.EFCore.PostgreSQL does not include EF Core migration files, and the SQL initialization script (Setup.sql) might be missing from the embedded resources. The exception log shows that the file 'FluentCMS.Repositories.EFCore.PostgreSQL.Setup.sql' cannot be found, suggesting it was not packaged correctly.

Could you please confirm whether the PostgreSQL provider intentionally excludes migration scripts, or if there is a recommended way to initialize the schema (e.g., through a provided SQL script or manual migration process)?