Re: [google-cloud-sql-discuss] Re: Cloud SQL Dump time

Hello,

To make sure our steps match, you may follow the information here:

1) Find a Linux workstation (gLinux desktop is fine; remote SSH is fine as well if you want the backup somewhere else)

2) If you don't already have the Postgres CLI tools, you can install them: sudo apt-get install postgresql-client

3) Prepare the CloudSQL instance to accept a connection from the machine you are using. You can follow this guide to find the easiest way to do this if you are not sure how to.

4) You can then prepare to do the dump. Enter a directory with lots of space (relative to the size of the database) and then prepare by running

pg_dump -h <IP> -U postgres -F t postgres > export.sql

5) You will be prompted for your Postgres password; enter it and then the export will begin to a file called export.sql

I have included these steps to give you an idea of the process and to try it yourself and see if they work.

I will wait for your response.

--
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/06a44958-2be4-4f2b-ab67-7e2394fa98d5o%40googlegroups.com.