pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Scott Whitney <swhitney@journyx.com>
To: pgsql-admin@postgresql.org
Subject: Re: PITR question with base backup
Date: Tue, 21 Oct 2008 15:29:52 -0500
Message-ID: <20081021202952.C95047E4246@mail.int.journyx.com> (raw)
In-Reply-To: <20081021200951.GC4001@alvh.no-ip.org>

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




view thread (4+ messages)  latest in thread

Message-ID: <20081021202952.C95047E4246@mail.int.journyx.com>
Permalink:  ../20081021202952.C95047E4246@mail.int.journyx.com/
Also on:    postgresql.org/message-id/20081021202952.C95047E4246@mail.int.journyx.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: swhitney@journyx.com
  Subject: Re: PITR question with base backup
  In-Reply-To: <20081021202952.C95047E4246@mail.int.journyx.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox