Re: Question about backing up PostgreSQL databases - Mailing list pgsql-admin

From David C. Brown
Subject Re: Question about backing up PostgreSQL databases
Date
Msg-id 3FE09286.9040304@centennialwines.com
Whole thread Raw
In response to Question about backing up PostgreSQL databases  ("Van L. Loggins" <vloggins@turbocorp.com>)
List pgsql-admin
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
>
>
>


pgsql-admin by date:

Previous
From: Sai Hertz And Control Systems
Date:
Subject: Re: Question about backing up PostgreSQL databases
Next
From: "Anjan Dave"
Date:
Subject: GRANT in pg7.2