Re: Backup & Restore

Marcelo Pereira <gandalf(at)sum(dot)desktop(dot)com(dot)br> writes:

> Hello All,
>
> Which is the simplest way to do a backup? My db is really small (about
> 4Mb), so I would like to make a backup to each day, save it in separated
> files, and restore it if necessary.
>
> So, which is the usual way to create the backup files? And how can I
> restore these backups?

The simplest way is to run pg_dump from a cron job and redirect the
output to a file. You can name the file whatever you want. The
output of pg_dump is SQL that will create and populate your database.

To restore, feed the dump file to 'psql'.

Note that if you're using large objects it gets a little more
complicated and you have to use 'pg_restore' rather than 'psql' for
restores.

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
--T. J. Jackson, 1863