This command is actually a PostgreSQL client program, so it can be run from a remote system as long as that system has access to the database. The command must be run by a user with privileges to read all of the database information, so it is run as the superuser most of the time.įor a real-world example, we can log into the 'postgres' user and execute the command on the default database, also called 'postgres': sudo su - postgres The basic syntax of the command is: pg_dump name_of_database > name_of_backup_file The pg_dump utility is run from the Linux command line. PostgreSQL includes a utility called ' pg_dump' that can be used to dump database information into a file for backup purposes. How to Back Up a PostgreSQL Database Using pg_dump Most modern distributions and recent versions of PostgreSQL will operate in a similar way. We will be using an Ubuntu 12.04 VPS with PostgreSQL 9.1. This guide will cover some practical ways that you can backup your PostgreSQL data. It is frequently used to store and manipulate information related to websites and applications.Īs with any kind of valuable data, it is important to implement a backup scheme to protect against data loss.

PostgreSQL is a modern database management system.

Iperius backup tutorial