Re: hot backup

From: Jeff Frost <jeff(at)frostconsultingllc(dot)com>
To: Steulet Grégory <Gregory(dot)Steulet(at)he-arc(dot)ch>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: hot backup
Date: 2005-08-05 05:25:47
Message-ID: Pine.LNX.4.63.0508042223250.4931@discord.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

This message is in MIME format. The first part should be readable text,
while the remaining parts are likely unreadable without MIME-aware tools.

---481964751-187987940-1123219547=:4931
Content-Type: TEXT/PLAIN; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8BIT

On Wed, 3 Aug 2005, Steulet Grégory wrote:

> I just would like to know if it's possible to dot hot backup(not dump) with
> postgres.

That probably depends what you define as a hot backup. Likely what you are
looking for is Point in Time Recovery through WAL archiving. Read about it
here:

http://www.postgresql.org/docs/8.0/interactive/backup-online.html

--
Jeff Frost, Owner <jeff(at)frostconsultingllc(dot)com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---481964751-187987940-1123219547=:4931--

In response to

  • hot backup at 2005-08-03 08:46:34 from Steulet Grégory

Browse pgsql-admin by date

  From Date Subject
Next Message Aljaž Bizjak Zupanc 2005-08-05 06:30:15 Re: Data integrity check when bad sectors occur
Previous Message Scott Barvick 2005-08-04 22:52:05 Re: Vacuum doesn't end