PITR Backups

From: Dan Gorman <dgorman(at)hi5(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: PITR Backups
Date: 2007-06-21 23:31:32
Message-ID: 7E0807EE-B970-4869-A248-B838E42AD9EE@hi5.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi -
I'm looking at ways to do clean PITR backups. Currently we're
pg_dumping our data in some cases when compressed is about 100GB.
Needless to say it's slow and IO intensive on both the host and the
backup server.

All of our databases are on NetApp storage and I have been looking
at SnapMirror (PITR RO copy ) and FlexClone (near instant RW volume
replica) for backing up our databases. The problem is because there
is no write-suspend or even a 'hot backup mode' for postgres it's
very plausible that the database has data in RAM that hasn't been
written and will corrupt the data. NetApp suggested that if we do a
SnapMirror, we do a couple in succession ( < 1s) so should one be
corrupt, we try the next one. They said oracle does something similar.

Is there a better way to quiesce the database without shutting it
down? Some of our databases are doing about 250,000 commits/min.

Best Regards,
Dan Gorman

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2007-06-22 00:26:45 Re: PITR Backups
Previous Message Joshua D. Drake 2007-06-21 23:24:56 Re: Performance query about large tables, lots of concurrent access