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