Wednesday, January 17, 2018

[google-cloud-sql-discuss] Exporting Multiple Tables from a Postgres Instance

I'm trying to get a dump of a Postgres database while avoiding several large tables. I've tried several methods to specify certain only tables, as the docs seem to say you should be able to. I've tried:
  • gcloud sql instances export db-foo gs://db-backups/$(date +%s)-sql.gz --database foo_production -t leads,issues (only exported leads)
  • gcloud sql instances export db-foo gs://db-backups/$(date +%s)-sql.gz --database foo_production -t leads -t issues (only exported issues)
  • gcloud sql instances export db-foo gs://db-backups/$(date +%s)-sql.gz --database foo_production --table=leads,issues (only exported leads) 
Is anyone else having this issue?

--
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/5d6ff7eb-3454-40d6-8403-d90c52c4f68c%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment