Re: Multiple postgresql clusters with same version and separate binaries

From: Stéphane KANSCHINE <stephane(at)hexack(dot)fr>
To: Erika Knihti-Van Driessche <erika(dot)knihti(at)gmail(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Multiple postgresql clusters with same version and separate binaries
Date: 2019-01-07 14:36:21
Message-ID: 20190107143621.5byvsoedlriok3ft@office.hexack.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

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(at)10-cluster1
- postgresql(at)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(at)hexack(dot)fr
 +33 6 64 31 72 52

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Volkmar Herbst 2019-01-07 15:24:59 plr (extension) error during make
Previous Message Pavan Teja 2019-01-07 09:11:56 Re: postgres installation issue

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2019-01-07 14:44:40 Re: About SSL connection
Previous Message Alexander Farber 2019-01-07 13:56:47 Re: Adding LEFT JOIN to a query has increased execution time 10 times