"hot standby" system

From: Chris Campbell <chris(at)bignerdranch(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: "hot standby" system
Date: 2006-07-22 00:00:24
Message-ID: 1DC92E46-F4FB-43EA-9993-A63728A361A9@bignerdranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

The documentation [1] says this about On-line backup and point-in-
time recovery:

> If we continuously feed the series of WAL files to another machine
> that has been loaded with the same base backup file, we have a "hot
> standby" system: at any point we can bring up the second machine
> and it will have a nearly-current copy of the database.

Is this possible today in a stable and robust way? If so, can we
document the procedure? If not, should we alter the documentation so
it's not misleading? I've had several people ask me where to enable
the "hot standby" feature, not realizing that PostgreSQL only has
some of the raw materials that could be used to architect such a thing.

Thanks!

- Chris

[1] http://www.postgresql.org/docs/8.1/interactive/backup-online.html

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joshua D. Drake 2006-07-22 00:49:01 Re: "hot standby" system
Previous Message Peter Eisentraut 2006-07-21 23:39:20 Re: [PATCHES] Generic Monitoring Framework with DTrace patch