Re: Multiple postgresql clusters with same version and separate binaries

From: Ray O'Donnell <ray(at)rodonnell(dot)ie>
To: Erika Knihti-Van Driessche <erika(dot)knihti(at)gmail(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Multiple postgresql clusters with same version and separate binaries
Date: 2019-01-04 14:46:14
Message-ID: cd3210ac-08e1-4116-f4e4-75922d496f90@rodonnell.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

On 04/01/2019 14:21, 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?

What OS are you running? The Debian packages from apt.postgresql.org
allows multiple versions to co-exist on the same machine (though
naturally on different ports), and multiple clusters within each version
(again on different ports).

Ray.

--
Raymond O'Donnell // Galway // Ireland
ray(at)rodonnell(dot)ie

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Shreeyansh Dba 2019-01-04 14:50:00 Re: Multiple postgresql clusters with same version and separate binaries
Previous Message Adrian Klaver 2019-01-04 14:36:37 Re: Multiple postgresql clusters with same version and separate binaries

Browse pgsql-general by date

  From Date Subject
Next Message Shreeyansh Dba 2019-01-04 14:50:00 Re: Multiple postgresql clusters with same version and separate binaries
Previous Message Adrian Klaver 2019-01-04 14:36:37 Re: Multiple postgresql clusters with same version and separate binaries