Re: [HACKERS] Online backup vs Continuous backup

From: "Andrew Dunstan" <andrew(at)dunslane(dot)net>
To: <gsstark(at)mit(dot)edu>
Cc: <pgman(at)candle(dot)pha(dot)pa(dot)us>, <pgsql-hackers(at)postgresql(dot)org>, <pgsql-docs(at)postgresql(dot)org>
Subject: Re: [HACKERS] Online backup vs Continuous backup
Date: 2005-12-27 20:14:55
Message-ID: 41278.68.143.134.146.1135714495.squirrel@www.dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-hackers pgsql-patches

Greg Stark said:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
>
>> I noticed that we are using the term "Online Backup" in our
>> documentation when we are talking about continuous backup and PITR.
>>
>> To me, "online backup" is doing a backup while the system is online
>> (online-backup), and that is accomplished by pg_dump.
>
> Well fwiw what pg_dump does isn't even considered a "backup" at all in
> other systems. It's a "logical export" or something of that sort.
>
> It's not considered a "backup" because it's saving something different
> than the actual physical database. When you restore you get something
> (hopefully) logically equivalent but still physically different.

This seems fairly arbitrary. On that basis anything on a higher level than
dd is not a backup method, ISTM.

cheers

andrew

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Greg Stark 2005-12-27 23:30:08 Re: [HACKERS] Online backup vs Continuous backup
Previous Message Tom Lane 2005-12-27 19:35:59 Re: [HACKERS] Online backup vs Continuous backup

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-12-27 20:51:29 Re: Possible savepoint bug
Previous Message Tom Lane 2005-12-27 19:35:59 Re: [HACKERS] Online backup vs Continuous backup

Browse pgsql-patches by date

  From Date Subject
Next Message Greg Stark 2005-12-27 23:30:08 Re: [HACKERS] Online backup vs Continuous backup
Previous Message Tom Lane 2005-12-27 19:35:59 Re: [HACKERS] Online backup vs Continuous backup