Re: PITR question with base backup - Mailing list pgsql-admin

From Scott Whitney
Subject Re: PITR question with base backup
Date
Msg-id 20081021202952.C95047E4246@mail.int.journyx.com
Whole thread Raw
In response to Re: PITR question with base backup  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: PITR question with base backup  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List 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@commandprompt.com]
Sent: Tuesday, October 21, 2008 3:10 PM
To: Scott Whitney
Cc: pgsql-admin@postgresql.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


pgsql-admin by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: PITR question with base backup
Next
From: Tom Lane
Date:
Subject: Re: pg_dumpall size twist