From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Multiple postgresql clusters with same version and separate binaries
Date: Fri, 4 Jan 2019 09:38:47 -0600
Message-ID: <bd721544-3429-d10e-dda7-ce0de7052eb4@gmail.com> (raw)
In-Reply-To: <FE3AE60D-1B69-45A8-823C-75A7761EAF53@gmail.com>
References: <CALgXhV_8SKtraLOYWtJcqL4_9X9i9WT94Wx2-1sp99ZyvJy6WQ@mail.gmail.com>
<CAGDYbUOy1kreTzTDx1uFfOCuNFeGdduW+iRhBjcdJk7vewqSzw@mail.gmail.com>
<FE3AE60D-1B69-45A8-823C-75A7761EAF53@gmail.com>
If uptime is a priority, then unless they're small, you should think about
separating them onto separate servers. And implementing replication for DR.
On 1/4/19 9:30 AM, Erika Knihti-Van Driessche wrote:
> 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
>> <mailto: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
>>
>
--
Angular momentum makes the world go 'round.
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: ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Multiple postgresql clusters with same version and separate binaries
In-Reply-To: <bd721544-3429-d10e-dda7-ce0de7052eb4@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