Deprecated

Search our articles or browse by category below

[deprecated] How to backup PostgreSQL on linux

August 22, 2016 Anders Andersen


Note: This article is deprecated since version 1.6 of the Linux agent. But are still useful if running old versions and offline configuration. Regarding any information please contact the support on support@backupbird.com

The PostgreSQL exporter uses the built-in pg_dump utility. That means your system needs to have pg_dump installed. (it probably is if you're using postgres).

Edit the config file on the server

sudo nano /etc/backupbird/conf.toml

Insert the following into the configuration file, and add your infomation. This will backup all databases and collections

[[database]]
driver = "postgres"
hostname = "127.0.0.1"
database = "postgres"
port = "5432"

Since pg_dump doesn't allows running with password and user specific authentication, you will need to add a /root/.pgpass for the account, that will run the backup program, since the program is running as root.
Read more about the /root/.pgpass file here.

If you're having problem. Just write to us at support@backupbird.com

Related articles :

Linux server backup