Cannot use an app account with db-migrator

[rleffd]

Hello,

A few weeks ago, I have reported that there was an error with the pg_partman extension when using an account that is not super admin.

A new commit fix this issue: #4104

I have build a new image with the two files modified, and now I have a new error:

ERROR: function partman.create_parent(unknown, unknown, unknown, p_start_partition => text) does not exist (SQLSTATE 42883)

RDS Postgres 16.4

Is there a way to run db-migrator without a super admin user on the postgres db ?

[tegioz]

Hi @rleffd 👋

It looks like the pg_partman extension hasn't been created yet. You still need to do that with a user that has privileges to do so, like you were trying to do in #4103 (comment). Once the extension is ready, you should be able to proceed with the migrations as we won't try to create it again if it already exists.