Re: warm database, tape device backup

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: milos(dot)babic(at)gmail(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: warm database, tape device backup
Date: 2009-02-06 14:25:47
Message-ID: 200902061425.n16EPlW09408@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

milos(dot)babic(at)gmail(dot)com wrote:
> Hi!
>
> I have few question regarding new PostgreSQL database installation.
>
> The potential installation will have to manage over 1.5 TB of data.
>
> Since our customers have an increasing demand for high availability, we
> decided to try with PostgreSQL's concept of warm standby database
> (http://www.postgresql.org/docs/8.3/static/warm-standby.html)
>
> Apart from having a standby database, we MUST HAVE an enterprise class
> reliable backup soltuion and the backup is our major concern now.
>
> My first question is: is there any commercial solution for on-line backup
> directly to tape device, eg like HP Data Protector or EMC NetWorker
> module for Oracle?

Can you just open the tape drive in append mode and keep writing to it
as a file?

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jennifer Trey 2009-02-06 14:26:01 How do I turn on query logger?
Previous Message Oleg Bartunov 2009-02-06 14:20:53 Re: Searching a gin index