问题原文
原帖链接 · fadedbee · CC BY-SA 3.0
How can I instruct Postgres to complete all "in-progress" transactions, but to delay starting new ones (without kicking clients off) until I have taken a ZFS or LVM snapshot (which takes less than a second).
e.g.
- pause Postgres, waiting for "in-progress" transactions to complete
- sync to disk
- take ZFS/LVM snapshot
- resume Postgres
已采纳解答
原帖链接 · user121391 · CC BY-SA 3.0
This answer on dba.stackexchange seems to be what you are after.
Comments do not seem to automatically link in the side bar (inside the network), so I need to write some more stuff to prevent auto-conversion to a comment... yeah.
摘自公开归档,保留原文语言,版式经整理,外部媒体与邮箱地址已移除。
