Re: Missing important information in backup.sgml

From: "Gunnar \"Nick\" Bluth" <gunnar(dot)bluth(at)pro-open(dot)de>
To: Kevin Grittner <kgrittn(at)gmail(dot)com>
Cc: "pgsql-docs(at)postgresql(dot)org" <pgsql-docs(at)postgresql(dot)org>, Stephen Frost <sfrost(at)snowman(dot)net>
Subject: Re: Missing important information in backup.sgml
Date: 2016-11-23 20:35:18
Message-ID: 2f2a85c0-9590-cece-2187-0e50378f74ea@pro-open.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-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(dot)bluth(at)pro-open(dot)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

Attachment Content-Type Size
0x3289338C.asc application/pgp-keys 1.7 KB

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Stephen Frost 2016-11-23 20:41:39 Re: Missing important information in backup.sgml
Previous Message Gunnar "Nick" Bluth 2016-11-23 20:12:56 Re: Missing important information in backup.sgml