Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Emmanuel_DORR
Partner - Contributor III
Partner - Contributor III

Qlik Sense Architecture

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?

Emmanuel_DORR_1-1702638315949.png

Thanks a lot,

Emmanuel

Labels (1)
1 Solution

Accepted Solutions
vincent_ardiet_
Specialist
Specialist

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.

View solution in original post

3 Replies
vincent_ardiet_
Specialist
Specialist

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.

Albert_Candelario

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

Cheers,

Albert

Please, remember to mark the thread as solved once getting the correct answer
anderseriksson
Partner - Specialist
Partner - Specialist

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.