Trying to overwrite '/opt/vertica/bin/vsql', which is also in package vertica-client-fips 9

alexei28

I try to install vertica 9.1

sudo dpkg -i vertica_9.1.1-4_amd64.deb

but get error

(Reading database ... 376044 files and directories currently installed.)
Preparing to unpack vertica_9.1.1-4_amd64.deb ...
Unpacking vertica (9.1.1-4) ...
dpkg: error processing archive vertica_9.1.1-4_amd64.deb (--install):
trying to overwrite '/opt/vertica/bin/vsql', which is also in package vertica-client-fips 9.1.1-1
dpkg-deb: error: paste subprocess was killed by signal (Broken pipe)
Processing triggers for libc-bin (2.31-0ubuntu9.2) ...
Errors were encountered while processing:
vertica_9.1.1-4_amd64.deb

How I can remove package vertica-client-fips 9.1.1-1 ?

mosheg

You might need only to remove one old package or a full cleanup to ensure you can perform later a fresh Vertica installation.

In general, before uninstalling Vertica in production always ensure that you have a backup or a full data export.
Backing up your data prior to package uninstall is critical.
The following uninstall instructions will delete also any data in the Database if any exists.
It may also affect data contained outside of the app's direct components or functionality.

First carefully review the "Uninstalling Vertica" paragraph here:
https://www.vertica.com/docs/9.1.x/HTML/index.htm#Authoring/InstallationGuide/Other/UninstallingVertica.htm

If full cleanup is required do the following to uninstall Vertica Enterprise Edition (on Ubuntu/Debian systems).
Do the following commands ON ALL NODES

1.  login to root                                                                      ==> su - root
2.  Stop spread                                                                    ==> pkill -9 spread
3.  kill any Vertica proc                                                     ==> pkill -9 vertica
4.  Find the name of the package that is installed ==> dpkg -l | grep -i vertica
        OR                                                                                      ==> ls -l /var/lib/dpkg/info | grep -i vertica
5.  Remove the package                                                  ==> dpkg --remove your_packagename
        If needed to remove it forcefully do                    ==> dpkg -r --force-all pkg_name
        Once all done, run the command                          ==> dpkg -l | grep -i vertica 
        and make sure it does not return a valid value.
6.  Delete   /opt/vertica    directory         ==>  rm -rf /opt/vertica
7.  Delete   /opt/vconsole directory      ==>  rm -rf /opt/vconsole
8.  Delete any Data directory                 ==>  rm -rf <data_dir>
9.  Delete any Catalog directory           ==> rm -rf <catalog_dir>
10. Delete any files in /tmp                        ==> rm -rf /tmp/*