[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[AWIPS #YED-418649]: CAVE Product Browser - grid data linventory



Hi Pete,

I'm talking about tables in the postgres database.
The issue is CAVE is querying the database for the Product Browser and that's 
how it's 
populating its inventory.  When EDEX decodes data it can produce either/and 
hdf5 files
(which you already removed), and database entries (new rows, in existing 
tables, in the
postgres database).

To see the data you need to log into the database:
 psql -U awips metadata

Then you can do 
 \d
to see a list of all the available tables

There you will see a table named 'grid' and a table named 'grid_info'.

If you want to remove all the data you can simply delete everything in those 
tables
 delete from grid;
 delete from grid_info;

But if you only want to remove the one product you've taken out, then you'll 
need to 
look at the tables:

 select * from grid_info limit 10;

This will show you what information is available in the the table, and I 
suspect with 
datasetid and parameter_abbreviation, you should be able to find the ones that 
are
specific to the dataset you want to remove.  Then you can remove those specific 
entry/
entries:
  delete from grid_info where id=x;  (you would find the id by the previous 
step)
And then remove the corresponding entry/entries from the grid table:
  delete from grid where info_id=x;  (the same x)

Although, all of this will probably be a mute point soon, assuming your purge 
rules aren't
too long, because I think the purge rules will eventually remove your old data 
as well,
and if you aren't bringing in that product anymore, then it won't show up in 
the Product
Browser once they've been purged.

Please let me know if this makes sense.


--Shay Carter

She/Her/Hers
AWIPS Software Engineer
UCAR - Unidata

If you're interested, please feel free to fill out a survey about the support 
you receive: 
https://docs.google.com/forms/d/e/1FAIpQLSeDIkdk8qUMgq8ZdM4jhP-ubJPUOr-mJMQgxInwoAWoV5QcOw/viewform

Ticket Details
===================
Ticket ID: YED-418649
Department: Support AWIPS
Priority: Normal
Status: Open
===================
NOTE: All email exchanges with Unidata User Support are recorded in the Unidata 
inquiry tracking system and then made publicly available through the web.  If 
you do not want to have your interactions made available in this way, you must 
let us know in each email you send to us.