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
> 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.
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
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
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
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
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
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
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