search

supercaracal / japan-masters-swimming

The Japan Masters Swimming Championship Results
https://github.com/supercaracal/japan-masters-swimming/issues/12
0 stars 0 forks source link

DB backup #4

Open supercaracal opened 7 years ago

supercaracal commented 7 years ago

https://www.postgresql.jp/document/9.5/html/app-pgbasebackup.html

$ sudo su -
$ mkdir -p /tmp/postgresql/backups
$ /usr/bin/pg_basebackup -D /tmp/postgresql/backups -v -U postgres -l "$(date +'%Y-%m-%d %H:%M:%S').$(date +%3N)" -Ft -z -Z 9 -r 1M -Xf