Ancestors

Toot

Written by Régis Haubourg on 2024-12-19 at 16:35

Rain and clouds. A perfect day to fully qualify ZFS and postgres scenarios on a 8TB database. Hot snapshot , send , promote backup, rollback. Data is compressed, so are ssh transfers.

It takes a while to consolidate but I will not live without it anymore. #ZFS #Postgres

=> More informations about this toot | More toots from RegisHaubourg@mastodon.social

Descendants

Written by Régis Haubourg on 2024-12-19 at 16:50

@cquest your blog post drove me on the ZFS way, thanks !

=> More informations about this toot | More toots from RegisHaubourg@mastodon.social

Written by Régis Haubourg on 2024-12-19 at 17:00

.. still having unlogged tables was a really bad idea. Restoring a snapshot taking while DB is running is like a crash recovery. And unlogged tables are lost.

Thanks again @pwramsey for making it straight clear there https://www.crunchydata.com/blog/postgresl-unlogged-tables

=> View attached media

=> More informations about this toot | More toots from RegisHaubourg@mastodon.social

Written by Régis Haubourg on 2024-12-19 at 17:13

As we no more have pg_backup_start available outside of a transaction, does anyone has any other tip than this script by Laurenz Albe ?

https://github.com/cybertec-postgresql/safe-backup

=> More informations about this toot | More toots from RegisHaubourg@mastodon.social