Now this may look trivial but it is a managed service so I don't have the superuser rights. And various schema/tables/sequences have different roles/users as their owners so I can't just use pg_dump remotely as i expected as a lot of them will fail due to permission issues.

Their export function only allows "Cloud Storage export" which I would have to pay for again plus it dumps everything not just the schema.

Someone kindly let me know if I have missed something?

So I figure their superuser "cloudsqladmin" can do the entire dump but I am unable to login as that user and do the dump. Any advice?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.