Litestream for SQLite. WAL-G is probably the solution for Postgres. I think that a combination of periodic dumps combined with WAL streaming to S3 will allow for a more robust and space-efficient backup strategy that is similar to differential backups in terms of space utilisation.
Awesome video! Short, to the point, and everything is explained clearly. Thank you!
😀
Great video, thanks!
😃
Buen video .. quiero sacar un backup y me sale el error ... Pg_dump: el esquema 2201 no existe... Portgresql-11.?
Thanks! I would need a bit more context. What is the command you're running?
Concise!
What's the best way to enable PITR?
I haven't heard of PITR until your comment! Good topic though Ill look into it
Litestream for SQLite. WAL-G is probably the solution for Postgres.
I think that a combination of periodic dumps combined with WAL streaming to S3 will allow for a more robust and space-efficient backup strategy that is similar to differential backups in terms of space utilisation.
See Chapter 26.3 of the Postgres documentation
Excellent video! Thank you!
😀