Install Standalone PostgreSQL
Deploy and Configure Qlik Sense
Overview
If you don't know this yet, Qlik Sense can be installed with either a bundled or standalone version of PostgreSQL.
In the Qlik Sense world, a bundled PostgreSQL server is simply a version of PostgreSQL that comes packaged with the Qlik Sense installation file we downloaded in the previous lesson.
A standalone PostgreSQL server, on the other hand, is nearly identical to the bundled version except you download, install, and configure it manually.
A standalone installation offers several advantages over the bundled version, the biggest one being greater ease and flexibility when upgrading PostgreSQL. With the bundled version, you're stuck with whatever version ships with the Qlik Sense installer. And if you want to upgrade, you're limited to whatever versions the Qlik PostgreSQL Installer (QPI) tool supports.
By the way, if you later choose to use Qlik’s QPI tool to upgrade PostgreSQL, it will convert your bundled installation into a standalone one during the upgrade.
All this is to say that there’s not much reason to install Qlik Sense with a bundled PostgreSQL server.
Good news is that installing and configuring a standalone installation of PostgreSQL server isn’t too hard and this guide, along with the next couple of guides, will show you exactly how it’s done. Let's get started!
24
STEPS
14
SCREENSHOTS
LOW
COMPLEXITY
Step 01.
Go to PostgreSQL's Downloads Page.
Step 02.
Click the Download the installer link.
Step 03.
On the Download PostgreSQL page, click on the link to download PostgreSQL installation file for your operating system.
Step 04.
Go to your Downloads folder, or wherever you’ve saved the downloaded PostgreSQL installation file.
Step 05.
Right-click PostgreSQL installation file and select Run as administrator option.
Step 06.
Click the Yes button in the User Account Control window.
Step 07.
Click the Next button on Welcome to the PostgreSQL Setup Wizard screen.
Step 08.
On Installation Directory screen, select the directory where you would like to install PostgreSQL or leave the default installation directory.
Step 09.
Click the Next button.
Step 10.
On the Select Components screen, select the components that you would like to install.
Step 11.
Click the Next button.
Step 12.
On the Data Directory screen, select the directory where you would like PostgreSQL to store its data.
Step 13.
Click the Next button.
Step 14.
On the Password screen, enter a password in Password and Retype password input boxes that you would like to create for postgres superuser account.
Step 15.
Click the Next button.
Step 16.
On the Port screen, enter port number that you would like this new version of PostgreSQL to use.
Step 17.
Click the Next button.
Step 18.
On the Advanced Options screen, select the Locale that you would like PostgreSQL to use.
Step 19.
Click the Next button.
Step 20.
On the Pre Installation Summary screen, review the settings used to install new version of PostgreSQL.
Step 21.
Click the Next button.
Step 22.
On the Ready to Install screen, click Next button to begin installation on new version of PostgreSQL.
Step 23.
Once installation is complete, uncheck the Launch Stack Builder on exit checkbox.
Step 24.
Click the Finish button.
Guide
Summary
All Set!
You now have a standalone installation of PostgreSQL installed. At the moment it's just an empty server - no users, no databases - so it's not quite ready to be used by Qlik Sense.
In the next lesson we'll get the path to PostgreSQL binaries added to the Path system variable. In the next lesson I'll give more context for what Path system variable is and explain why we need to give it the directory of PostgreSQL's binaries. I'll see you there!
References
Up Next
Set Path Environment Variable
Copyright © 2023 howdash LLC