Re: Multiple postgresql clusters with same version and separate binaries

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(at)gmail(dot)com
>> <mailto:shreeyansh2014(at)gmail(dot)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(dot)knihti(at)gmail(dot)com <mailto:erika(dot)knihti(at)gmail(dot)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.