Remix.run Logo
afgrant 4 hours ago

Does Postgres no have online backup built in? All of the other major DBMSes do.

nijave 3 hours ago | parent | next [-]

Postgres 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.

zie 3 hours ago | parent | prev [-]

See the documentation: 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/

nijave 3 hours ago | parent [-]

Hopefully barman has some longevity being under EDB assuming some hyperscaler doesn't gobble them up

zie 2 hours ago | parent [-]

Barman 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.