How to backup PostgreSQL

Sdílet
Vložit
  • čas přidán 1. 07. 2024
  • 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)
    Here are the copy and paste notes that you can use www.notion.so/PostgreSQL-Comm...
    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 ;)

Komentáře • 5

  • @Mostafa-yu4nb
    @Mostafa-yu4nb Před rokem

    thank you ,very helpful

  • @geekogan
    @geekogan Před 5 měsíci

    great work man. I love it.

  • @wildi11
    @wildi11 Před 8 měsíci

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

  • @khaledtelfah3700
    @khaledtelfah3700 Před 8 měsíci

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