Log in as the root user on the auxiliary database station.

Open a console window.

Add a hostname entry for the new station to the /etc/hosts file on the new station using the following criteria:

• The first entry for the station hostname in the file must be the station IP address that is reachable by each main server.

• The hostname must be the fully qualified hostname, and not the short hostname.

• The hostname must:

  • contain only ASCII alphanumeric and hyphen characters.

  • not begin or end with a hyphen.

  • not begin with a number.

  • comply with the format defined in IETF RFC 1034.

  • use period characters delimit the FQDN components.

  • not exceed 63 characters.

Note: Hostnames are case-sensitive.

Perform To apply the RHEL 8 swappiness workaround on the station.

Download the following installation files to an empty local directory:

Note: You must ensure that the directory is empty.

Note: In subsequent steps, the directory is called the software directory.

• nspos-auxdb-R.r.p-rel.v.rpm

• VerticaSw_PreInstall.sh

• nspos-jre-R.r.p-rel.v.rpm

• vertica-R.r.p-rel.tar

where

R.r.p is the NSP release identifier, in the form MAJOR.minor.patch

v is a version number

Navigate to the software directory.

Note: The directory must contain only the installation files.

Enter the following:

# chmod +x * ↵

Enter the following:

# ./VerticaSw_PreInstall.sh ↵

The script displays configuration messages like the following, and a prompt:

INFO: About to set kernel parameters in /etc/sysctl.conf...

INFO: Completed setting kernel parameters in /etc/sysctl.conf...

INFO: About to change the current values of the kernel parameters INFO:

Completed changing the current values of the kernel parameters

INFO: About to set ulimit parameters in /etc/security/limits.conf...

INFO: Completed setting ulimit parameters in /etc/security/limits.conf...

Checking Vertica DBA group samauxdb... 

Adding Vertica DBA group samauxdb... 

Checking Vertica user samauxdb... 

Adding samauxdb... 

Set password for samauxdb...

New password:

Enter a password that conforms to the RHEL password criteria.

The following prompt is displayed:

Retype new password:

Re-enter the password.

Messages like the following are displayed:

Changing password for user samauxdb.

passwd: all authentication tokens updated successfully.

Changing ownership of the directory /opt/nsp/nfmp/auxdb to samauxdb:samauxdb.

Adding samauxdb to sudoers file.

Changing ownership of /opt/nsp/nfmp/auxdb files.

INFO: About to add setting to /etc/rc.d/rc.local...

INFO: Completed adding setting to /etc/rc.d/rc.local...

If the script instructs you to perform a restart, perform the following steps.

1. Enter the following:

   # systemctl reboot ↵

   The station reboots.

2. When the reboot is complete, log in to the station as the root user.

3. Open a console window.

4. Navigate to the software directory.

Enter the following:

# tar xvf vertica-R.r.p-rel.tar $(tar tf vertica-R.r.p-rel.tar | sort -V | tail -1) ↵

Enter the following:

# dnf install *.rpm ↵

The dnf utility resolves any package dependencies, and displays the following prompt for each package:

Total size: nn G

Installed size: nn G 

Is this ok [y/d/N]: 

Enter y. The following and the installation status are displayed as each package is installed:

Downloading Packages:

Running transaction check

Transaction check succeeded.

Running transaction test

Transaction test succeeded.

Running transaction check

The package installation is complete when the following is displayed:

Complete!

When the package installation is complete, close the console window.

End of steps