#Postgresql install db on external drive how to#

To do this you need to set up a cron job so that your database backs up automatically at regular intervals.

#Postgresql install db on external drive how to#

In this section, learn how to import a database in PostgreSQL and automate the process. Restore all databases from the backup: psql -f pg_backup.bak postgres To store this information, and back up all of your databases simultaneously, you can use pg_dumpall.Ĭreate a backup file: pg_dumpall > pg_backup.bak Restore the database using psql: psql test dbname.bakīecause pg_dump only creates a backup of one database at a time, it does not store information about database roles or other cluster-wide configuration. To demonstrate how to load a database in PostgreSQL and restore lost data, first delete your example database and then create an empty database: dropdb dbname This file can be transferred to another host with scp or stored locally for later use. pg_dump dbname > dbname.bakĪfter performing the PostgreSQL load dump into a file, the resulting backup file containing the database is dbname.bak. Replace dbname with the name of the database to be backed up.

Log in as the postgres user: su - postgresĭump the contents of a database to a file by running the following command. This command must be run as a user with read permissions to the database you intend to back up. PostgreSQL provides the pg_dump utility to simplify backing up a single database. For more information on privileges, see our Users and Groups guide. Be sure to run the steps below as root or with the sudo prefix. The steps in this guide require root privileges.