Re: 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