On Fri, Feb 12, 2010 at 6:14 PM, Heikki Linnakangas
> So the new layout would be:
> III. Server Administration
> 21. Managing Databases
> 22. Localization
> 23. Routine Database Maintenance Tasks
> 24. Backup and Restore
> 25. High Availability, Load Balancing, and Replication
> * 26. Recovery Configuration *
> 27. Monitoring Database Activity
> 28. Monitoring Disk Usage
> 29. Reliability and the Write-Ahead Log
> 30. Regression Tests
> Thoughts, better ideas?
> Another change I'd like to make is to document the new built-in way (ie.
> standby_mode='on', restore_command='cp ...', primary_conninfo not set)
> as the primary way of implementing file-based log shipping. Using
> pg_standby or similar scripts that do the waiting would still be
> documented, but I'd like to de-emphasize it, moving it into an
> "Alternative way to implement File-based log shipping" section. The
> description would go along the lines of "An alternative way to implement
> File-based log shipping is to leave standby_mode='false', and use a
> restore_command that waits until the next WAL file arrives. This offers
> more flexibility and control over the process. ..."
We might need to add the following code of pg_standby into the core,
to prefer it for many cases.
> #ifdef WIN32
> * Windows 'cp' sets the final file size before the copy is
> * complete, and not yet ready to be opened by pg_standby. So we
> * wait for sleeptime secs before attempting to restore. If that
> * is not enough, we will rely on the retry/holdoff mechanism.
> * GNUWin32's cp does not have this problem.
> pg_usleep(sleeptime * 1000000L);
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center
In response to
pgsql-docs by date
|Next:||From: Heikki Linnakangas||Date: 2010-02-12 10:15:31|
|Subject: Re: Streaming Replication docs|
|Previous:||From: Heikki Linnakangas||Date: 2010-02-12 09:14:18|
|Subject: Streaming Replication docs|
pgsql-hackers by date
|Next:||From: Dimitri Fontaine||Date: 2010-02-12 10:09:44|
|Subject: Re: Parameter name standby_mode|
|Previous:||From: Heikki Linnakangas||Date: 2010-02-12 09:54:10|
|Subject: Re: testing cvs HEAD - HS/SR - cannot stat|