From: Chris Ruprecht <chris@ruprecht.org>
To: pgsql-admin@postgresql.org
Subject: How to do fast, reliable backups?
Date: Fri, 5 Mar 2004 16:37:42 -0500
Message-ID: <200403051637.42457.chris@ruprecht.org> (raw)
Hi all,
I am wondering how you guys back up your databases. Say, I have a 20 GB
database, data and indexes. If I run pg_dump on this, it backs up the schema
and the data. When I have to restore this, I whould have to run this through
psql which would then re-build the indexes after it has inserted the records.
That's not really a feasable option as it takes too long.
If I back up the pgdata directory, I will get inconsistent data, as somebody
might update data in 2 tables while my backup is running, one change in a
table I have already backed up, one in a table I have not. The solution would
be to shut the database server down, do the backup and then start everything
back up. But that's not really an option in a 24/7 environment.
What I'd like to see is a transaction aware backup which backs up indexes as
well as data.
Any ideas?
Best regards,
Chris
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: chris@ruprecht.org
Subject: Re: How to do fast, reliable backups?
In-Reply-To: <200403051637.42457.chris@ruprecht.org>
References: <200403051637.42457.chris@ruprecht.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox