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 1gfR0N-0006FC-2S for pgsql-admin@arkaria.postgresql.org; Fri, 04 Jan 2019 15:03:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gfR0L-0005y1-69 for pgsql-admin@arkaria.postgresql.org; Fri, 04 Jan 2019 15:03:21 +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 1gfR0K-0005xu-T3 for pgsql-admin@lists.postgresql.org; Fri, 04 Jan 2019 15:03:20 +0000 Received: from mail-wr1-x442.google.com ([2a00:1450:4864:20::442]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gfR0I-0007YM-PV for pgsql-admin@lists.postgresql.org; Fri, 04 Jan 2019 15:03:20 +0000 Received: by mail-wr1-x442.google.com with SMTP id r10so36814477wrs.10 for ; Fri, 04 Jan 2019 07:03:18 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-transfer-encoding:content-language; bh=R4SfkZikqxogGbdmTGvcp2UDAUhLagpo8h5vhtmukhA=; b=cMyLcvpzXE0J9BMM4vZL6G9FonvJBaaNuYfvlEif6W6pGZrtGYYTahMDS9ri9H8EM+ M/DmuiPFIYgH/fIbN+dzhLyFZQzzzoayzF6iXd3kpkicBXBAHneJiqbldDqQyizqUwIu F0GkfKbZ8WpExZ6A+ZuMnlbVopB6oFDmwIzNc5RCHUSHMLsO0JoMpaqTWRowkV4w7WUL lFR8k/PfplMKmkw15wSRmtDsWk3OcB9fdWqkeEafXdFzUMOPMyt7Ks3xyaTOQecDMHSx vZzTnf0g9VKHA7QzROj5c8VAJ/YGm8OfeAoNy5ZhZSeTVt9S1fg4002BWvoQtKxtjWzN 9ARg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding :content-language; bh=R4SfkZikqxogGbdmTGvcp2UDAUhLagpo8h5vhtmukhA=; b=kUNOGceF38pdK9RhYPDMe5ueulycviS6O3kRrXUxEgw3KCFzugrznC2wUgY1F+Qe8W hlLxs2lSBM3kU0O431ckaAKo9h9ROibadBKMhFxpiehpjx8sd+jf4B4gkO7tBhEz646e kUwqNVPcMCFWP44IgGx2Of+lw/gis+eYloRVG6KiHCuo8nRxE36OgFt7hpdXShuznPGO wFItlHIQlCIsR3gznLY3QfMmDJc1buyUc79y/oZn3ymLGbyQD2d0n06IjJkHUZeqxixS xt49urcDki+mO+45vWNK/ZjJAh8dsUbh1Crh/C/5wrR+Exnw2ZdTqoJPc8cwGYUS6D5X yg3w== X-Gm-Message-State: AJcUukf4NYR0HbKJ845wQ3XM6pSubs/uDVvqwylYNlXDVk5KkprL0RZf UxRZ4qTVUHa21/C93G5DnZAgS3Bj X-Google-Smtp-Source: ALg8bN5nVOrwM0ynCKtqzqoYIFdAUMlf5FBC+0FxiodYHMpNe/7Mpgobzxp6QW4O308EvBpSlJZZ9w== X-Received: by 2002:adf:edc1:: with SMTP id v1mr45003404wro.105.1546614196896; Fri, 04 Jan 2019 07:03:16 -0800 (PST) Received: from [10.1.10.6] ([172.98.67.87]) by smtp.googlemail.com with ESMTPSA id y34sm131514047wrd.68.2019.01.04.07.03.14 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Fri, 04 Jan 2019 07:03:14 -0800 (PST) Subject: Re: Multiple postgresql clusters with same version and separate binaries To: pgsql-admin@lists.postgresql.org References: From: Ron Message-ID: <26964b75-756e-2762-8f89-f82be261cb9f@gmail.com> Date: Fri, 4 Jan 2019 09:03:12 -0600 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.2.1 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 1/4/19 8:21 AM, Erika Knihti-Van Driessche wrote: > Hi, > > I have 10+ postgresql clusters (v 9.6) running on one machine - each > having their own data directory and port. They all share same binaries > though, and this is now giving me some headache.. I cannot shutdown all > clusters at the same time, so upgrading them is quite impossible. > > I know that running several versions of postgres is possible on one > machine - I suppose this would also work out with same version running on > different locations, like /db1/PostgreSQL/10, /db2/PostgreSQL/10.. etc..? > Has anyone any experience with this kind of problem? (Please do not cross-post.) Since they're all the same major version (9.6), you'll need to build from source and then install the binaries to different locations. -- Angular momentum makes the world go 'round.