- Bind the service to localhost or a private network, never to a public address.
- Enable authentication, use per-application accounts and require TLS.
- Watch for exposed Docker ports: publish them on 127.0.0.1 only.
Port 38638: Premier SQL Middleware Server
Port 38638 is assigned by IANA to psqlmws (Premier SQL Middleware Server).
38638
How psqlmws works
Databases & cachesThe application sends a SQL query to the psqlmws server on port 38638, which returns rows from its tables.
- Transport
- TCP
- Exposure risk
- not rated depends on the program listening
- Encryption
- Unknownnot stated by the registry
- IANA status
- Assigned1 registered service
- Range
- Registered (1024-49151)
- Category
- Databases & caches
Is port 38638 dangerous?
We have no specific security note for port 38638. Its risk depends on the program actually listening on it. General advice for databases & caches services:
IANA registry entries for port 38638
| Service | Port | Transport | Description | Reference | Updated |
|---|---|---|---|---|---|
| psqlmws | 38638 | TCP | Premier SQL Middleware Server | - | 2022-02-15 |
| - | 38638 | - | Reserved | - | - |
// source: IANA service name and port number registry
Which program uses port 38638, and is it reachable?
Linux
sudo ss -ltnup 'sport = :38638' # process listening on 38638
sudo lsof -nP -i :38638macOS
sudo lsof -nP -i :38638
Windows (PowerShell)
Get-NetTCPConnection -LocalPort 38638 -State Listen | Select LocalAddress, OwningProcess Get-NetUDPEndpoint -LocalPort 38638 netstat -ano | findstr :38638
From another machine
nmap -p 38638 -sV <host> nc -zv <host> 38638
Block it in the firewall
sudo ufw deny 38638/tcp # Linux (ufw) New-NetFirewallRule -DisplayName "Block 38638" -Direction Inbound -LocalPort 38638 -Protocol TCP -Action Block # Windows
What is port 38638 used for?
Port 38638 is assigned by IANA to psqlmws (Premier SQL Middleware Server).
Is port 38638 TCP or UDP?
Port 38638 is registered for TCP.
Is it safe to open port 38638?
It depends on the program that listens on it. Open it only for a service you know and only to the networks that need it. Bind the service to localhost or a private network, never to a public address.
How do I check if port 38638 is open?
On Linux run "ss -ltnup 'sport = :38638'", on macOS "lsof -nP -i :38638", and on Windows "netstat -ano | findstr :38638" to see the local process. From another machine, "nmap -p 38638 <host>" shows whether it is reachable.
Other databases & caches ports
:3306 MySQL / MariaDB tcp · udp · high risk :1433 Microsoft SQL Server tcp · udp · high risk :5432 PostgreSQL tcp · udp · high risk :6379 Redis tcp · critical risk :27017 MongoDB tcp · critical risk :9200 Elasticsearch tcp · udp · critical risk :1521 Oracle Database tcp · udp · high risk :11211 Memcached tcp · udp · high risk