Скачать с ютуб PostgreSQL primary and standby with pgbackrest backup complete step-by-step setup ! в хорошем качестве

PostgreSQL primary and standby with pgbackrest backup complete step-by-step setup !

Step-by-step tutorial on how to configure Postgres / PostgreSQL cluster that includes primary ( master ) and standby ( slave / secondary ) server replicating from primary. We will then add PgBackRest that will be taking backups to remote location ( we will use AWS S3 bucket for that purpose, but PgBackrest allows you to choose any other storage you want ). Once we have that, we will perform various failover and recovery tasks to see how we can failover from primary to standby if primary PostgreSQL server goes down, and how to recover when both - primary and standby go down and we have to use PgBackrest and our remote backup to make the Postgres cluster back up and running again. We will be configuring PostgreSQL 16 on Ubuntu 24.04 LTS, but you can follow this tutorial for other Postgres versions and other linux distributions as the installation and configuration of Postgres doesnt differ much in other environments. This material is also available as Udemy training, please see the link below: https://www.udemy.com/course/postgres... == TIMESTAMPS == 0:00 What are we going to build 2:15 Build and configure Ubuntu 24.04 servers for Postgresql 16 6:20 Postgres installation process 9:20 Configuring pg_hba.conf 10:35 Create database in postgresql 12:10 Create primary and secondary database 14:05 Configuring postgresql.conf file 14:25 why we need to configure ‘listen addresses’ in postgresql.conf 16:35 Further configuration of secondary postgres server 17:10 pg_basebackup command explained and run 25:15 Installing and configuring PgBackrest 26:00 Create SSH connectivity between both servers 32:10 Configuing pgbackrest.conf file 39:00 Creating full postgres backup with pgbackrest command 42:00 Failover from primary to secondary postgres database 43:45 Recover postgres from remote location 🔥🔥 Learn Devops and Cloud on our platform: https://www.automation-avenue.com 📧 [email protected] == 29 ==