Re: "hot standby" system

Ühel kenal päeval, R, 2006-07-21 kell 20:00, kirjutas Chris Campbell:
> 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.

We have written a management script that manages the setup und failover
procedures. It is a part of the SkyTools package we announced at the
postgresql conference in Toronto.

We failed to put it up on PgFoundry during the code sprint (it took a
whole day to enable the project there :( ) and have not had enough time
to do it after coming back. But it will be on PgFoundry eventually.

Marko has the details if you need it faster

-- 
----------------
Hannu Krosing
Database Architect
Skype Technologies OÜ
Akadeemia tee 21 F, Tallinn, 12618, Estonia

Skype me:  callto:hkrosing
Get Skype for free:  http://www.skype.com