I have a Amazon server with small storage space, I need to back up my personal machine.
If I enter the server and run
pg_dump -h localhost bd > backup.sql
everything works, however the backup is 700mb.
How to do pg_dump remotely
2
asked by anonymous 19.10.2017 / 15:48
1 answer
1
If you have postgresql installed on your machine (or the required files), you can run the same command by changing the -h parameter to the ip / domain of your server on Amazon.
Noting that you may have restricted access to the bank, routes, firewall, etc.
I, would back it up on the server, pack (with protection), and send it wherever I need it. The compressed dump will certainly be much smaller, and still have protection as it is pure text.
To test, I grabbed a 2.39 GB dump (2,574,549,841 bytes) and compacted, using the winRar and optimal compression method. The result was an 845 MB (886,901,867 bytes) file.
19.10.2017 / 15:53