Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-docspgsql-hackerspgsql-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

pgsql-docs by date

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

pgsql-hackers by date

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

pgsql-patches by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group