如何将postgreSql备份上传到S3 aws

I'm creating a job which is run daily and upload a PostgreSQL backup to S3 aws. but I don't know how can do that thing. for this, I'm doing so many googling but don't find any solution.

我正在创建一个每天运行的作业，并将PostgreSQL备份上传到S3 aws。但我不知道该怎么做。为此，我做了很多谷歌搜索，但没有找到任何解决方案。

please suggest me.

请建议我。

1 个解决方案

#1

https://www.postgresql.org/docs/current/static/backup.html

There are three fundamentally different approaches to backing up PostgreSQL data:

备份PostgreSQL数据有三种根本不同的方法：

SQL dump

SQL转储

File system level backup

文件系统级备份

Continuous archiving

持续存档

None of three has any native js interface - only OS commands. Even second approach requires first stopping instance (which can be done with OS level commands only)...

三个都没有任何本机js接口 - 只有OS命令。即使是第二种方法也需要先停止实例（只能使用操作系统级命令）...

S3 part has https://docs.aws.amazon.com/AWSJavaScriptSDK/latest/AWS/S3.html

S3部分有https://docs.aws.amazon.com/AWSJavaScriptSDK/latest/AWS/S3.html

#1