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	`AND` `and` `+` (plus symbol) `&` (ampersand)	`cat AND dog` `"cat food"+milk` `"cat food"&"dog food"`
Either word in a topic	`OR` `or` `\|` (pipe)	`cat OR dog` `cat \| dog`
Topics that do not contain a specific word or phrase	`NOT` `not` `!` (exclamation point)	`NOT cat` `! dog`
Topics that contain one string and do not contain another	`^` (caret)	`cat ^ mouse`
A combination of search types	`( )` parentheses	`cat + (dog \| mouse)` `cat \| dog + (! mouse)`

Universal CMDB11.0

Use > Database > Deploying the PostgreSQL Server Database > Overview of PostgreSQL Server Deployment > Initialize the PostgreSQL Server

Initialize the PostgreSQL Server

If you choose to not configure the UCMDB Server with the PostgreSQL database at the time of UCMDB installation, you can initialize the PostgreSQL database and create the database service according the following instructions:

Note Initializing the PostgreSQL database and creating the database service is necessary only if you want to use the local PostgreSQL as an alternative to Oracle/MSSQL. It is not mandatory to use the local PostgreSQL; the UCMDB Server functions properly without it.

For Windows:

Note In the following instructions, replace C:\UCMDB\UCMDBServer with the appropriate path.

Download and install vcredist_x64.exe from the Microsoft website.
Run: C:\UCMDB\UCMDBServer\PostgreSQL\pgInitDb.bat username password port

The username, password, and port must be chosen by the user. Verify that the port is free.
Run:
C:\UCMDB\UCMDBServer\PostgreSQL\pgsql\bin\pg_ctl.exe register -N UCMDB_Server_DB -D "C:\UCMDB\UCMDBServer\PostgreSQL\pgsql\data".
Run: sc description UCMDB_Server_DB "UCMDB Database".
Run: net start UCMDB_Local_DB.
Run the configuration wizard, and provide the username, password and port from above.

For Linux:

Note In the following instructions, replace /opt/UCMDB/UCMDBServer with the appropriate path.

Run: find /opt/UCMDB/UCMDBServer/PostgreSQL -type f \( -name "*.sh" -or -name "*.sql" -or -name "*.conf" -or -name "*.cnf" \) -exec dos2unix {} \;
Create the postgres_server group using: /usr/sbin/groupadd -f postgres_server
Create the postgres_server user using: /usr/sbin/useradd -r -g postgres_server postgres_server
Run: rpm -qa | grep -ic postgres

Note If there are other versions of the Postgres RPM package installed on the system, it is recommended to remove them as they may cause conflicts.
Run:

cd /opt/UCMDB/UCMDBServer/PostgreSQL

chmod -R 770 .

chown -R postgres_server .

chgrp -R postgres_server .
Run: runuser -l postgres_server -c "/opt/UCMDB/UCMDBServer/PostgreSQL/pgInitDB.sh username password port"

The username, password, and port must be chosen by the user. Verify that the port is free.
Edit /opt/UCMDB/UCMDBServer/PostgreSQL/pgsql/postgresql.server and replace the string _install_dir_ with the path to the installation folder (for example, /opt/UCMDB/UCMDBServer).
Run:

cd /opt/UCMDB/UCMDBServer/PostgreSQL/pgsql

chmod a+rx ./postgresql.server
Copy /opt/UCMDB/UCMDBServer/PostgreSQL/pgsql/postgresql.server to /etc/init.d/ and rename it to postgresql_server.
Run:

chkconfig --add postgresql_server

/sbin/service postgresql_server start
Run the configuration wizard, and provide the username, password and port from above.

Send Help Center feedback