Re: [DOCS] Missing important information in backup.sgml

2016-11-29 Thread Gunnar "Nick" Bluth
Am 29.11.2016 um 14:43 schrieb Stephen Frost: > Greetings, > > * Gunnar "Nick" Bluth (gunnar.bl...@pro-open.de) wrote: >> Am 23.11.2016 um 21:41 schrieb Stephen Frost: >>> * Gunnar "Nick" Bluth (gunnar.bl...@pro-open.de) wrote: >>> One of the very important things that should be done as part of a

Re: [DOCS] Missing important information in backup.sgml

2016-11-29 Thread Stephen Frost
Greetings, * Gunnar "Nick" Bluth (gunnar.bl...@pro-open.de) wrote: > Am 23.11.2016 um 21:41 schrieb Stephen Frost: > > * Gunnar "Nick" Bluth (gunnar.bl...@pro-open.de) wrote: > > One of the very important things that should be done as part of a backup > > is to ensure that all of the archive files

Re: [DOCS] Missing important information in backup.sgml

2016-11-29 Thread Gunnar "Nick" Bluth
Am 23.11.2016 um 21:41 schrieb Stephen Frost: > Greetings, Greetings, and excuse my persistence on this ;-), > * Gunnar "Nick" Bluth (gunnar.bl...@pro-open.de) wrote: >> Now, what could happen is -- discussion of different disaster scenarios, boiling down to a differing definition of the term "d

Re: [DOCS] Missing important information in backup.sgml

2016-11-23 Thread Kevin Grittner
On Wed, Nov 23, 2016 at 2:12 PM, Gunnar "Nick" Bluth wrote: > Am 23.11.2016 um 20:21 schrieb Kevin Grittner: >> On Wed, Nov 23, 2016 at 12:24 PM, Gunnar "Nick" Bluth >> wrote: >>> to get actual _data loss_, you'd have to have a power outage in >>> the DC caused by your PG server exploding... >

Re: [DOCS] Missing important information in backup.sgml

2016-11-23 Thread Stephen Frost
Greetings, * Gunnar "Nick" Bluth (gunnar.bl...@pro-open.de) wrote: > Now, what could happen is All you need is for the archive server to be reset at the wrong time (and there are a lot of potential "wrong times" to choose from) and you'll end up with an incomplete archive. > a) complete DC power

Re: [DOCS] Missing important information in backup.sgml

2016-11-23 Thread Gunnar "Nick" Bluth
Am 23.11.2016 um 21:12 schrieb Gunnar "Nick" Bluth: > Assertions (that I take as givens for anyone valueing his data...): > - you have decent HW (BBU controller, HDD cache off, ECC RAM, redundant > PSUs, ...) > - you have a decent DC (UPS, AC, ...) Erm... on rereading my own shit^H^H^H^Hmail... t

Re: [DOCS] Missing important information in backup.sgml

2016-11-23 Thread Gunnar "Nick" Bluth
Am 23.11.2016 um 20:21 schrieb Kevin Grittner: > On Wed, Nov 23, 2016 at 12:24 PM, Gunnar "Nick" Bluth > wrote: > >> mentions Stephen's >> remarks on rsync (although to get actual _data loss_, you'd have to have >> a power outage in the DC caused by your PG server exploding... ;-). > > I have se

Re: [DOCS] Missing important information in backup.sgml

2016-11-23 Thread Kevin Grittner
On Wed, Nov 23, 2016 at 12:24 PM, Gunnar "Nick" Bluth wrote: > mentions Stephen's > remarks on rsync (although to get actual _data loss_, you'd have to have > a power outage in the DC caused by your PG server exploding... ;-). I have seen power loss between the UPS and a server; including a tech

Re: [DOCS] Missing important information in backup.sgml

2016-11-23 Thread Gunnar "Nick" Bluth
Am 16.11.2016 um 22:07 schrieb Gunnar "Nick" Bluth: > Am 16.11.2016 um 15:36 schrieb Stephen Frost: >> Gunnar, all, >> >> * Gunnar "Nick" Bluth (gunnar.bluth.ext...@elster.de) wrote: >>> Am 16.11.2016 um 11:37 schrieb Gunnar "Nick" Bluth: I ran into this issue (see patch) a few times over the

Re: [DOCS] Missing important information in backup.sgml

2016-11-16 Thread Gunnar "Nick" Bluth
Am 16.11.2016 um 15:36 schrieb Stephen Frost: > Gunnar, all, > > * Gunnar "Nick" Bluth (gunnar.bluth.ext...@elster.de) wrote: >> Am 16.11.2016 um 11:37 schrieb Gunnar "Nick" Bluth: >>> I ran into this issue (see patch) a few times over the past years, and >>> tend to forget it again (sigh!). Today

Re: [DOCS] Missing important information in backup.sgml

2016-11-16 Thread Stephen Frost
Gunnar, all, * Gunnar "Nick" Bluth (gunnar.bluth.ext...@elster.de) wrote: > Am 16.11.2016 um 11:37 schrieb Gunnar "Nick" Bluth: > > I ran into this issue (see patch) a few times over the past years, and > > tend to forget it again (sigh!). Today I had to clean up a few hundred > > GB of unarchived

Re: [DOCS] Missing important information in backup.sgml

2016-11-16 Thread Gunnar "Nick" Bluth
Am 16.11.2016 um 11:37 schrieb Gunnar "Nick" Bluth: > Hi, > > I ran into this issue (see patch) a few times over the past years, and > tend to forget it again (sigh!). Today I had to clean up a few hundred > GB of unarchived WALs, so I decided to write a patch for the > documentation this time. U

[DOCS] Missing important information in backup.sgml

2016-11-16 Thread Gunnar "Nick" Bluth
Hi, I ran into this issue (see patch) a few times over the past years, and tend to forget it again (sigh!). Today I had to clean up a few hundred GB of unarchived WALs, so I decided to write a patch for the documentation this time. diff --git a/doc/src/sgml/backup.sgml b/doc/src/sgml/backup.sgml