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

Hi,

1) using a lunix machine

2) had a postgresql client

3) Done

4) this is a 160MB file for a schema backup in t format 

this is a 480kB file for a schema backup in t format 

this is a 200kB file for a schema backup in sql format 

this is a 145Kb file for a schema backup in sql format

Also the Network stats:

Best,

Rajat

On Tuesday, 28 July, 2020 at 4:12:30 am UTC+5:30 Elliott (Google Cloud Platform Support) wrote:

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.

Confidentiality Notice: 

This e-mail transmission, and any documents, files or previous e-mail messages attached to it may contain confidential information that is legally privileged. If you are not the intended recipient, or a person responsible for delivering it to the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of any of the information contained in or attached to this transmission is STRICTLY PROHIBITED.  If you have received this transmission in error, please immediately notify the sender. Please destroy the original transmission and its attachments without reading or saving in any manner.

--
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/8e359bc9-2d28-45af-b6ab-349918c091d5n%40googlegroups.com.