Re: PITR Backups - Mailing list pgsql-performance

From Simon Riggs
Subject Re: PITR Backups
Date
Msg-id 1182512289.9276.220.camel@silverbirch.site
Whole thread Raw
In response to Re: PITR Backups  (Dan Gorman <dgorman@hi5.com>)
Responses Re: PITR Backups  (Dan Gorman <dgorman@hi5.com>)
List pgsql-performance
On Fri, 2007-06-22 at 04:10 -0700, Dan Gorman wrote:
> This snapshot is done at the LUN (filer) level, postgres is un-aware
> we're creating a backup, so I'm not sure how pg_start_backup() plays
> into this ...

Postgres *is* completely unaware that you intend to take a backup, that
is *exactly* why you must tell the server you intend to make a backup,
using pg_start_backup() and pg_stop_backup(). That way Postgres will
flush its buffers, so that they are present on storage when you make the
backup.

Is the procedure for Oracle or any other transactional RDBMS any
different?

--
  Simon Riggs
  EnterpriseDB   http://www.enterprisedb.com



pgsql-performance by date:

Previous
From: Dan Gorman
Date:
Subject: Re: PITR Backups
Next
From: Dan Gorman
Date:
Subject: Re: PITR Backups