topic Re: Qlik Sense Architecture in Management & Governance

Qlik Sense Architecture

Emmanuel_DORR — Fri, 15 Dec 2023 11:08:51 GMT

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

Re: Qlik Sense Architecture

vincent_ardiet_ — Fri, 15 Dec 2023 13:32:12 GMT

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.

Re: Qlik Sense Architecture

Albert_Candelario — Fri, 22 Dec 2023 14:57:55 GMT

I agree, having all on the same DB might lead a single point of failure which you might want to avoid.

Cheers,

Albert

Re: Qlik Sense Architecture

Anders_Eriksson — Fri, 22 Dec 2023 15:45:16 GMT

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.