From the course: PostgreSQL Backup and Restore with pgBackRest
Join today to access over 25,000 courses taught by industry experts.
Solution: PITR using LSN number - PostgreSQL Tutorial
From the course: PostgreSQL Backup and Restore with pgBackRest
Solution: PITR using LSN number
(bright curious music) - [Instructor] Let's see what is the solution of the task challenge, performing point in time recovery, using lsn number. So, what I'm going to do over here is I am going to drop the table, which we have used for the point in time recovery. And, last time we saw deletion and recovery. Now, we'll see dropping the table and then recovering it using the LSN number. So I'll quickly go to my Postgres database. I'm currently on my database server. And, as you are aware, I have this table test_pitr. It has five records. Before dropping, I'm going to note down my current LSN number, because we are going to perform PITR using LSN number. So I will just type a command, which is select pg_current_wal_lsn. So previously we noted the time because we are performing PITR using time. Now we are performing PITR using current wal lsn number. So I'll note it down. It's nine five or whatever the number is. We just need to be aware that this was a number. And I will drop the table…