Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ggW16-0003OD-0S for pgsql-admin@arkaria.postgresql.org; Mon, 07 Jan 2019 14:36:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ggW14-0006D4-2T for pgsql-admin@arkaria.postgresql.org; Mon, 07 Jan 2019 14:36:34 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ggW13-0006Cw-Nr for pgsql-admin@lists.postgresql.org; Mon, 07 Jan 2019 14:36:33 +0000 Received: from r0.smtpout1.paris1.alwaysdata.com ([2a00:b6e0:1:40:1:0:10:1]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ggW0w-0000EK-JS for pgsql-admin@lists.postgresql.org; Mon, 07 Jan 2019 14:36:33 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=alwaysdata.net; s=hexack; h=In-Reply-To:Content-Transfer-Encoding: Content-Type:MIME-Version:References:Message-ID:Subject:Cc:To:From:Date: Sender:Reply-To:Content-ID:Content-Description:Resent-Date:Resent-From: Resent-Sender:Resent-To:Resent-Cc:Resent-Message-ID:List-Id:List-Help: List-Unsubscribe:List-Subscribe:List-Post:List-Owner:List-Archive; bh=jllbQxBptwNojaWNiSLXstimlTosigpU9Fj8CzRYxGI=; b=fBYIX30LFcMjtjl/uu5wZJnjLA b3zoMFGYyhjsLnr0lKpCMwcC8mgk7nc5g7i3ZPJnN89pTq524HGfXj3ZPpI1I6Fc1j0NZoo1bwyqs vwXp/HCouyEqSzMziTdaxG5PCfSOihRXlncdlkl1llZpzByCs6ZRDRECxVPN5Ev/3xKo=; Received: from mas01-1-78-225-200-186.fbx.proxad.net ([78.225.200.186] helo=office.hexack.fr) by smtpout1.paris1.alwaysdata.com with esmtpsa (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.89) (envelope-from ) id 1ggW0s-0001aB-PN; Mon, 07 Jan 2019 15:36:22 +0100 Date: Mon, 7 Jan 2019 15:36:21 +0100 From: =?utf-8?B?U3TDqXBoYW5l?= KANSCHINE To: Erika Knihti-Van Driessche Cc: pgsql-admin@lists.postgresql.org Subject: Re: Multiple postgresql clusters with same version and separate binaries Message-ID: <20190107143621.5byvsoedlriok3ft@office.hexack.fr> References: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: Organization: HexACK User-Agent: NeoMutt/20180716 X-alwaysdata-ID: 386508244 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Le ven. 4 janv., vers 16:30, Erika Knihti-Van Driessche exprimait : > Hi, Hey ! > Thanks all for your replies and help! I already thought that it’ll > be possible to just install binaries in different locations. It's not necessary, you "only" have to separate services, one thing that manages the services files in the Debian packages. It also manages clusters init and stop/start/etc globally for services named : - postgresql@10-cluster1 - postgresql@10-cluster2 - ... > Oh, and I’m on RHEL 7. [...] Previously I did do a minor upgrade - > shutdown all clusters and upgrade, then startup all.. but now they > start doing difficult with downtime for all applications at the same > time, so with next upgrade, I’ll separate all binaries. Please don't, you'll regret it when you'll have to upgrade as you'll have to uprade all your binaries. You should create separated services files and a global one. Regards, -- Stéphane KANSCHINE - https://www.hexack.fr./ - https://www.nuajik.io./ @ stephane@hexack.fr  +33 6 64 31 72 52