Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VoEP6-0008Fn-UB for pgsql-hackers@arkaria.postgresql.org; Wed, 04 Dec 2013 15:30:21 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VoEP6-0003cO-7Q for pgsql-hackers@arkaria.postgresql.org; Wed, 04 Dec 2013 15:30:20 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VoEP4-0003aC-Ez for pgsql-hackers@postgresql.org; Wed, 04 Dec 2013 15:30:18 +0000 Received: from moutng.kundenserver.de ([212.227.126.187]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VoEOx-0004yL-Nb for pgsql-hackers@postgresql.org; Wed, 04 Dec 2013 15:30:17 +0000 Received: from localhost (mnsr-d9bf4479.pool.mediaWays.net [217.191.68.121]) by mrelayeu.kundenserver.de (node=mreu3) with ESMTP (Nemesis) id 0MJIXG-1VlTF31cMc-002udG; Wed, 04 Dec 2013 16:30:03 +0100 Date: Wed, 4 Dec 2013 16:29:02 +0100 From: Christian Kruse To: Kevin Grittner Cc: Robert Haas , =?iso-8859-15?Q?Fabr=EDzio?= Mello , Pgsql Hackers Subject: Re: Time-Delayed Standbys Message-ID: <20131204152902.GA22617@achilles.fritz.box> References: <52984711.8040806@lab.ntt.co.jp> <20131203163302.GA18669@achilles.fritz.box> <1386170522.33753.YahooMailNeo@web162901.mail.bf1.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="M9NhX3UHpAaciwkO" Content-Disposition: inline In-Reply-To: <1386170522.33753.YahooMailNeo@web162901.mail.bf1.yahoo.com> User-Agent: Mutt/1.5.22 (2013-10-16) X-Provags-ID: V02:K0:SuqZzCEt8WFHp/lOqG81XSKQ09TDrqvSIXtFURBPmoK iD4412eO5Sc5123shEuyhHTJn+9hhQBpVOPCVyLzAWE7yoBVDk RpTnwd+Qk8nQcC1gAhJ7vcd/NrblmXi+svqDp9+KS8uVv5/DaY qQbf7SrRYYBSGON51dvAJbsLtOH0HT3wLUNM8O0+BOZMkOvam7 s+CmncKgGtaKUglbvT2sN1egzzfRpGtzeyg3IJ/PJzUYa8C1m2 52RTFNaxApapunzCAg/06ylUhE4Fzh8Nx27aqNwYDBWcNMGooI 5uetFNc12L34NBSeTFZXL6Qasn/xq+4yJXqLQJlIKvOcwwHa+W j8F0hmDgexoXToewGmRml2QzO3noDTlectxeBa4Ia X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org --M9NhX3UHpAaciwkO Content-Type: text/plain; charset=iso-8859-15 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Hi, On 04/12/13 07:22, Kevin Grittner wrote: > There are many things that a system admin can get wrong.=A0 Failing > to supply this feature because the sysadmin might not be running > ntpd (or equivalent) correctly seems to me to be like not having > the software do fsync because the sysadmin might not have turned > off write-back buffering on drives without persistent storage.=20 > Either way, poor system management can defeat the feature.=A0 Either > way, I see no reason to withhold the feature from those who manage > their systems in a sane fashion. I agree. But maybe we should add a warning in the documentation about time syncing? Greetings, CK --=20 Christian Kruse http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services --M9NhX3UHpAaciwkO Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.22 (GNU/Linux) Comment: GPGTools - http://gpgtools.org iQQcBAEBCAAGBQJSn0o9AAoJEEnjDsXITviXiY4gAK+HnVb7fruk3H8mLRiZl7sP XVmMzdjLHN0Svk979LMuYpul6QYQdAIusLTu3qRh9hPXviuJWvxlYlwXfnlNg6LC Q69Fafp29sNWcX4I5RX1LWe+ysVjTgqhh2OogK2x75ttnbzF4IcCmSyi8cCQRQ7A jHPvWS4TDx1R153csytvGXz4jZEoPhNCvGyUOoR1ngy+j2FCWz+fv3eSt8mU0m3y UZBOhtitvsthNTE4iBdqibpEBJCb83dD1r7Xsb1aViTUsliDoI5nET7wc07aMZFt 2OJ2SVtD66w05sySgwa0gUlz/gNhL8xCh/kq/PZjF4QqeM5008N30V+bx01/n7+y 8xyVtM/FoNg/Cv+yLApOrInxgNMekD5FWcN16IotDVlquTledZVc+lNFd+ZPuqz1 dMETS5NnmZdN7242gK+jUmuQGVCDWDE2D9h0G4gekh8Pv6ard+SHfP7Japw4Kf4Q boeo8hVBm+vKA25Y+TBI46iNufyXdpA4xQ58hRWqV/JFCuAaUsdG+6UT/r373Ian tKnGPS6Qy/xEuMz6imRTlAfhhnuVzsp19KGA9Dtz9O84P/KUswqj2MyZOfaC3xUU CCFFITpb+CE9wpz1jSwhctF3oM0OFeG1fMCb2A+8hsWK3VPNEZlkt4x+b+J0vKX4 tb/PLzS9sITfh01FNGLXM6YAF+DHVJ1aW6uTt4v4/VtIaFI1d3/6JfnlVIFtWDNu yR2Jxj3Fkckg/2AckiMtR0cIcX3oJff4K1n4w4hayH+DTRarwvsr8k8Z2yC2XGsZ r99O9z0zgz1JjDG8kDcrVTBi1vx02DwRI7AbOqVebu9plkU6hXYi2synftI93xeV WQ8Jp0r8UQEowsyTKny1k7hyFpmvw7Ue9fPkjy35ja3g8XtjgiFECFTJQ5XwTgWB esql26lC9Wu/6KKBFEP3mrNvLOoD4yyB7J9mtxw5mtFPk3vg25dF4OBpNAvqR1u4 6eyAINFQXrvFmMkLeLC+aP+oBoJmN9PxoBlomkY2pKY82h7AKLFkxf4rqrMYKbL/ 3EIG7cD0/9lnL0p7iegM20sT8tEeScwjAq95UJHB0Dw3Wv2UVIny56XRoLRe8xlu tP/S5Z1EwHq4vSTQVaZosdSsiYxTHmCNVHQFfwYbSPRoGvZ+PP/+JJ+fvgHs9j1Y uK5UaNdORgYo3xiDJPsMIePWl99axvDmLn066pBdqRnLiI7hcNGpuoEiUvXvWQRP ZgA13ot2sNl0cAr0Q+GuflwpIA7LSCQ9poAR/Y/xxKUyoQsj4+jysjWD7KDdhgw3 rf2cEBF9rVBSZ76h/6Z/BGRMRgnQN9TtctCd0yinay9hcbg31h9j5meFNhHuQnE= =4B3p -----END PGP SIGNATURE----- --M9NhX3UHpAaciwkO--