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

[AWIPS #GGK-502350]: question on psql records for models

This archive contains answers to questions sent to Unidata support through mid-2025. Note that the archive is no longer being updated. We provide the archive for reference; many of the answers presented here remain technically correct, even if somewhat outdated. For the most up-to-date information on the use of NSF Unidata software and data services, please consult the Software Documentation first.

  • Subject: [AWIPS #GGK-502350]: question on psql records for models
  • Date: Fri, 24 Jul 2015 13:42:54 -0600
> Michael -
> 
> I have added about 5 models at different time periods. All the models have
> reference files, but they do not all have geospatial records. Since the
> psql records are built based on the time added, I am at a loss on going
> back in time to see when I added the models from earlier time periods.
> 
> Is there a way to clear all the metadata records out, so I can add the new
> models first and find out what their "IDs" are for the geospatial records?
> I figured I could also reinstall awips if need be or ask someone to view
> the grid coverage info on their machine, but I am trying to keep things
> simple and easy if possible.

Yes, clearing metadata for any one data type is easy.  For grid follow these 
steps exactly:

* make sure the LDM is stopped and no more data are being ingested.
* su - awips
* psql metadata

metadata=# delete from grid;
metadata=# delete from grid_info;
metadata=# delete from gridcoverage;
metadata=# \q

The last command exits from psql back to the shell.  Make sure you account of 
the semicolons in the SQL statements.  

After this you will want to rm -rf /awips2/edex/data/hdf5/grid/ and you will 
have a database empty of gridded data, and when you ingest your selected models 
they will be the only records in all three database tables.  The "gridcoverage" 
table is where the geospatial record is stored, with the id linked to in the 
"grid" table.

-Michael



Ticket Details
===================
Ticket ID: GGK-502350
Department: Support AWIPS
Priority: Normal
Status: Open