Re: [HACKERS] Streaming Replication docs

2010-02-19 Thread Heikki Linnakangas
Joshua D. Drake wrote: On Fri, 2010-02-12 at 10:22 -0800, Josh Berkus wrote: In addition to the changes you've proposed, one thing our docs could really use is a single reference page which we could go to for all of the .conf files. Right now, you need to rely on postgresql.org doc search in

Re: [HACKERS] Streaming Replication docs

2010-02-14 Thread Josh Berkus
On 2/13/10 10:17 AM, Greg Stark wrote: But having the separate recovery.conf seems kind of pointless legacy structure at this point. Agreed, but I've been trying to minimize my tinkering with HS/SR. Several things would need to be changed to get rid of Recovery.conf for HS and PITR. I expect

Re: [HACKERS] Streaming Replication docs

2010-02-14 Thread Peter Eisentraut
On fre, 2010-02-12 at 11:14 +0200, Heikki Linnakangas wrote: 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,

Re: [HACKERS] Streaming Replication docs

2010-02-13 Thread Greg Stark
On Fri, Feb 12, 2010 at 9:14 AM, Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote: One glaring issue with the current documentation layout is that the documentation for the various options in recovery.conf is split in two places. I've been trying to explain to someone how to set

[HACKERS] Streaming Replication docs

2010-02-12 Thread Heikki Linnakangas
One glaring issue with the current documentation layout is that the documentation for the various options in recovery.conf is split in two places. The old options, restore_command, recovery_target_* and so forth are in section 24.3.3.1 Recovery Settings, while the new streaming replication related

Re: [HACKERS] Streaming Replication docs

2010-02-12 Thread Fujii Masao
On Fri, Feb 12, 2010 at 6:14 PM, Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote: 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

Re: [HACKERS] Streaming Replication docs

2010-02-12 Thread Heikki Linnakangas
Fujii Masao wrote: 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

Re: [HACKERS] Streaming Replication docs

2010-02-12 Thread Fujii Masao
On Fri, Feb 12, 2010 at 7:15 PM, Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote: That's actually a bit questionable, always has been even in pg_standby. It adds a constant 1 s delay to the recovery each WAL file, which effectively rate-limits the WAL recovery to 16MB per second. I

Re: [HACKERS] Streaming Replication docs

2010-02-12 Thread Josh Berkus
On 2/12/10 1:14 AM, Heikki Linnakangas wrote: It's pretty clear that we should have a single place that documents all the recovery.conf options. I suggest that we move the 24.3.3.1 Recovery Settings section after High Availability, Load Balancing, and Replication, and add the new streaming

Re: [HACKERS] Streaming Replication docs

2010-02-12 Thread Josh Berkus
Heikki, Crossing this thread over to pgsql-docs, where I think it actually belongs. In addition to the changes you've proposed, one thing our docs could really use is a single reference page which we could go to for all of the .conf files. Right now, you need to rely on postgresql.org doc

Re: [HACKERS] Streaming Replication docs

2010-02-12 Thread Joshua D. Drake
On Fri, 2010-02-12 at 10:22 -0800, Josh Berkus wrote: Heikki, Crossing this thread over to pgsql-docs, where I think it actually belongs. In addition to the changes you've proposed, one thing our docs could really use is a single reference page which we could go to for all of the .conf