PostgreSQL Backup & Point-In-Time Recovery

man you helped me a lot

Do managed databases in aws and gcp have this built-in ?

Best explanation. Thank You

Thank you very much for a detail and informative tutorial

Great explanation .thank you

Hi ,
default archive log file size is 16mb and can we reduce the size of archive log file.(i use the compressed version and it will reduce 16mb to 20k).but with out compression i need other solution .can u advise in this ?

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?

Great video!! Thanks!!!!

Thank you so much

Is it really necessary to use the restore_command if not doing a point in time recovery? The basebackup generates a full valid backup and so it should not be necessary to use the restore_command to use wal files from the archive folder, right?

Hey, I Have been stuck after the "pg_basebackup -Ft -X none -D - | gzip > /var/lib/postgresql/db_file_backup.tar.gz" command line. it shows "pg_stop_backup still waiting for all required WAL segments to be archived (3840 seconds elapsed)" which means it has already taken 1 hour and continuing. Is it normal or just happening to me?

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

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 "/var/run/postgresql/.s.PGSQL.5432"?"

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.

because you just edited the recovery.conf

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

Thanks so much...i really have enjoye this

hello, one question, is it possible to recover the database after applying a drop to the entire database?

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

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