Backup

PostgreSQL allows you to perform backups in a traditional way or through the continuous archiving and point-in-time recovery mode. Through the Point-In-Time Recovery (PITR), PostgreSQL is able to bring the database back to any point in the past.

pg_dump

pg_dump is a utility for backing up a PostgreSQL database. It makes consistent backups even if the database is being used concurrently. pg_dump does not block other users accessing the database (readers or writers). It only dumps a single database. To back up global objects that are common to all databases in a cluster, use pg_dump_all.

The dump can be made in a script or file formats. Script files are plain-text files containing the SQL commands required to reconstruct...