skkzsh/oss-db.md

Last active September 1, 2019 08:40

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/skkzsh/4992ad136280c2fa9fac23e3aa069243.js"></script>
Save skkzsh/4992ad136280c2fa9fac23e3aa069243 to your computer and use it in GitHub Desktop.

Download ZIP

OSS-DB

Raw

Backup

オフラインバックアップ (= ディレクトリコピー) => 物理バックアップ
論理バックアップ (= pg_dump, pg_restore, psql) => オンラインバックアップ
ベースバックアップ/PITR (WAL, recovery.conf使用) <=> オンラインバックアップかつ物理バックアップ

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment