Re: BAcking up a Postgres Database

From: Ragnar Kjørstad <postgres(at)ragnark(dot)vestdata(dot)no>
To: D Johnson <dspectra(at)home(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: BAcking up a Postgres Database
Date: 2001-01-11 08:03:36
Message-ID: 20010111090336.A21679@vestdata.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Halford Dace 2001-01-11 11:10:08 Another backup q
Previous Message Dr. Hans-Christian Waldmann 2001-01-11 07:28:37 Re: BAcking up a Postgres Database