The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

How to delete VMart example database in vertica dockerized version

vaishnavav99vaishnavav99 Community Edition User

I have tried to delete VMart example DB both from admin panel as well as using script
But when ever the container restarts the VMart data base respawns.
Can someone help me with this.
Thanks in Advance


  • marcothesanemarcothesane - Select Field - Administrator

    I take it that you took the docker image from the Docker hub, in that case.

    That docker image always creates a Vertica database from scratch, and populates it with the tables of the VMart example.

    Both the operations you describe drop the database.

    With the script, you keep the docker image - with the Vertica software, but your database ceases to exist.


    • find all tables that belong to the VMart schema, for example, with the command vsql -c "\dt *.*", and drop them.


    • on the docker image without the Vertica database, run: admintools, as user dbadmin. In the appearing menu, go to Configuration Menu, there, select "Create Database", and follow the instructions there.
  • vaishnavav99vaishnavav99 Community Edition User

    I have tried the same, I have created a new database, and stopped Vmart, started the new DB. Then deleted Vmart DB but once the container restarts, I find Vmart to be running and the new DB to be in stopped status.

  • vaishnavav99vaishnavav99 Community Edition User

    I've been through this again, and I was able to figure out what I was missing.
    The by default starts VMart DB which is passed as an environment variable.
    To resolve this we can either modify the environment variable or update the script.

  • TLinde6TLinde6 Community Edition User

    Thanks for the answer @vaishnavav99

Leave a Comment

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