Hi Mike,
It does seems that the dump file you are trying to import includes some plpgsql statements requiring Superuser role. This role is certainly not available on hosted PostgreSQL.
It is unlikely that you need to import plpgsql related statements since by default, the database has the plpgsql extension already installed. So there is no need to install it again via the import.
The suggested workaround is to inspect you inspect your dump file and remove all sql statement related to "plpgsql".
-- It does seems that the dump file you are trying to import includes some plpgsql statements requiring Superuser role. This role is certainly not available on hosted PostgreSQL.
It is unlikely that you need to import plpgsql related statements since by default, the database has the plpgsql extension already installed. So there is no need to install it again via the import.
The suggested workaround is to inspect you inspect your dump file and remove all sql statement related to "plpgsql".
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/20332947-0f53-499f-b38f-fa8d031e7f34%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment