The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Questions regarding new vertica installation on centOS 7

Hi
I am new to this. I wanted to make familiar myself with vertica. And due to this I have some questions regarding installation.
I downloaded vertica community edition vertica-9.2.1-0.x86_64.RHEL6.rpm
(installer says "...RHEL6.rpm", but actually this is the only one that I got from vertica website)
Installed this rpm on CentOS 7.6

I did all the necessary requirements. I decided to use LVM for the vertica data directory.

Then created cluster
# /opt/vertica/sbin/install_vertica --hosts <<hostname>> --rpm vertica-9.2.1-0.x86_64.RHEL6.rpm --data-dir /vertica
I then created database.

What I did notice, with the rpm installation I get 2 vertica systemd services

  • verticad (not running at all, not enabled) - cannot start/stop it, service still shows inactive.
    verticad service looks like this:

    cat /etc/systemd/system/verticad.service
    [Unit]
    Description=Vertica server restart oneshot
    [Service]
    Type=oneshot
    ExecStart=/opt/vertica/sbin/verticad start
    SuccessExitStatus=1
    [Install]
    WantedBy=multi-user.target

  • vertica_agent (running), and this cane be start/stop by systemd service.

What is the purpose of the above 2 services..?
And can I modify this verticad service so that this service will actually start/stop my database..?

So, at this time, I have come to conclude, that vertica can only be started with the following command
# su - dbadmin -c "admintools -t start_db -d mydb"

What is the difference in using either of these:

  • $ admintools -t stop_host ...
  • $ admintools -t stop_node ...

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.