Re: Hot Backup - Mailing list pgsql-general

From Shridhar Daithankar
Subject Re: Hot Backup
Date
Msg-id 3DA33053.10064.158E04DA@localhost
Whole thread Raw
In response to Re: Hot Backup  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-general
On 8 Oct 2002 at 9:40, Robert Treat wrote:
> Is it me or do doomsdays scenarios sometimes seem a little silly? I'd
> like to ask just where are you storing your "incremental backups" with
> Oracle/m$ sql ?? If it's on the same drive, then when you drive craps
> out you've lost the incremental backups as well.  Are you putting them
> on a different drive (you can do that with the WAL) you'd still have the
> problem that if the building went up in smoke you'd lose that
> incremental backup. Unless you are doing "incremental backups" to a
> computer in another physical location, you still fail all of your
> scenarios.

Well, all I can say is having a sync'ed and replicated database ssytem is good.
Either from load sharing point of view or from fail over point.

Forget backup. If you are upto restoring from backup, doesn't matter most of
the times whether you are restoring from dump or cycling thr. thousands of WAL
files..

> This type of scenario sounds as good as the above mentioned methods for
> oracle/m$ server. Could you post your pdf? Seems like it might be worth
> adding to the techdocs site.

Well, I found it googling around. Se if this helps...I have posted this before
dunno which list. This crosposting habit of PG lists made me to lose tracks of
where things originated and where they ended.. Not that it's bad..

HTH
Bye
 Shridhar

--
like:    When being alive at the same time is a wonderful coincidence.


Attachment

pgsql-general by date:

Previous
From: Robert Treat
Date:
Subject: Re: Hot Backup
Next
From: Robert Treat
Date:
Subject: Re: How to find out about index