Migration and Rollback Issues with Incorrect User and Password

[juanmamaffei]

Description:

Encountering a PG::InsufficientPrivilege error when attempting to run migrations or rollbacks. The process incorrectly uses app_user and the gem's password instead of the credentials defined in the initializer.

Steps to Reproduce:

• Check out a branch with a previous version of the PG RLS gem.
• Run rails db:rollback to revert a migration.
• Switch to a branch with the current version of the PG RLS gem.
• Attempt to run rails db:migrate or rails db:rollback.
• Observe the PG::Permissions error in the console.

Expected Behavior:

Migrations and rollbacks should use the correct admin user and the password defined in the Rails initializer.

Actual Behavior:

The process attempts to execute with app_user and the gem's default password, leading to permission errors.

Environment:

• Ruby version: 3.2.2
• Rails version: 7.0.8
• Sidekiq version: 7.2.0
• PG RLS gem version: v0.1.4

[juanmamaffei]

Solved on #17 . Thanks @Dandush03 !