Postgres Pro
Downloads
Home   >   mailing lists

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

From Alvaro Herrera
Subject Re: PITR question with base backup
Date
Msg-id 20081021200951.GC4001@alvh.no-ip.org
Whole thread Raw
In response to PITR question with base backup  ("Scott Whitney" <swhitney@journyx.com>)
Responses Re: PITR question with base backup  ("Scott Whitney" <swhitney@journyx.com>)
List pgsql-admin
Tree view 
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: "Scott Whitney"
Date:
Subject: PITR question with base backup
Next
From: "Scott Whitney"
Date:
Subject: Re: PITR question with base backup