Re: PITR, checkpoint, and local relations

From: Greg Copeland <greg(at)CopelandConsulting(dot)Net>
To: Andrew Sullivan <andrew(at)libertyrms(dot)info>
Cc: PostgreSQL Hacker <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: PITR, checkpoint, and local relations
Date: 2002-08-06 19:09:20
Message-ID: 1028660961.8190.856.camel@mouse.copelandconsulting.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

When I've seen this done, I've seen DLT's used as they allow for
multiple channels to be streamed to tape at the same time. If your tape
device does not allow for multiple, concurrent input streams, you're
going to have to obtain multiple drives.

Please keep in mind, my DLT experience is limited.

Greg

On Tue, 2002-08-06 at 13:35, Andrew Sullivan wrote:
> On Fri, Aug 02, 2002 at 08:52:27PM -0400, Bruce Momjian wrote:
>
> > But what if you normally continuous LOG to tape, and now you want to
> > backup to tape. You can't use the same tape drive for both operations.
> > Is that typical? I know sites that had only one tape drive that did
> > that.
>
> I have seen such installations. They always seemed like a real false
> economy to me. Tape drives are not so expensive that, if you really
> need to ensure your data is well and truly safe, you can't afford two
> of them. But that's just my 2 cents. (Or, I guess in this case, 4
> cents.)
>
> A
>
> --
> ----
> Andrew Sullivan 87 Mowat Avenue
> Liberty RMS Toronto, Ontario Canada
> <andrew(at)libertyrms(dot)info> M6K 3E3
> +1 416 646 3304 x110
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2002-08-06 20:26:14 Join syntax and join order
Previous Message Amancio Hasty, Jr 2002-08-06 19:00:12 Re: tsearch -- regular expressions?