Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
My customer wants to deploy a new Qlik Sense architecture with 3 separate environments (Production, Development, Testing). They want to use a single dedicated PostgreSQL server to host the databases for all 3 environments, and I'm not sure this is technically feasible.
Each environment will have its own QRS database, but is it possible to have all 3 QRS databases on the same PostgreSQL instance?
Or is it mendatory to have 3 separate PostgreSQL servers to meet my needs?
Last question, my client suggests using a NAS server to create Fileshare. Is this feasible for this deployment?
Thanks a lot,
Emmanuel
Yes this is feasible, for both NAS and DB questions.
However, regarding the DB, this could be nice to have separate instances in order to be able to test future migration of postgresql version.
Yes this is feasible, for both NAS and DB questions.
However, regarding the DB, this could be nice to have separate instances in order to be able to test future migration of postgresql version.
I agree, having all on the same DB might lead a single point of failure which you might want to avoid.
Cheers,
Albert
Not much point in using same PostgreSQL for all three instances.
PostgreSQL is lightweight and no big deal having a local instance on the Sense server.
Then you do not need to customize your installation procedures.