How to backup all Postgres databases without interrupting access to the service?

Question

linux

Greetings!
Please tell me the similarity of XtraBackup for working with Postgres.
Program requirements:
free;
available under Debian;
allows you to make a backup without blocking, i.e. applications can write\read data from the database during the backup process;
allows you to quickly restore data;

Answer 1

pg_basebackup Make
a consistent physical copy of the base. Accordingly, the size of the backup is approximately equal to the size of the postgresql cluster + accumulated during the copying of WAL.
It is easy to restore by running postgresql with PGDATA in the place where the result of pg_basebackup lies.
They usually raise remarks.
pg_dump or pg_dumpall
Logical data backup. Usually not very suitable for the criterion of quickly recovering. when restoring, they will rebuild indexes, check fk and other constraint, but as a rule, it is much more compact (a couple of times without compression it is easy, with compression the difference is even greater) more compact in size.
All from the standard Postgresql delivery. And other Postgresql backup methods basically rely on them.

Answer 2

Standard pg_dump utility

• is everywhere where there is Postgres
  
• does not block the database: applications can read / write data, but requests to change the structure will most likely wait for the end of the backup
  
• restores as fast as normal SQL queries.
  

Answer 3

For a full disclosure of the issue, you can watch the lectures
https://www.youtube.com/watch?v=LXC15K4pV0o&list=P...
https://www.youtube.com/watch?v=xWtuIwfdSH0&list=P...

Answer 4

www.pgbarman.org