Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VnstD-0002vC-4k for pgsql-hackers@arkaria.postgresql.org; Tue, 03 Dec 2013 16:31:59 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VnstC-000356-Jb for pgsql-hackers@arkaria.postgresql.org; Tue, 03 Dec 2013 16:31:58 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VnstB-00033w-CD for pgsql-hackers@postgresql.org; Tue, 03 Dec 2013 16:31:57 +0000 Received: from moutng.kundenserver.de ([212.227.126.171]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vnst8-0007IT-CW for pgsql-hackers@postgresql.org; Tue, 03 Dec 2013 16:31:57 +0000 Received: from localhost (mnsr-4db1f9b7.pool.mediaWays.net [77.177.249.183]) by mrelayeu.kundenserver.de (node=mreu2) with ESMTP (Nemesis) id 0M36tX-1VV6qs3S1n-00sSqY; Tue, 03 Dec 2013 17:31:54 +0100 Date: Tue, 3 Dec 2013 17:33:02 +0100 From: Christian Kruse To: Pgsql Hackers Subject: Re: Time-Delayed Standbys Message-ID: <20131203163302.GA18669@achilles.fritz.box> References: <52984711.8040806@lab.ntt.co.jp> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="X1bOJ3K7DJ5YkBrT" Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.22 (2013-10-16) X-Provags-ID: V02:K0:Nxw5ZriRJYDDKCxcNdaDR0YhvCVNtAbFmJpUT5xKiR2 RqdiXbiewpBwCPSVwURAFYOBvrcrztst3P/EnkdZwZA4DK69/K w9ScPiHnAttkUZ9kFkEnM666FbC1UZ+z2fxJxIFIz40PasJ4WR scSCTxmCB7VxWQEuM6P+3RqBBBB3H97mewx4E5g6QBR4ndDBfr o0drBPi+kEsZCvfaYdVMIyYBUSwuAif6jiklXV5phgvvKxIAu+ 1zQGdPNDYMivguoZkm/HA6YqbafteMM0yhkhGaziv+m5Ua089y zJOVrcjzJgVzO+XiJgA/BbkqqHQ2xct2UWiPHJ63y5qPYE+SGI lROG/Au3wQBK4cSXjGEvanQsQ/Olz27badOp14Z3s 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 --X1bOJ3K7DJ5YkBrT Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Hi Fabrizio, looks good to me. I did some testing on 9.2.4, 9.2.5 and HEAD. It applies and compiles w/o errors or warnings. I set up a master and two hot standbys replicating from the master, one with 5 minutes delay and one without delay. After that I created a new database and generated some test data: CREATE TABLE test (val INTEGER); INSERT INTO test (val) (SELECT * FROM generate_series(0, 1000000)); The non-delayed standby nearly instantly had the data replicated, the delayed standby was replicated after exactly 5 minutes. I did not notice any problems, errors or warnings. Greetings, CK --=20 Christian Kruse http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services --X1bOJ3K7DJ5YkBrT Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.22 (GNU/Linux) Comment: GPGTools - http://gpgtools.org iQQcBAEBCAAGBQJSnge+AAoJEEnjDsXITviXXCMf/1p6vnw8m0EOjGPifGxm+hi5 iQc+VjsrqiMF6F0o8Ph9SP0lq6IC5tu9jGh38GY5yIIBH6zOhp0e+vFaAlHFly+Y fgshvCO9jqUA3OlT6X1eRqSzUmMmUYZCy+pWvTnY1zX+aw0KStintL4EnEyH1x9f XRYctwT0AgKVsMC7oq3Sl1/HOqYqscvP81GbmlodgGthzsyzR+cn/LDNyrAeRFlV 23ieLt6g13TLdrRMKiuOuhz8fbakNW2kzebFiqSGCDPfaIjZFmuOXXwrnOuhfH26 1IO+tlgwHUFm5KK1uhkWgn5PMkEk7EbNKn5lzXRHVurbOjsGJjx02uy2ocEQNUSd gPpxAs2SWuve9k5QCU5u9p712k1AUG7YHFRkq/rbKRojsfcOYwxyWg+eQK5Z4vTc iU5tj8xCYbhMoRlrel73rDCbD8/tTuDpfLbP7lKFsNIrL+qvIZ3xBV2OxMnNqhuw fsLEYapG3LwRw6E183B7ZFit24/bOgB9KEuWorwsP28qIsHdUezjfpvjQDZw6rVf VB1VqgpWbzSAmJbVf63C5oSH2pXCCPo791Ni48tv2daPjbbXJyFll8VyjDayfvdT kuMUbDgm6mdX35UT4urVvBKsctTXSa+qeh84bSHtLCkrJLEv1KdNMs683t4tpgba XhBL4cEuRAEer5KYL/QAHcNuO3qb4/joeujcNjS53cDyJnaJwX6KBKfuE64AKjed kt2uBNpX7BCs5U2f9QPR5kz38GHDnSSS1+JShcMpBDqAdPlKRliodXwIHtgeVP58 oxdyR9bOPR3ED30vqUCNglElRCI1MZEFO3JEYe93UFrLm9DMe6Q615RVT6Ds1vu3 WBf1MK4qlBTBoPOjQy5aCum53ClmMkfXUEuWK34lHBDcjZvUADbC9oa6haiqiyr3 gV3qD/usl4RaTwkbEw/1cCWDpKrabsMyMw4YvHG/SqzMyjPbg2kWBVW5PwS7Dtez SjecoPr/vDzyxtPDcZF8+TzSLZlOnzMsb56CDzTP7T5qveT1Jlj7YUWkIw+MBxfT IRGqzlPZSWfZz79J1FH9YMC/nhhjib9fTvj5GTWfe8Um56JXJWItxOXkMs5ciQP3 7BKJj4bzlqmrgp3kbfRRHbm/Yp/GO/hgVAwm9N8fm+PLwmlqvWpMKkHwrs9TZ7Xt VS2g4/i9L3nlgwYqtHfQMRmlfzITHH7hopuasFHkp2+v32H5OKkJFswvwaHpFghN kYk4t6opTasmjUKKb47Dv9rx9w7ZtuVDhOcq5bgRrz0Buw1ilvwJ78ofUGPqb0AW JxPgYoctzIhXwM1McEHqffIrYMuUcDHFoXrKn9CmHtEk97rpNCSjF60UULk170o= =PgMZ -----END PGP SIGNATURE----- --X1bOJ3K7DJ5YkBrT--