Searching the Help
To search for information in the Help, type a word or phrase in the Search box. When you enter a group of words, OR is inferred. You can use Boolean operators to refine your search.
Results returned are case insensitive. However, results ranking takes case into account and assigns higher scores to case matches. Therefore, a search for "cats" followed by a search for "Cats" would return the same number of Help topics, but the order in which the topics are listed would be different.
Search for | Example | Results |
---|---|---|
A single word | cat
|
Topics that contain the word "cat". You will also find its grammatical variations, such as "cats". |
A phrase. You can specify that the search results contain a specific phrase. |
"cat food" (quotation marks) |
Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase. |
Search for | Operator | Example |
---|---|---|
Two or more words in the same topic |
|
|
Either word in a topic |
|
|
Topics that do not contain a specific word or phrase |
|
|
Topics that contain one string and do not contain another | ^ (caret) |
cat ^ mouse
|
A combination of search types | ( ) parentheses |
|
- PostgreSQL Server Configuration
- PostgreSQL Parameter Settings
- Critical PostgreSQL Server Files
- How to Configure PostgreSQL on Probe to Accept Local Connections Only
- How to Configure PostgreSQL Log Files Rotation by Size
- Always Exclude PostgreSQL Data Folder from Anti-Virus Scan
- How to Connect UCMDB Server Securely to the PostgreSQL Database with TLS Enabled
- How to Connect UCMDB Server Container to PostgreSQL Database with TLS Enabled
How to Configure PostgreSQL on Probe to Accept Local Connections Only
By default the PostgreSQL instance running on the probe does not need to listen to requests from the network. However, you can perform this additional configuration to bind the PostgreSQL instance on the probe to localhost.
To do so,
-
On the probe, open the following file using a text editor:
UCMDB\DataFlowProbe\conf\postgresql.conf
-
Locate and modify the following file from:
listen_addresses = '*'
to:
listen_addresses = 'localhost'
-
Save the file.
-
Restart the probe.
To restart the probe properly,
- Open services.msc.
- Stop the UCMDB Probe service.
- Stop the UCMDB_Probe_DB service.
- Start the UCMDB_Probe_DB service.
- Start the UCMDB Probe service.
How to Validate If the PostgreSQL Instance Is Listening Only to Localhost?
Validate from a remote PostgreSQL server
To validate that the change to the postgresql.conf file is taking effect successfully, you can run the following PostgreSQL client command from a remote server with PostgreSQL installed:
psql --username="mamuser" --host=<Target DataFlowProbe Host or IP>
When PostgreSQL is listening only to localhost, you will receive a "Connection refused
" message.
Example outputs:
PostgreSQL listening to localhost:
C:\UCMDB\DataFlowProbe\pgsql\bin>psql --username="mamuser" --host=10.10.15.220
psql: could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "10.10.15.220" and accepting
TCP/IP connections on port 5432?
PostgreSQL listening to any host (known as “*” in the postgressql.conf file):
C:\UCMDB\DataFlowProbe\pgsql\bin>psql --username="mamuser" --host=10.10.15.220
psql: FATAL: no pg_hba.conf entry for host "10.10.20.254", user "mamuser", database "mamuser", SSL off
The FATAL
error indicates simply that the pg_hba.conf file is not properly set up, but for the purpose of this test it is sufficient to understand that the connection was successful from a remote host. This would indicate the change to listen_addresses in postgresql.conf was NOT applied properly per the instructions above. Please check those steps again.
Validate using Telnet
If you do not have another PostgresSQL system with psql installed, you can try to Telnet to the PostgresSQL port from a different computer to confirm if the change was applied correctly:
-
Install Telnet.
-
Go to Start > Control Panel > Turn Windows features on or off.
The Windows Features dialog opens.
- Select the check box for Telnet Client.
- Click OK.
-
-
Test connection.
- Open the Command Prompt window by going to Start > Run > cmd and clicking OK.
-
From the Command Prompt window, run the following:
telnet <target host/IP and port>
For example, telnet 10.10.15.220 5432.
If you receive a message like: “
telnet: connect to address <address you specified>: Connection refused
”, it indicates that PostgresSQL is properly configured to refuse remote connections.
We welcome your comments!
To open the configured email client on this computer, open an email window.
Otherwise, copy the information below to a web mail client, and send this email to cms-doc@microfocus.com.
Help Topic ID:
Product:
Topic Title:
Feedback: