Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aGBoO-0001J0-Bx for pgsql-admin@arkaria.postgresql.org; Mon, 04 Jan 2016 20:33:04 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aGBoN-0006HB-TP for pgsql-admin@arkaria.postgresql.org; Mon, 04 Jan 2016 20:33:03 +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) (envelope-from ) id 1aGBmi-0004Oe-8o for pgsql-admin@postgresql.org; Mon, 04 Jan 2016 20:31:20 +0000 Received: from tamriel.snowman.net ([2001:4830:167b::11]) by makus.postgresql.org with esmtp (Exim 4.84) (envelope-from ) id 1aGBmf-0003pK-Px for pgsql-admin@postgresql.org; Mon, 04 Jan 2016 20:31:19 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id 34F915F794; Mon, 4 Jan 2016 15:31:17 -0500 (EST) Date: Mon, 4 Jan 2016 15:31:17 -0500 From: Stephen Frost To: "drum.lucas@gmail.com" Cc: pgsql-admin@postgresql.org Subject: Re: Archive command failed - WAL SEGMENT Message-ID: <20160104203117.GH3685@tamriel.snowman.net> References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="sUZnndmKsi7OCVMt" Content-Disposition: inline In-Reply-To: X-Editor: Vim http://www.vim.org/ X-Info: http://www.snowman.net X-Operating-System: Linux/3.13.0-61-generic (x86_64) X-Uptime: 15:30:33 up 153 days, 5:01, 12 users, load average: 0.12, 0.08, 0.07 User-Agent: Mutt/1.5.21 (2010-09-15) X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --sUZnndmKsi7OCVMt Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Drum, * drum.lucas@gmail.com (drum.lucas@gmail.com) wrote: > I've configured a new SLAVE Hot Standby server to my production. >=20 > The problem is that, I've got some errors on Master: >=20 > archive command failed with exit code 4 > Failed to archive WAL segment `pg_xlog/0000000100000C2100000029` on host > `db-02` >=20 > Do you guys know what I may be doing wrong? Whatever you have set as your archive_command in postgresql.conf is returning exit code 4. It's either broken, and you need to fix it, or, if it's working, you need to change it to return error code 0 (indicating success). Thanks! Stephen --sUZnndmKsi7OCVMt Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJWitaUAAoJEO1sijiDR2RV6OwP+gLJxrjIzpzpUUoHVxZc6Ybb qXbMwe5HunCF+GNBhxrEKNUTvYgY2KIrsl91MlSheDMbAGDezd4reVqej5qI2t33 Uzo++yacHuyZ0Hr3m4SaSR49BdF6ZawdS8QjZn+sqqAZdnLB0UmMVv6JhbCP2UXf k/otqP4ap9wB9eLmSnbng9ptD2FgshpxqFF5006JHQJGgtLV9gNTbxjo5CfkFS4v 1yu3flqQHkisMnaUPAXcBWfgodEnaz5I4nG3Miqr3iT7C3kfvXCgtGzyULr91bdt w0UxGwN8P7wNTWlkENZfguSY6GJvxqONbG9iGjT8FdDhm8yMVjz4HaN3ZLpHNQXz wTjcUVpRH9xnAU/kNaSrh6QnGR0Z61u4OU0ZectmJg84JtcLo2jB+nj3meZTc3X6 pNhr28vwpbCrEnTttfZK2SL/kCCTadDRD+gL0thXZr1u7cPvfEDcqYwHYxpPKvjC xHchTkrVGf47y69myIu51lzs96ZQ1aEJ7m7PihTvLZ/2fn/XFnU0ObeTxmqs0HgA zUgXm9qSi5o2lkOOy0Jt0M51XmJ0BNXEH8fK/zNVOFOV0XIlwFWoZemwScg1HtIu Kjxay49qLbjgH32WDRy9GtiW/b8FwIiYb20zIG2+52HFssSNw9C+umFRECwFFJ4M nuwzhEH8pdVvYxEiBet0 =yofu -----END PGP SIGNATURE----- --sUZnndmKsi7OCVMt--