PostgreSQL backup process in one of the biggest issues you face after switching to PostgreSQL. PostgreSQL has two out-of-the box options for backup and restore, they are dump/restore and pg_basebackup. Both of them have their nuances and peculiarities radically distinguish the backup and recovery system from MS SQL. Another option in the PostgreSQL ecosystem is the pg_probackup utility which is being actively developed and has a number of backup and restore variants offering different features. Each of these options maybe good or not so good for a particular scenario. In this talk, I'd like to cover the nuances, peculiarities and best practices for large databases, hundreds of midsize databases and small database setups.