Hello,
I was just experimenting with PostgreSQL backup relying solely on the integrity of the frozen/atomic snapshot of the UFS file system, and I managed to have a valid (recoverable) PostgreSQL data cluster in every single test I did.
The question is what would happen if a data spanned across multiple file systems, e.g. when each database resides in its own table space which is located in its own filesystems, while the xaction logging is located in its own dedicated file system.
Is it possible to have all UFS snapshots "frozen" in relation to each other? (like ZFS recursive)
I was just experimenting with PostgreSQL backup relying solely on the integrity of the frozen/atomic snapshot of the UFS file system, and I managed to have a valid (recoverable) PostgreSQL data cluster in every single test I did.
The question is what would happen if a data spanned across multiple file systems, e.g. when each database resides in its own table space which is located in its own filesystems, while the xaction logging is located in its own dedicated file system.
Is it possible to have all UFS snapshots "frozen" in relation to each other? (like ZFS recursive)
Last edited by a moderator: