PostgreSQL Backup & Point-In-Time Recovery

Learn how to take a physical backup of an entire PostgreSQL database cluster and then restore it to a specific point in time. Also known as Point-In-Time Recovery or PITR. We not only show you the backup process but the restore process as well. We also highlight some differences between PostgreSQL 10 and PostgreSQL 9.

Want to learn more about Postgres performance?

[balvanthreddy]

Hi, Im new to PostgreSQL.. but it's very easy to understanding concepts. thanks for your video.

[unmatal]

Thank you very much for a detail and informative tutorial

[vikramgodara]

Hi, Thanks for sharing the wonderful information it's helping me to compare the operation in Postgres as I am oracle dba.

[codebit]

v12 PostgreSQL the move has been made, and the recovery.conf parameters are now part of postgresql.conf ,
recovery.conf triggered recovery mode.

Since the file is gone new file have taken its place:

recovery.signal: tells PostgreSQL to enter normal archive recovery it can be empty.

just in case someone stumbles like i did :)

[badaldudy]

Thanks for tutorial and series, Great job

[abhishekyadava]

Thanks for sharing. Very nice presentation.

[samilekesiz]

Thanks, great job and free. Awesome :)

[calebmbugua]

Thanks so much...i really have enjoye this

[shantanushekharsjunerft]

I am wondering why you are doing "psql -c select pg_switch_wal();"? Is it because you are trying to tell the Postgres to generate the WAL file even though it may not have reached 16MB?

[mahesh]

This really helps. can this be done in AWS Aurora postgres serverless ?

[ikmaljohari]

Hi, I'm new to postgres. Have one question regarding your tutorial. If I created new user aside from postgres user, how can I run the wal archive for the new user?

[Draz-]

If you do a PITR, doesn't all the data inserted after the restore point still get saved to the WAL files?
So after the restore procedure, those WAL files still exist, right? Wouldn't that cause issues for future restores?
You essentially wanted to get rid of that data, but if you were to do a new restore without specifying a restore point, the data would return.

[md.imrulhasan]

After running the command in my pg-13
sudo service postgresql restart
It could not restart

After the command when I use ~$ psql

It shows

"error: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket

[bhanukonthala]

Thanks for the tutorial and i want know how we can add the recovery.conf to particular directory?

[vishwaskhare]

Sir did you install posters on Ubuntu .
Bcoz I have installed postegres in Windows and Ubuntu using virtual box

[leon]

Can you please make a video to do postgres 13 incremental backup and replication in windows version

[AndeerStar]

Hello. In the archive_command parameter where you put 'test ! -f /home/...' this 'test' is the name of the data base I have or leave it as you added it to the command line with the test itself?

[zr]

Do I have to place an entry in the pg_hba.conf? After running the pg_basebackup command, it says fatal: no entry in the pg_hba.conf....

[suend]

Thanks for your tutorial. When using pg_basebackup, it will not overwrite files if exists. How would you schedule recurring daily backup?

[amandhaka]

Is it possible to make oracle RAC like solution in postgresql ?