Where does actual vertica DB file and projection data save on Linux host?

LakshmiNarayan · June 2020

 under which path physical db saves? and where does projection data saves? [ assume disk mounted as /data ]

if backup is taken , then would backup holds only actual DB or projection data too?
any documentation available on above details?

marcothesane · June 2020

This is what I can see when I list the content of my Vertica mount point:
There is a directory with the same name as my database: sbx
And the content of the sbx are:

drwxr-xr-x   5 dbadmin verticadba   4096 2019-10-30 19:03 ./
drwxr-xr-x  11 dbadmin verticadba   4096 2020-05-30 17:23 ../
-rw-r--r--   1 dbadmin verticadba 148085 2020-06-10 12:10 dbLog
-rw-r--r--   1 dbadmin verticadba      5 2019-10-30 19:03 port.dat
drwx------   2 dbadmin verticadba   4096 2020-02-18 12:08 procedures/
drwx------   9 dbadmin verticadba   4096 2020-06-10 12:09 v_sbx_node0001_catalog/
drwx------ 503 dbadmin verticadba  12288 2020-06-11 08:36 v_sbx_node0001_data/

sbx_node0001_catalog contains the catalogue
sbx_node0001_data contains all data of the database.
Projections are the only place where we store data. They are and are not tablespaces, indexes and materialized views. So, yes, projection data are all the data and the only data backed up.

Sankarmn · June 2020

@LakshmiNarayan, check this - https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/BackupRestore/TypesOfBackups.htm?tocpath=Administrator's Guide|Backing Up and Restoring the Database|Creating Backups|_____1

Where does actual vertica DB file and projection data save on Linux host?

Answers

Leave a Comment