#postgresql#pgbackrest#replication
17K subscribers • 1 video on Hallway
Intermediate. Assumes working knowledge.
12K views2 years ago3 recommendations
Databases and dataCloud and DevOpsPostgres
A step-by-step tutorial on configuring a PostgreSQL primary and standby cluster with pgBackRest backups to AWS S3.
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: udemy.com/course/postgresql-with-pgbackrest/?referralCode=2F… == TIMESTAMPS == What are we going to build Build and configure Ubuntu 24.04 servers for Postgresql 16 Postgres installation process Configuring pg_hba.conf Create database in postgresql Create primary and secondary database Configuring postgresql.conf file why we need to configure ‘listen addresses’ in postgresql.conf Further configuration of secondary postgres server pg_basebackup command explained and run Installing and configuring PgBackrest Create SSH connectivity between both servers Configuing pgbackrest.conf file Creating full postgres backup with pgbackrest command Failover from primary to secondary postgres database Recover postgres from remote location 🔥🔥 Learn Devops and Cloud on our platform: automation-avenue.com 📧 info@automation-avenue.com == 29 ==What people say. Recommended as a comprehensive step-by-step guide to setting up PostgreSQL replication and pgBackRest backups.
u/ThickRanger5419in r/PostgreSQL • Recommends
On “Help me setup my first postgres server ”
u/ThickRanger5419in r/PostgreSQL • Recommends
On “PostgreSQL on Ubuntu by Default”
u/Lonely-Top-6349in r/PostgreSQL • Recommends
On “Advice on Postgres Backup strategy”
u/ThickRanger5419in r/PostgreSQL • Recommends
On “PostgreSQL newbie questions”
u/ThickRanger5419in r/PostgreSQL • Recommends
On “PostgreSQL Course with Practical Exercises (intermediate)”
u/ThickRanger5419in r/PostgreSQL • Recommends
On “At what point should i switch to a managed service ?”
u/KeyDecision2614in r/PostgreSQL • Recommends
On “Best way to create a PostgreSQL replica for disaster recovery (on-premise)?”
u/KeyDecision2614in r/PostgreSQL • Mentions
On “does managing a database is that hard ?”
u/KeyDecision2614in r/PostgreSQL • Mentions
On “What's the best practice for PostgreSQL database migration between on-premise servers?”
u/KeyDecision2614in r/PostgreSQL • Mentions
On “Database level online backup tool”
u/KeyDecision2614in r/PostgreSQL • Mentions
On “Is it doable to run Postgres ourselves?”
u/ThickRanger5419in r/PostgreSQL • Mentions
On “At what point should i switch to a managed service ?”