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 1gfRQc-0008Pb-TB for pgsql-admin@arkaria.postgresql.org; Fri, 04 Jan 2019 15:30:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gfRQb-0007S8-8F for pgsql-admin@arkaria.postgresql.org; Fri, 04 Jan 2019 15:30:29 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gfRQa-0007Rx-Rb; Fri, 04 Jan 2019 15:30:29 +0000 Received: from mail-ed1-x544.google.com ([2a00:1450:4864:20::544]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gfRQX-0003Yb-Uu; Fri, 04 Jan 2019 15:30:27 +0000 Received: by mail-ed1-x544.google.com with SMTP id a20so25330840edc.8; Fri, 04 Jan 2019 07:30:25 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=from:message-id:mime-version:subject:date:in-reply-to:cc:to :references; bh=RcbT7IEWpYkYJA17fNKB8czDd1xWX5/yi1AQIk9rqtc=; b=OwD5ng8EDFuNs+ALif/vQAGcdneTTX1fVj1y+v5I+gnBZctipXBQllDOuAkX1FjoSU vPhHSAnPCUhFQ+UfwvLhzxgbyDnhLHOGN+UpMP5GMjHJdIJ7jV2mtjy/iUIJqODv6TGs Mjp2d7iijAtuAafODn2oKg9K4MbqHMeKSXtcrm6vZ3b6pGxz7lriM23OTwn7koJXBKUK tYDk3ZnjTaxAsU1JW3pt88FLLwMRiU8oxykKG+YvpJ2akye7w26Cq1m70SK9tUII3Bfk 0Yq+33LNejlvjWSKlXhFayuORQI+oBCyHJYVmvl0K5BeaYBsdfXT35RryoV/U0IT+Pwy CyLQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:message-id:mime-version:subject:date :in-reply-to:cc:to:references; bh=RcbT7IEWpYkYJA17fNKB8czDd1xWX5/yi1AQIk9rqtc=; b=h2OJVd9dlJhECrxxDC0fg1sJ+Q8yX2Pzgayr0b+FKpaT4DyqJWBzT+WylEgkmkIYER 1yT7P65itQVIBg7A9RaNImib8YuoveoqUw5xZA2XG4dAvlik0o9OTTzaZ17802RXJV12 GOJsAVAyLDQLmLxw4nicI52nXAjgdj4wTgWwHpu9VxSB7Erdr5ece2W+YKIis4jgyiFJ Ltf65F02XNO2xB3IgtNXFchF9IwFwiHyqvvveMH6++quNbY6+3/MWidR6rE3KcltXk1d AbgCQcdW4YTVvXrN92t3UNX2K277q/SCofoCp/z89+OGq8+6KIaFeT9zBbcdaHJVsKso 1BUA== X-Gm-Message-State: AA+aEWb/ZSqIsRvLn+rUEp6TTxTCKUlVPyv/uNiDN2Yu6ab8sRCYRbZH x9mbLe+Sdp0U+Vg8F972TS0= X-Google-Smtp-Source: AFSGD/X1HTvAy7j0TQ6eXycRti5/7ofgXhD8V0T6XlZR1UE+RT1E3Y5q5UbICBW4OPGzvlyJiqknBQ== X-Received: by 2002:a17:906:e9b:: with SMTP id p27-v6mr39245632ejf.29.1546615823525; Fri, 04 Jan 2019 07:30:23 -0800 (PST) Received: from ?IPv6:2a02:a03f:5e1a:e900:a429:ab5f:3b20:3b16? ([2a02:a03f:5e1a:e900:a429:ab5f:3b20:3b16]) by smtp.gmail.com with ESMTPSA id i24sm22571275edq.0.2019.01.04.07.30.22 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Fri, 04 Jan 2019 07:30:22 -0800 (PST) From: Erika Knihti-Van Driessche Message-Id: Content-Type: multipart/alternative; boundary="Apple-Mail=_1E5E0E9B-D583-4EB4-AC44-F4284BAA2396" Mime-Version: 1.0 (Mac OS X Mail 12.2 \(3445.102.3\)) Subject: Re: Multiple postgresql clusters with same version and separate binaries Date: Fri, 4 Jan 2019 16:30:21 +0100 In-Reply-To: Cc: pgsql-admin@lists.postgresql.org, pgsql-general@lists.postgresql.org To: Shreeyansh Dba References: X-Mailer: Apple Mail (2.3445.102.3) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --Apple-Mail=_1E5E0E9B-D583-4EB4-AC44-F4284BAA2396 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 Hi, Thanks all for your replies and help! I already thought that it=E2=80=99ll= be possible to just install binaries in different locations. My current = installation I have all done using one binary location and initdb.. not = a very good solution on hindsight.. Oh, and I=E2=80=99m on RHEL 7. I = used the installation packages from EDB for Postgres. 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=E2=80=99ll = separate all binaries. Cheers, Erika > On 4 Jan 2019, at 15:50, Shreeyansh Dba = wrote: >=20 > Hi Erika, >=20 > You can create the different version services and use these services = for PostgreSQL start/stop. > ex. > service postgresql-10 start > service postgresql-9.6 start >=20 > Thanks & Regards, > Shreeyansh DBA Team > www.shreeyansh.com >=20 > On Fri, Jan 4, 2019 at 7:51 PM Erika Knihti-Van Driessche = > wrote: > Hi, >=20 > 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. >=20 > 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?=20 >=20 > All help and ideas appreciated! :-) >=20 > Thanks, > Erika --Apple-Mail=_1E5E0E9B-D583-4EB4-AC44-F4284BAA2396 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 Hi,

Thanks = all for your replies and help! I already thought that it=E2=80=99ll be = possible to just install binaries in different locations. My current = installation I have all done using one binary location and initdb.. not = a very good solution on hindsight.. Oh, and I=E2=80=99m on RHEL 7. I = used the installation packages from EDB for Postgres. 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=E2=80=99ll = separate all binaries.

Cheers,
Erika

On 4 Jan = 2019, at 15:50, Shreeyansh Dba <shreeyansh2014@gmail.com> wrote:

Hi = Erika,

You can create = the different version services and use these services for PostgreSQL = start/stop.
ex.
service postgresql-10 start
service postgresql-9.6 start

Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com


On Fri, Jan 4, 2019 at 7:51 PM Erika Knihti-Van = Driessche <erika.knihti@gmail.com> 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? 

All help and ideas appreciated! :-)

Thanks,
Erika

= --Apple-Mail=_1E5E0E9B-D583-4EB4-AC44-F4284BAA2396--