Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1c9eGn-0006QY-JH for pgsql-docs@arkaria.postgresql.org; Wed, 23 Nov 2016 20:35:53 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1c9eGn-00089l-69 for pgsql-docs@arkaria.postgresql.org; Wed, 23 Nov 2016 20:35:53 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1c9eGQ-0007Lv-Ma for pgsql-docs@postgresql.org; Wed, 23 Nov 2016 20:35:30 +0000 Received: from pro-open.de ([87.106.136.39] helo=www.pro-open.de) by makus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1c9eGO-0007h6-AY for pgsql-docs@postgresql.org; Wed, 23 Nov 2016 20:35:29 +0000 Received: from [192.168.178.24] (x2f21b1b.dyn.telefonica.de [2.242.27.27]) by www.pro-open.de (Postfix) with ESMTP id 228EF1045EF3; Wed, 23 Nov 2016 21:35:26 +0100 (CET) Subject: Re: Missing important information in backup.sgml To: Kevin Grittner References: <20161116143651.GC13284@tamriel.snowman.net> <80e18b98-9b72-ddee-2a34-76302e5d8a0b@pro-open.de> Cc: "pgsql-docs@postgresql.org" , Stephen Frost From: "Gunnar \"Nick\" Bluth" Message-ID: <2f2a85c0-9590-cece-2187-0e50378f74ea@pro-open.de> Date: Wed, 23 Nov 2016 21:35:18 +0100 User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:45.0) Gecko/20100101 Thunderbird/45.5.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="oOfESwnG4VxVvVv1NrNkF6FM8WVoMr0P6" X-Pg-Spam-Score: -4.8 (----) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --oOfESwnG4VxVvVv1NrNkF6FM8WVoMr0P6 Content-Type: multipart/mixed; boundary="ATkKuGli2xsrd6GEa9FUbDaAM8SkWQFox"; protected-headers="v1" From: "Gunnar \"Nick\" Bluth" To: Kevin Grittner Cc: "pgsql-docs@postgresql.org" , Stephen Frost Message-ID: <2f2a85c0-9590-cece-2187-0e50378f74ea@pro-open.de> Subject: Re: [DOCS] Missing important information in backup.sgml References: <20161116143651.GC13284@tamriel.snowman.net> <80e18b98-9b72-ddee-2a34-76302e5d8a0b@pro-open.de> In-Reply-To: --ATkKuGli2xsrd6GEa9FUbDaAM8SkWQFox Content-Type: multipart/mixed; boundary="------------43EA5341B3CE4190B8157A57" This is a multi-part message in MIME format. --------------43EA5341B3CE4190B8157A57 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable 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... these two I obviously do not rate as "given for anyone valueing his data": > - you use a single DB server and/or no (synchronous) replication in pla= ce > - your archive server is in the same DC (potentially the same machine a= s > the DB server) > - (in case of SAN) your storage correctly reports when it has written t= o > disk/BBU cache > - your OS (and/or archive_script) does not report RC=3D0 before all dat= a > has been _transmitted_ (think MongoDB... ;-) > - (for the sake of completeness) fsync=3Don for PG Another "funny" occasion btw. was a guy accidentaly pressing stop-A in a SUN F6800 console, and being overly nervous entering "boot"... the POST alone took 40 minutes, and then it started polling the dedicated Clariion II ;-) Cheers, --=20 Gunnar "Nick" Bluth RHCE/SCLA Mobil +49 172 8853339 Email: gunnar.bluth@pro-open.de _____________________________________________________________ In 1984 mainstream users were choosing VMS over UNIX. Ten years later they are choosing Windows over UNIX. What part of that message aren't you getting? - Tom Payne --------------43EA5341B3CE4190B8157A57 Content-Type: application/pgp-keys; name="0x3289338C.asc" Content-Transfer-Encoding: quoted-printable Content-Disposition: attachment; filename="0x3289338C.asc" -----BEGIN PGP PUBLIC KEY BLOCK----- Version: GnuPG v2 mQENBFOuo7ABCADU3rFM4gBv4l/Xjfry27pfdYgvWrcR1RA/vLfOgjqivSbMQEHH bTWprJRjB2EbzmTS+faSa/V+mH/jIKBytCc5+hprBd/m5if3/v2PKA7+MHsy1H9T 7FqTKRccNl7RIcKFOaonIbY4qMyH6cFafZOgqaGlc3ibfX7PiCL+mdl1mPoyWeVR sKoddSobI40noE+se/FrnKZRDRWqqx7zvTRRK9vKUVDFM+Y3Kg3EDL3Qmt3MocM7 FtBZDaeyFZiKdf7bNaWM977aGwiA1gQQp+/TmB1qqSyOTzbPhxfr7G9vWdbVS2ph 80RSrxI/sF3LUNeJtTjB/jtKiG49arBqC1eDABEBAAG0Lkd1bm5hciAiTmljayIg Qmx1dGggPGd1bm5hci5ibHV0aEBwcm8tb3Blbi5kZT6JAT8EEwECACkFAlOuo7AC GyMFCQlmAYAHCwkIBwMCAQYVCAIJCgsEFgIDAQIeAQIXgAAKCRAQEK5rMokzjLin CACaTXqjA7Qc6lpljpz3/5SpmPlvEDdX5mR76jN8326qkSQw7i8WBGW/5NO669OY 4ITlLbu/XL11x6hzCh7ZxMJo3fSYN+fh1tfEnNGw0NjUoy1JdBB+2B3beY+0LEBG ZMm56HZC1u4qZq2drLM+sZIi6f8ML0NCh41s01SeX6hGQ609zCcFRNNk98pXOBER a2kDi9wn1UvK1tECxCXuiO6HhPzhme/nFAxoBdBdATCl5EEnnLD+JfhSr2LShgXu LQxJA6odvggfDVlS913rb0zDtV6s+6bfR+qmD4igBgC6Xl8ceDJpbS4ER7Uvw78n Sa2i3Yub28FAGr+RvpFLi9PruQENBFOuo7ABCAC6E2x7GZ1LrIQMlNr2XYvCG9DB p181PJJ95w4BwuaKmFBDHc5tE7p5S2sNfNfYNUjDzpr47lU5+85Ffqtf27gV8Ftd rqv/d2lbH9+w6wShB9QOy11gPPdkB62o9CKwk+XInN2DJITWsgI8hk6NNzbotD27 x7x4fxQxBUE6YkHnJMziqwZ5emLFP0A2XPIDK6tw87UZNOnEaJ9kP3WOKihNOtMq mr7+4BQQCyfj13k32219UZglnHtYaGuNmXOc0KHoFEIA2pkgeXRQShrwz4gdCaSN FUZPAVeeWmdqAmnKKb+Sk7czft/wdtmBD0BykYRoZxQ3JlkHG7oH7wGXmi1TABEB AAGJASUEGAECAA8FAlOuo7ACGwwFCQlmAYAACgkQEBCuazKJM4xN1wf+MPLXrQ10 LBRtYjD16LsvxDyEcSMoWGc26DO/TDsGwme2NVfL0JufExgdpvkk/x4wzBwdkYfF dNKU3CyA+3T4FuKGL7RPrICJa+VdCvwMk8dzLqF0UgdfVHtCnUQoQmNnDD7gODw/ GTIKpWw+iEE2/EANAONXj7EC+VsW895/C5aQEZx++cSonrHFSSIUp1OGJoVlmFnJ MFCTTElmayTcmfOwGHrn97Et5YePMOsyqWZas+URuJveoTdGhDToOIufECGb3WJa J8rFL+ni3NKoiZhZMYVQ+XC8f64Mi5kXlfsylVu6kgCoFqnq7FTpwqOiRml4APeX GBC6uZW6fUGNDQ=3D=3D =3D//tm -----END PGP PUBLIC KEY BLOCK----- --------------43EA5341B3CE4190B8157A57-- --ATkKuGli2xsrd6GEa9FUbDaAM8SkWQFox-- --oOfESwnG4VxVvVv1NrNkF6FM8WVoMr0P6 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iQEcBAEBCAAGBQJYNf2MAAoJEBAQrmsyiTOMTmMIALst9ImgRb2J+lwidIOrXFfj 9ZFfKN4lPXvw1DlHX4kqZ+i8hvlEuEKBe04K8pHB1CwPGPIbE/qVfapeLRCcCnh6 LFzY5PB6o94OQZpHtywQEKRtdfebmiK6svCQLSoOdZhF6OxN+w6EKIjB0ThtA+7+ TJiJfZS50GfciDdUSs3Ku0vtZZM+6+li1fiPfUpVvjIAZXAzOODx9xgznMTnXKWW KgOkOgB9HQT1gN2YTcd503yxITDMe45X6qN6rHCdFJ9B1dimEQU/+SUyJzNdWC7R L76hQTOs8iCxLBDzGVxR7GJaKMF+nbRj+Cf971+KXWhW1AEX6e9bBFxZCC9Q7iE= =A9fC -----END PGP SIGNATURE----- --oOfESwnG4VxVvVv1NrNkF6FM8WVoMr0P6--