轻松拍摄postgres和mysql数据库的快照并上传到aws s3。
bacman的Python项目详细描述
#django bacman是一个简单的库,它获取postgres或mysql数据库的快照并上传到aws s3。
`.pam环境`
``bash
database-url=“postgres://dbuser:dbpass@localhost:5432/dbname”
aws涉密访问密钥“yourawssecresecretaccesskekeyababawwghjklmnopqr
aws涉密访问密钥“yourawawawasaccesskeyidab”
bacman涉密访问密钥“awawawsaccesskeyidab”
bacman涉密访问密钥“bacman-bacman示例”
bacman-bacman-directory=/home/bacman/bacman/bacman/region=“欧盟-西部-1”
```
**第3步:**创建.py文件,其内容如下:从bacman导入postgres
``python
。postgres从bacman导入postgres
postgres(清除本地快照=true)
`````
``python
。postgres从bacman导入postgres
postgres(清除本地快照=true,当地的快照时间=24)
````
亚马逊网络服务
>请在您的`/etc/环境`.pam/u环境`
**aws/u secret/u访问密钥**
>请在您的`/etc/环境`/etc/环境`.pam/u环境`
\bacman.bacman-id`变量添加到您的`/etc/etc/环境`.pam/u环境`
####BACMAN_BUCKET
Please add the `BACMAN_BUCKET` variable to your `/etc/environment` or `.pam_environment`
#### BACMAN_DIRECTORY
* default: `/tmp/bacman`
#### BACMAN_PREFIX
* default (Postgres): `pgdump`
* default (MySQL): `mysqldump`
### Examples ###
```python
# /home/bacman/runbacman.py
from bacman.postgres import postgres
postgres(to_remote=true,
>main()
```>
```````````
````````
```````
````>>$chmod+x runbacman.py
$python runbacman.py
``````
```` bash
`>
`````` bash
`>
`;打开crontab编辑器,在crontab编辑器中键入crontab-e-crontab-e,打开crontab-crontab-e,打开>
m h dom mon-dow命令
0*/2***~/env/bin/python~/runbacman.py>;>home/bacman/logs/crontab.log 2>;&1
```
`.pam环境`
``bash
database-url=“postgres://dbuser:dbpass@localhost:5432/dbname”
aws涉密访问密钥“yourawssecresecretaccesskekeyababawwghjklmnopqr
aws涉密访问密钥“yourawawawasaccesskeyidab”
bacman涉密访问密钥“awawawsaccesskeyidab”
bacman涉密访问密钥“bacman-bacman示例”
bacman-bacman-directory=/home/bacman/bacman/bacman/region=“欧盟-西部-1”
```
**第3步:**创建.py文件,其内容如下:从bacman导入postgres
``python
。postgres从bacman导入postgres
postgres(清除本地快照=true)
`````
``python
。postgres从bacman导入postgres
postgres(清除本地快照=true,当地的快照时间=24)
````
亚马逊网络服务
>请在您的`/etc/环境`.pam/u环境`
**aws/u secret/u访问密钥**
>请在您的`/etc/环境`/etc/环境`.pam/u环境`
\bacman.bacman-id`变量添加到您的`/etc/etc/环境`.pam/u环境`
####BACMAN_BUCKET
Please add the `BACMAN_BUCKET` variable to your `/etc/environment` or `.pam_environment`
#### BACMAN_DIRECTORY
* default: `/tmp/bacman`
#### BACMAN_PREFIX
* default (Postgres): `pgdump`
* default (MySQL): `mysqldump`
### Examples ###
```python
# /home/bacman/runbacman.py
from bacman.postgres import postgres
>main()
```>
```````````
````````
```````
````>>$chmod+x runbacman.py
$python runbacman.py
``````
```` bash
`>
`````` bash
`>
`;打开crontab编辑器,在crontab编辑器中键入crontab-e-crontab-e,打开crontab-crontab-e,打开>
m h dom mon-dow命令
0*/2***~/env/bin/python~/runbacman.py>;>home/bacman/logs/crontab.log 2>;&1
```