Re: Multiple postgresql clusters with same version and separate binaries

2019-01-04 Thread MichaelDBA
I did say you need to run with different binaries for different versions: To put it simply: you cannot run different major versions of PostgreSQL with the same binaries. So when I subsequently said the following it was in that context. The 3rd one is separate binary locations for each PG clu

Re: Multiple postgresql clusters with same version and separate binaries

2019-01-04 Thread Rui DeSousa
> On Jan 4, 2019, at 9:32 AM, MichaelDBA wrote: > > The 3rd one is separate binary locations for each PG cluster instance > running on the same host. Don’t need separate binaries for each cluster; only separate binaries for each version needed; i.e. 9.6.1, 9.6.2, etc.

Re: Multiple postgresql clusters with same version and separate binaries

2019-01-04 Thread Adrian Klaver
On 1/4/19 7: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 h

Re: Multiple postgresql clusters with same version and separate binaries

2019-01-04 Thread Erika Knihti-Van Driessche
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 installati

Re: Multiple postgresql clusters with same version and separate binaries

2019-01-04 Thread Shreeyansh Dba
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 On Fri, Jan 4, 2019 at 7:51 PM Erika Knihti-Van Driessche < erika.kni

Re: Multiple postgresql clusters with same version and separate binaries

2019-01-04 Thread Ray O'Donnell
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 t

Re: Multiple postgresql clusters with same version and separate binaries

2019-01-04 Thread Adrian Klaver
On 1/4/19 6:21 AM, 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 tim

Re: Multiple postgresql clusters with same version and separate binaries

2019-01-04 Thread MichaelDBA
To put it simply: you cannot run different major versions of PostgreSQL with the same binaries. 3 things need to be separate. You named 2 of them: data directory and port. The 3rd one is separate binary locations for each PG cluster instance running on the same host. What I do is create a se

Multiple postgresql clusters with same version and separate binaries

2019-01-04 Thread Erika Knihti-Van Driessche
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 run