Saturday, December 19, 2020

[google-cloud-sql-discuss] Permission denied on a system trigger

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

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/6c2be6d4-115a-4420-b4ae-88b9a71609dcn%40googlegroups.com.

No comments:

Post a Comment