Overview

pg_backall
==========

Automated compressed dumps for PostgreSQL local and remote databases.

Inspired by http://codeidol.com/unix/bsd/Backing-Up/Automate-Data-Dumps-for-PostgreSQL-Databases/

Dependencies:
-------------

- Python 2.6
- psql and pg_dump command line utilities. Most *NIX package managers call it postgresql-client

Tested on:
----------

- Gentoo Linux ~x86
- DragonFly BSD 2.9-DEVELOPMENT

Examples:
---------

- Using default options (localhost, postgres, empty password)

::

    # pg_backall
    PostgreSQL server password for user postgres:

It will allways ask for the password if not passed as an argument.

- Custom options

::

    # pg_backall -U pgsql -H XXX.XXX.XXX.XXX -P XXXX -W XXXXXXX -O /output/path

- Setting up a periodic backup policy for local server

Paths are examples. User running pg_backall must have write permissions on -O

::

    # mkdir /var/pg_backall
    # chown postgres:postgres /var/pg_backall
    # su - postgres
    # crontab -e ## add the following entry to crontab and save
    0  4  *  *  0  pg_backall -U posgres -O /var/pg_backall -H 127.0.0.1 -W pwd

Getting/Giving help:
--------------------

sebasmagri@gmail.com