Path to database files

[nnani]

Hello Everybody,

I cannot find the path to the Database files.
Suppose I have a Database called Stock_Info, so how do I see the the database files for this database where the data is stored?

[JimKnicely]

Navin,

Check out this post:

viewtopic.php?f=5&t=106

Basically, you can query the DISK_STORAGE system table:

Example:

Code: Select all

dbadmin=> select node_name, storage_path from v_monitor.disk_storage where storage_usage = 'DATA';
      node_name       |                  storage_path
----------------------+-------------------------------------------------
 v_intersect_node0001 | /data1/data/intersect/v_intersect_node0001_data
 v_intersect_node0001 | /data2/data/intersect/v_intersect_node0001_data
(2 rows)

[nnani]

Thank you very much.