How to backup PostgreSQL

preview_player
Показать описание
Why should you use continuous postgres backups? That will be answered in the video.
When you are hyped up about that.
We will setup continuous PostgreSQL backups to S3 from scratch using Wal-G.
We will also do restores, both full and to a specific point-in-time, from said storage.

Chapters:
00:00 Intro
00:49 Why is continuous backups awesome
02:41 Tools used
03:23 Configure server
14:32 Do full restore
19:29 Do point in time restore
22:29 Schedule backups and cleanups
24:55 Words of caution
26:22 Outro (like and subscribe)

If you use notion, then you should be able to use it as a template and make your own version of it in your account. I don't know how it works, I'm just the guy who checked the box ;)
Рекомендации по теме
Комментарии
Автор

Hello, thank you for your video.
How often would you advice to do basebackups ?
Is it enough to do them once a week ?

wildi
Автор

Hello, Do you do any consulting work, I need some help to setup postgreSQL and SQL server auto backups

khaledtelfah