Re: PITR question with base backup

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Scott Whitney <swhitney(at)journyx(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: PITR question with base backup
Date: 2008-10-21 20:09:51
Message-ID: 20081021200951.GC4001@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Scott Whitney wrote:

> The problem is that I create databases pretty regularly. Let's say I create
> 3 in a week. I'm not looking forward to going to my colo, grabbing the 20ish
> GB tgz file and restoring it 3 times per week. I'd rather do that dance
> monthly or quarterly and rely on the WALs in the interim.

What's the actual problem? Database creation is also replayed via WAL.

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Whitney 2008-10-21 20:29:52 Re: PITR question with base backup
Previous Message Scott Whitney 2008-10-21 20:02:39 PITR question with base backup