October 2001
Beginner to intermediate
400 pages
7h 45m
English
The most critical component of any database maintenance plan is the database backup and restore procedures. Once again, PostgreSQL makes the administrator’s job easier by providing command-line tools such as pg_dump, pg_dumpall, and pg_restore. Like commands such as vacuumdb, these are especially suited to be run as cron jobs.
By default, pg_dump and pg_dumpall simply dump all output to stdout. However, this can easily be redirected to files using the appropriate UNIX redirection symbols.
>pg_dump newriders > nr.backup
After the command has redirected its output to a standard OS file, standard backup tools can be used to securely archive it.
Here are some factors to consider when trying to evaluate an optimal backup ...
Read now
Unlock full access