39 lines
1.2 KiB
Markdown
39 lines
1.2 KiB
Markdown
# Ansible Database Backup
|
|
|
|
[](https://docs.ansible.com/ansible/latest/collections/community/postgresql/postgresql_db_module.html#ansible-collections-community-postgresql-postgresql-db-module)
|
|
|
|
Backup database from remote postgresql for {{store}} days.
|
|
|
|
## Install
|
|
|
|
```
|
|
ansible-galaxy collection install community.postgresql
|
|
```
|
|
## How to dump
|
|
```
|
|
ansible-playbook sd_pro_dump.yml -l sd-pgsql9 --extra-vars "dbname=sd4_itsmcorp_devel store=7 arg=--format=custom"
|
|
```
|
|
```
|
|
Avalable env:
|
|
store: default('1') - how long do you need to store current backup
|
|
target: default('/opt/back/internal/postgres/') - where place put the archive
|
|
arg: default('--exclude-table=tbl_event --format=custom') - pg_dump argument
|
|
```
|
|
|
|
#### PostgreSQL
|
|
|
|
[Official documentaiton.](https://www.postgresql.org/docs/current/static/app-pgdump.html)
|
|
|
|
Example:
|
|
|
|
```
|
|
pg_dump --format "custom" --file "/opt/back/internal/postgres/{{ dbname }}.bak" {{ dbname }}
|
|
```
|
|
|
|
## Supported Databases
|
|
|
|
For now supports:
|
|
* PostgreSQL
|
|
|
|
## Supported OS
|
|
Linux |