undefined | Better HN

0 pointstechnion9y ago0 comments

The corollary to the backup solution is that if Postgresql ever ended up operating in a similar fashion to Oracle's rman, particularly on its encouraged ASM, Postgresql would very quickly start seeing "Postgresql requires a full time DBA, just use MariaDB" type blogs. I can see how the middle ground is a hard problem.

0 comments

2 comments · 2 top-level

clg29y ago

I agree, Postgres having its own storage subsystem would be wrong. Fortunately the PG philosophy is to leave what the OS does best to the OS, so its unlikely that situation would arise.

However, a middle ground of being able to backup just the changes in a multi-terabyte database that have been made since the last full backup, wouldn't be controversial and is a common use case.

I've read of a few attempts on the PG dev mailing list over the last couple of years, so hopefully one of them will be completed sometime soon and merged into core.

Some of the work I have come across :

https://github.com/ossc-db/pg_rman

https://github.com/2ndquadrant-it/barman/issues/21

randallsquared9y ago

> Postgresql would very quickly start seeing "Postgresql requires a full time DBA, just use MariaDB"

Yeah, welcome to 15 years ago, when that was the common wisdom.

j / k navigate · click thread line to collapse