7 ms·
Does Postgres no have online backup built in? All of the other major DBMSes do.
by afgrant 5mo ago
Does Postgres no have online backup built in? All of the other major DBMSes do.
- zie 5mo agoSee the documentation: https://www.postgresql.org/docs/current/backup.html https://www.postgresql.org/docs/current/backup.html all of these various 3rd party backup tools use these things. Mostly it's QOL stuff that you get from a 3rd party tool. We use barman, very happily: https://pgbarman.org/ https://pgbarman.org/
- nijave 5mo agoHopefully barman has some longevity being under EDB assuming some hyperscaler doesn't gobble them up
- zie 5mo agoBarman has been around since 2011, released under the GPL. If it does get ruined by someone, I'll replace it in my stack or fork it for maintenance myself. I'm not very worried though. EDB has been in private equity(PE) hands since 2019 with out managing to ruin it so far. The ownership in PE hands seems to be pretty stable, so it doesn't look like the typical pump/dump mess you often see from crappy PE money.
- nijave 5mo agoPostgres is very "unix-y" in that everything is a separate tool. It has backup interfaces and commands but doesn't ship with a comprehensive backup management solution.