From: Erika Knihti-Van Driessche <erika.knihti@gmail.com>
To: Shreeyansh Dba <shreeyansh2014@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Cc: pgsql-general@lists.postgresql.org
Subject: Re: Multiple postgresql clusters with same version and separate binaries
Date: Fri, 4 Jan 2019 16:30:21 +0100
Message-ID: <FE3AE60D-1B69-45A8-823C-75A7761EAF53@gmail.com> (raw)
In-Reply-To: <CAGDYbUOy1kreTzTDx1uFfOCuNFeGdduW+iRhBjcdJk7vewqSzw@mail.gmail.com>
References: <CALgXhV_8SKtraLOYWtJcqL4_9X9i9WT94Wx2-1sp99ZyvJy6WQ@mail.gmail.com>
<CAGDYbUOy1kreTzTDx1uFfOCuNFeGdduW+iRhBjcdJk7vewqSzw@mail.gmail.com>
Hi,
Thanks all for your replies and help! I already thought that it’ll 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’m 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’ll 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 <http://www.shreeyansh.com/;
>
> On Fri, Jan 4, 2019 at 7:51 PM Erika Knihti-Van Driessche <erika.knihti@gmail.com <mailto: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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: erika.knihti@gmail.com, shreeyansh2014@gmail.com, pgsql-admin@lists.postgresql.org, pgsql-general@lists.postgresql.org
Subject: Re: Multiple postgresql clusters with same version and separate binaries
In-Reply-To: <FE3AE60D-1B69-45A8-823C-75A7761EAF53@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox