| From: | "David C(dot) Brown" <dbrown(at)centennialwines(dot)com> |
|---|---|
| To: | "Van L(dot) Loggins" <vloggins(at)turbocorp(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Question about backing up PostgreSQL databases |
| Date: | 2003-12-17 17:29:42 |
| Message-ID: | 3FE09286.9040304@centennialwines.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Anjan Dave | 2003-12-17 17:47:45 | GRANT in pg7.2 |
| Previous Message | Sai Hertz And Control Systems | 2003-12-17 17:24:37 | Re: Question about backing up PostgreSQL databases |