Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZvBe3-0005b6-AY for pgsql-pkg-yum@arkaria.postgresql.org; Sat, 07 Nov 2015 22:07:35 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZvBe2-0004kx-TJ for pgsql-pkg-yum@arkaria.postgresql.org; Sat, 07 Nov 2015 22:07:34 +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 1ZvBQL-0002tj-0D for pgsql-pkg-yum@postgresql.org; Sat, 07 Nov 2015 21:53:25 +0000 Received: from mail-qk0-x22c.google.com ([2607:f8b0:400d:c09::22c]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1ZvBQH-0006bG-Lu for pgsql-pkg-yum@postgresql.org; Sat, 07 Nov 2015 21:53:22 +0000 Received: by qkcl124 with SMTP id l124so57607518qkc.3 for ; Sat, 07 Nov 2015 13:53:20 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=mtu_edu.20150623.gappssmtp.com; s=20150623; h=mime-version:date:message-id:subject:from:to:content-type; bh=eCNMZlOtrTHbM3gQgOq5tH8uaSv1x1R4qU7UDmcwbGE=; b=mw3rFJk0cD1g8lRcKMGBlE++ityjh4xp6VFJI2rn3vLyRq0eMqr9q5nySWHgfVwM6t zYZhzcyjYlTpepzditdRZ9xRSkk7YpHpODVpcuCVaWR6WHQAFp9viMOAf/5YYPpbkdsC tP0Mpvk/aVmvaEGegXRvuQrYC0Y//J3PSj+euouirUAnUw72oENupEP84nnJYgrWU7Xc NxJWrZe31OJ7zI6VK5532xNjL5bKS2Od18CvxSVY3dQJJ/LgFM4ezOekT/F4MVQDbiOd pLf8oL5AQ+TJ6M7m0i53ruLRqfT2rFgm9rlPQL8tezia7GlSE4iyWPia54+frei6Y6/F s4rQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:date:message-id:subject:from:to :content-type; bh=eCNMZlOtrTHbM3gQgOq5tH8uaSv1x1R4qU7UDmcwbGE=; b=iNAVuCQ5pGVDdQLO2C2S/er5Dzb1V9iHJQ40AkdDICjmBzbZNFvgcE9pN9YsuWiAG8 5hP410UMFbS7AQu9EL8sGOabkZBOfhIwpi/wK7eP3+et/A7bJHbTWniIO74xV5Y5Y9Dv K3neq5h94Ba9i2HUunbVsNCpenayV3PGpHQ2SuNYxvacj0/iEYqMzlE7noS75WFT6aQF L9HNNSq1M+jB1PqhtLf1FRSoC7Y2G7d9RDe+wLI2k90eqw98MRJwk5ygm69HScUQ/JrU X8Xhmg9UZ4S6rrmGDT/ANZn0QcopF++jY8Puhn1vpAgXjZjVn1vItmdu5Hs/zuwCU66j sQOg== X-Gm-Message-State: ALoCoQkGszkKC6ZnmHk2iCDhLG0dpFU/+aMZNJ9Wf8H6Msc0jE8vxor3c0BbcmzSBPFm3wSLe0G2 MIME-Version: 1.0 X-Received: by 10.55.23.170 with SMTP id 42mr20264222qkx.42.1446933200536; Sat, 07 Nov 2015 13:53:20 -0800 (PST) Received: by 10.55.142.134 with HTTP; Sat, 7 Nov 2015 13:53:20 -0800 (PST) Date: Sat, 7 Nov 2015 16:53:20 -0500 Message-ID: Subject: repmgr94 From: Justin King To: pgsql-pkg-yum@postgresql.org Content-Type: multipart/alternative; boundary=001a11473f946eba540523fa63c7 X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-pkg-yum Precedence: bulk Sender: pgsql-pkg-yum-owner@postgresql.org --001a11473f946eba540523fa63c7 Content-Type: text/plain; charset=UTF-8 Greetings, The EL7 RPM for repmgr94 creates a new system user repmgr and has repmgrd run as repmgr. Additionally when repmgr is invoked it expects read/write over the postgres data directories and the ability to invoke pg_ctl using system(...) which would require it to be either root or postgres. I took a look through the source and it appears repmgrd invokes repmgr using system(...) which would be running as the repmgr user and would fail. The repmgr example spec files, readme/instructions, and the official debian/ubuntu packages also assume repmgr and repmgrd run as postgres and do not create a new user. They also place all of the repmgr binaries, log file, and pid file in the same directories as postgres. If you used repmgr without repmgrd you would not notice, or you would not notice until it attempts to do automatic failover. Justin --001a11473f946eba540523fa63c7 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Greetings,

The EL7 RPM for repmgr94 creates a new s= ystem user repmgr and has repmgrd run as repmgr. Additionally when repmgr i= s invoked it expects read/write over the postgres data directories and the = ability to invoke pg_ctl using system(...) which would require it to be eit= her root or postgres. I took a look through the source and it appears repmg= rd invokes repmgr using system(...) which would be running as the repmgr us= er and would fail. The repmgr example spec files, readme/instructions, and = the official debian/ubuntu packages also assume repmgr and repmgrd run as p= ostgres and do not create a new user. They also place all of the repmgr bin= aries, log file, and pid file in the same directories as postgres. If you u= sed repmgr without repmgrd you would not notice, or you would not notice un= til it attempts to do automatic failover.

Justin
--001a11473f946eba540523fa63c7--