Allow Remote PostgreSQL Connections (Firewall Setup)

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...


PowerShell Command to Find IP Address:
______________________________________
Resolve-DnsName -Name "[name_of_server]"


Rule Name & Description:
________________________
Name: Allow Connection to PostgreSQL Server
Description: Allow PROD Qlik Sense server to connect to PostgreSQL server running on this machine on port 4432. PROD server will be used to create data connections for analytics purposes and to compare old and new versions of PostgreSQL server during the upgrade of PostgreSQL server on this machine.


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 this video, you'll learn how to securely enable remote access to a PostgreSQL server by configuring Windows Firewall rules. We'll break down the two layers of security involved, show exactly where the firewall rule needs to be created, and walk step-by-step through allowing specific servers to connect on the correct PostgreSQL port.

This is the first part of a two-video setup and focuses on the Windows side of remote PostgreSQL access. Perfect for Qlik Sense admins who want a clear, practical approach to managing PostgreSQL connectivity across environments.


Chapters:
_________
0:00 Intro
0:24 Two Layers of Security
1:46 Which Server to Create Firewall Rule On?
2:35 Create Firewall Rule
7:18 Review