Question:
I have a postgres backup about 100GB and want to load it to S3 in EU Frankfurt and restore it in cloud database.
I have no access to AWS Import/Export service. on Ubuntu laptop
Strategies I have tried
1 2 3 4 5 |
1) management console upload, at least 2 weeks needed 2) bucket explore multi-upload, task failed due to java memory error every time 3) SDK multi-upload(boto, boto3, java SDK), do not show the progress bar. can not estimate how long it needs 4) other windows explore, do not have Linux version |
What is the fastest way to load this into S3? or code snippet in either python or java. thanks a lot
Answer:
The easiest solution would be to use the AWS CLI (https://aws.amazon.com/de/cli/).
1 2 |
aws s3 cp /PATH_TO_BACKUP/BACKUP_FILE s3://BUCKETNAME |