Re: BAcking up a Postgres Database

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