Where to find PostgreSQL port number?
Qlik Sense Admin Courses:
_____________________________________________
Qlik Sense Server Pro Course Bundle: https://www.howdash.com/courses/qlik-...
Backup, Upgrade, and Recover Qlik Sense: https://www.howdash.com/courses/backu...
Qlik Sense Security: https://www.howdash.com/courses/qlik-...
Deploy and Configure Qlik Sense: https://www.howdash.com/courses/deplo...
Windows Server for Qlik Sense Admins: https://www.howdash.com/courses/windo...
Default Paths to Files:
_______________________
Both postmaster.pid and postgresql.conf files can be found in the following default directories:
Standalone PostgreSQL: C:\Program Files\PostgreSQL\[version_num[\data
Bundled PostgreSQL: C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\[version_num]
Query to Find Port Number:
__________________________
SELECT name
, setting
, unit
, category
, short_desc
, context
, source
, pending_restart
FROM pg_settings
WHERE "name" = 'port'
;
Join howdash Community:
__________________________
LinkedIn: / howdashllc
Facebook: / howdashllc
Description:
___________
🎁 Welcome to 25 days of QlikMas! Each day I'll unwrap one quick Qlik Sense server admin lesson you can learn in under ten minutes. Today, I walk through three reliable ways to find the exact port number your PostgreSQL server is using on a Qlik Sense server. You'll learn how to check the postmaster.pid file, verify settings in postgresql.conf, and use pgAdmin to explore PostgreSQL settings.
Whether you're running bundled or standalone PostgreSQL, this video will help you quickly and confidently identify the port used by your PostgreSQL server.
Perfect for Qlik Sense admins working on configuration, maintenance, or recovery tasks.
📅 Come back tomorrow for Day 13 of QlikMas for more Qlik Sense admin tips and insights!
Chapters:
_________
0:00 Intro
0:16 3 Common Ports Used by PostgreSQL
0:59 Option 1: postmaster.pid File
3:04 Option 2: postgresql.conf File
5:24 Option 3: pgAdmin
7:20 Outro