4 ms·
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, Po
by technion 10y ago
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.
- clg2 10y agoI 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/ossc-db/pg_rman https://github.com/2ndquadrant-it/barman/issues/21 https://github.com/2ndquadrant-it/barman/issues/21
- randallsquared 10y 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.