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
>
>
>