Re: BAcking up a Postgres Database - Mailing list pgsql-admin

From Ragnar Kjørstad
Subject Re: BAcking up a Postgres Database
Date
Msg-id 20010111090336.A21679@vestdata.no
Whole thread Raw
In response to BAcking up a Postgres Database  (D Johnson <dspectra@home.com>)
List pgsql-admin
On Wed, Jan 10, 2001 at 05:57:21AM -0600, D Johnson wrote:
> Will the postgres community ever consider creating a decent backup
> capability. Currently the way to create backups is through a Cron job.
> For Postgres to ever be considered a true production systen then some
> sort of transactional tracing has to be done. Otherwise you risk the
> potential of losing quite a bit of data.


You can take a snapshot of the database-device (while the database is
down), and backup from the snapshot to avoid this problem.

You need a volum-manager that support snapshot, but AFAIK most do.



--
Ragnar Kjørstad
BigStorage

pgsql-admin by date:

Previous
From: "Dr. Hans-Christian Waldmann"
Date:
Subject: Re: BAcking up a Postgres Database
Next
From: "Thomas Heller"
Date:
Subject: FATAL 1: Memory exhausted in AllocSetAlloc()