
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
Thanks a lot,
Emmanuel
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I agree, having all on the same DB might lead a single point of failure which you might want to avoid.
Cheers,
Albert

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
