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

"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 (view raw or flat)
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

pgsql-hackers by date

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

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