Using rsnapshot for daily PostgreSQL backups
Having done backups for MySQL using rsnapshot before I recently had to do the same thing for PostgreSQL. Turns out PostgreSQL has similar tools to do this and it’s actually quite easy to set it up. First, assuming rsnapshot will run under the root user you’ll need to create a .pgpass file at /root/.pgpass that …