Re: PITR question with base backup

From: "Scott Whitney" <swhitney(at)journyx(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: PITR question with base backup
Date: 2008-10-21 20:29:52
Message-ID: 20081021202952.C95047E4246@mail.int.journyx.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

It is, is it? I was completely under the impression that it was not. Don't
ask me where I got that impression. :)

No problem whatsoever, in that case!

Thanks for clearing up my inability to comprehend documentation...

-----Original Message-----
From: Alvaro Herrera [mailto:alvherre(at)commandprompt(dot)com]
Sent: Tuesday, October 21, 2008 3:10 PM
To: Scott Whitney
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] PITR question with base backup

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 Tom Lane 2008-10-21 20:55:42 Re: pg_dumpall size twist
Previous Message Alvaro Herrera 2008-10-21 20:09:51 Re: PITR question with base backup