To prepare a station for auxiliary database installation

Purpose

The following steps describe how to configure a station in advance of auxiliary database software installation.

Note: You require root user privileges on the auxiliary database station.

Note: A leading # character in a command line represents the root user prompt, and is not to be included in a typed command.

Steps
 

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:


10 

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...


11 

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.


12 

Enter the following:

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


13 

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]: 


14 

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!


15 

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

End of steps