|
Home > Archive > PostgreSQL Documentation > December 2005 > Online backup vs Continuous backup
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Online backup vs Continuous backup
|
|
| Bruce Momjian 2005-12-26, 1:23 pm |
| 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. I know a lot of
databases us "Online Backup" but I assume this is for historical reasons
because at some time in the past their full backups didn't work while
the database was online. Other systems use the term "Continuous
Logging", but I think that is too easily confused with the server
activity logs.
I suggest the following patch to rename our capability "Continuous
Backup".
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| |
| Tom Lane 2005-12-26, 1:23 pm |
| Bruce Momjian <pgman@candle.pha.pa.us> writes:
> I suggest the following patch to rename our capability "Continuous
> Backup".
This doesn't seem like an improvement. "Online backup" is the standard
terminology AFAIK.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly
| |
| Bruce Momjian 2005-12-26, 1:23 pm |
| Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
>
> This doesn't seem like an improvement. "Online backup" is the standard
> terminology AFAIK.
But why is it the standard terminology? It doesn't seem logical.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
| |
| Christopher Browne 2005-12-28, 3:24 am |
| > Bruce Momjian <pgman@candle.pha.pa.us> writes:
>
> This doesn't seem like an improvement. "Online backup" is the standard
> terminology AFAIK.
There's something ambiguous about it, in view that there are two
useful points in time for a backup to be "as of," namely:
a) The start time (which is what pg_dump does), and
b) The end time (which I believe is not uncommon with other systems).
PITR is obviously more like b)...
--
wm(X,Y):- write(X),write('@'),
write(Y). wm('cbbrowne','gmail
.com').
http://linuxfinances.info/info/slony.html
Keeping instructions and operands in different memories saves .20
(.09) microseconds.
|
|
|
|
|