Permission denied on a system trigger

[Jyr Gaxiola]

Hi,

I'am restoring a dump from postgresql server to cloud sql with pg_restore and I get the error:

permission denied: "RI_ConstraintTrigger_a_13654402" is a system trigger

I understand that I need to be superuser but cloud sql don't permite use this role, Exists another way to restore database with a user with role cloudsqlsuperuser ?

Thanks

[ajorda]

Hello,

I believe that the question-answer format from StackOverflow may be more suited in this case and it will give your issue more visibility, which will result in having a bigger chance of managing to solve it.


Best regards,

Àlex J.