Re: Question about backing up PostgreSQL databases

Well, we currently use pg_dumpall and pipe it to a tar file.  It backups
up all data and the database schema.  So if a database goes down, I can
just pipe that file to pgsql and it will reload everything including all
tables, users, grant rights, etc.

There is also a company called Bakbone software that has a module for
their software that will backup PostgreSQL databases.  You can see it at
their website.  http://www.bakbone.com

Good luck,
Dave

Van L. Loggins wrote:

>What methods are available to easily backup the contents of a PostgreSQL database?
>
>We are in the process of converting over to it from Progress, and we need to figure
>out what our best option is to have a complete backup in case of disaster.
>
>
>Thanks for the input,
>
>Van
>
>
>