Reinstalling packages
In most cases, Vertica automatically reinstalls all default packages when you restart your database for the first time after running the upgrade script. Occasionally, however, one or more packages might fail to reinstall correctly.
To verify that Vertica succeeded in reinstalling all packages:
-
Restart the database after upgrading.
-
Enter a correct password.
If any packages failed to reinstall, Vertica issues a message that specifies the uninstalled packages. You can manually reinstall the packages with admintools or the HTTPS service:
-
To reinstall with admintools, run the
install_package
command with the option--force-reinstall
:$ admintools -t install_package -d db-name -p password -P pkg-spec --force-reinstall
-
To reinstall with the HTTPS service, make a POST request to the
/v1/packages
endpoint on any node in the cluster:Important
Only the dbadmin can access the HTTPS service.$ curl -X POST -k -w "\n" --user dbadmin:password "https://ip-address:8443/v1/packages?force-install=true"
The
-w
flag prints information to the console after the command succeeds.
admintools options
Option | Function |
---|---|
-d db-name --dbname= *db-name |
Database name |
-p password --password= pword |
Database administrator password |
-P pkg --package= pkg-spec |
Specifies which packages to install, where
|
--force-reinstall |
Force installation of a package even if it is already installed. |
Examples
Force reinstallation of default packages:
$ admintools -t install_package -d VMart -p 'password' -P default --force-reinstall
Force reinstallation of one package, flextable
:
$ admintools -t install_package -d VMart -p 'password' -P flextable --force-reinstall