/data/pdw/pdw/v_pdw_node0001_data running out space

[askh01]

Hi,

We're running out of space on the following directories on the Vertica server. Could you please let me know what would be the safest files/directories are in /data to remove to free some space?

Also, is it ok to remove old .pidx and .fdb files?

Thanks,
ASKH

[id10t]

Hi!

>> is it ok to remove old .pidx and .fdb files?
No! Node will fail if you will.

>> Could you please let me know what would be the safest files/directories are in /data to remove to free some space?
No one can answer, since we don't know what you have in it. If this directory used by Vertica only, so nothing can be deleted in the DATA catalog for freeing space. If you have old databases - so delete it, it will free some space.

As work around: try to add additional space for DATA:
Adding Storage Locations
Moving Data Storage Locations
https://my.vertica.com/docs/6.1.x/HTML/ ... #12383.htm

[askh01]

How about /data/backup directory? This directory is being used for backup. Can old backup be removed from this directory to free up some space?

Another question I've how do you verify the last completion backup in Vertica?

Thanks,
ASKH