Vertica Log File
Moderator: NorbertKrupa
Vertica Log File
Can you pls let me know where I can find the Vertica log file that is synonymous with Oracle alert log?
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Vertica Log File
Hi,
The log file in vertica is called vertica.log. It is located on the server in the directory defined as /catalog-path/database-name/node-name_catalog.
You can verify the location of your log file via the admintools utility. Go to the Configuration Menu/View Database menu selection and then choose your database. After clicking "ok" you'll see your node's log file listed after the "Database Log" caption.
Alternatively, you can query the disk_storage system table to get the general path for the log file:
You're log file will be located in directory returned from the storage_path column, minus the "Catalog" directory... So in my example, the log file is /usr/local/data/intersect/v_intersect_node0001_catalog/vertica.log.
The log file in vertica is called vertica.log. It is located on the server in the directory defined as /catalog-path/database-name/node-name_catalog.
You can verify the location of your log file via the admintools utility. Go to the Configuration Menu/View Database menu selection and then choose your database. After clicking "ok" you'll see your node's log file listed after the "Database Log" caption.
Alternatively, you can query the disk_storage system table to get the general path for the log file:
Code: Select all
dbadmin=> select storage_usage, storage_path from disk_storage where storage_usage = 'CATALOG';
storage_usage | storage_path
---------------+----------------------------------------------------------------
CATALOG | /usr/local/data/intersect/v_intersect_node0001_catalog/Catalog
CATALOG | /usr/local/data/intersect/v_intersect_node0002_catalog/Catalog
CATALOG | /usr/local/data/intersect/v_intersect_node0003_catalog/Catalog
(3 rows)
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.