From: Gunnar \"Nick\" Bluth <gunnar.bluth@pro-open.de>
To: Kevin Grittner <kgrittn@gmail.com>
Cc: pgsql-docs@postgresql.org <pgsql-docs@postgresql.org>
Cc: Stephen Frost <sfrost@snowman.net>
Subject: Re: Missing important information in backup.sgml
Date: Wed, 23 Nov 2016 21:35:18 +0100
Message-ID: <2f2a85c0-9590-cece-2187-0e50378f74ea@pro-open.de> (raw)
In-Reply-To: <a5a614b8-9ce2-ae3b-1141-c09e391cbba2@pro-open.de>
References: <cb648ec1-5212-60c5-b73a-9572d21b2ae9@elster.de>
<cec57bd3-3742-9bae-a76f-f3414dcf135e@elster.de>
<20161116143651.GC13284@tamriel.snowman.net>
<80e18b98-9b72-ddee-2a34-76302e5d8a0b@pro-open.de>
<cd880db6-1ff6-8fa7-4868-249421cd6fb2@pro-open.de>
<CACjxUsMAoDNAMvE_bHpb0OzoamVDk93fESGMOfv_aR6E-Q6vUg@mail.gmail.com>
<a5a614b8-9ce2-ae3b-1141-c09e391cbba2@pro-open.de>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-docs>
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 place
> - your archive server is in the same DC (potentially the same machine as
> the DB server)
> - (in case of SAN) your storage correctly reports when it has written to
> disk/BBU cache
> - your OS (and/or archive_script) does not report RC=0 before all data
> has been _transmitted_ (think MongoDB... ;-)
> - (for the sake of completeness) fsync=on 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,
--
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
Attachments:
0x3289338C.asc (application/pgp-keys, 1.7K) download
signature.asc (application/pgp-signature, 472B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: gunnar.bluth@pro-open.de, kgrittn@gmail.com, sfrost@snowman.net
Subject: Re: Missing important information in backup.sgml
In-Reply-To: <2f2a85c0-9590-cece-2187-0e50378f74ea@pro-open.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox