Allow Remote PostgreSQL Connections (HBA Configuration)
Qlik Sense Admin Courses:
_____________________________________________
Qlik Sense Server Pro Course Bundle: https://www.howdash.com/courses/qlik-...
Qlik Sense Security: https://www.howdash.com/courses/qlik-...
Backup, Upgrade, and Recover Qlik Sense: https://www.howdash.com/courses/backu...
Deploy and Configure Qlik Sense: https://www.howdash.com/courses/deplo...
Windows Server for Qlik Sense Admins: https://www.howdash.com/courses/windo...
Default Locations of PostgreSQL HBA File:
_________________________________________
Bundled Installation: C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\[version_number]
Standalone Installation: C:\Program Files\PostgreSQL\[version_number]\data
PowerShell Command to Find IP Address:
______________________________________
Resolve-DnsName -Name "[name_of_server]"
Join howdash Community:
__________________________
LinkedIn: / howdashllc
Facebook: / howdashllc
Description:
___________
🎁 Welcome to 25 days of QlikMas! For 25 days of December I'll unwrap one quick Qlik Sense server admin lesson you can learn in under fifteen minutes. In today's video, we finish configuring PostgreSQL to allow connections from other servers by setting up host-based authentication (pg_hba.conf) and listen_addresses.
You'll learn where to find and edit the pg_hba file for both bundled and standalone PostgreSQL installations, how to safely create HBA rules (and what not to use), and how listen_addresses controls where PostgreSQL accepts connections. We'll then test everything by creating a live PostgreSQL data connection in Qlik Sense.
This video is ideal for Qlik Sense admins and PostgreSQL administrators who need secure, reliable remote PostgreSQL access for monitoring, upgrades, or multi-server environments.
👉 Watch Part 1 to configure Windows Firewall before applying these PostgreSQL settings:
• Allow Remote PostgreSQL Connections (Firew...
Chapters:
_________
0:00 Intro
0:17 What is a Host-Based Authentication Rule?
0:56 Where to Find HBA File?
1:48 Create HBA Rule
4:22 Configure PostgreSQL listen_addresses
4:55 What is listen_addresses setting?
7:13 Create Remote Data Connection in Qlik Sense
9:23 Review & Accomplishments