Day 13: PostgreSQL 18 Disaster Recovery Guide #postgresql #dba #day13

Ajouté : 2026-06-03

[00:00:01]Hello everyone, welcome to Chirag Postgres SQL DBA tutorial. This is a day 13 Postgres SQL 18 zero to hero in 30 days course. So in day 13, we are going to learn about the Postgres SQL 18 disaster recovery guide and [snorts] Postgres SQL there will be the backup, recovery, high availability and data protection. In the day 12, we are going to through this. And [snorts] first question is that what is the disaster recovery in Postgres SQL 18? So disaster recovery DR in the Postgres 18 is the process to recovering data from the after failure like the server crashes, hardware failure, accidental deletion or the data corruption using the base backup and WAL archiving and replication and point in time recovery.

[00:00:43]So [snorts] in our case, we have a two servers. One is the primary server, another is the standby server. So primary server will take a backup and will test with the base backup and disaster recovery also and WAL archiving. And we'll also configure configure here in this video that we are go through we are going through the streaming backup, streaming replication.

[00:01:07]>> [snorts] >> So that replication will keep the data on the two server. So we have a created step-by-step full process for the this tutorial. You can go through this URL.

[00:01:17]I'll provide you the URL in the top of this description.

[00:01:22]So there we have created all and here you can see all the details about the recovery and all the step-by-step process we have done.

[00:01:31]So final our architecture will be that the replication will connected with a primary server and streaming replication between primary to standby server. There is a WAL archiving and backup storage will create that. So full recovery workflow is that normally normal operation user insert and update data WAL generated, WAL archive and base backup created in standby receive replication. And during the disaster, server crashes, it base backup, uh replay wall files, recover transaction, remote standby if required, and resume application. So, all the details step-by-step we have done. And we have the two servers.

[00:02:09]This is the first server. We can check that the wall archiving is on.

[00:02:15]Uh wall command is this command and PG wall recovery.

[00:02:19]Okay. So, here you can check all the data, whatever the data we have inserted, all the data we will get on the second server also. So, all the details of step-by-step process you can go through the full video.

[00:02:34]>> [snorts] >> So, disclaimer is there. All this video is created for the education and information purpose only under the fair use section 107 copyright at 1976. All trademarks and logos belong to their respective owners. You can follow me on >> [snorts] >> uh social media links. And hope this will help. Thank you for watching. Don't forget to follow, like, share, and comment, and subscribe to my channel.

[00:02:54]Thank you.