GENI-NSF / geni-ch

GENI clearinghouse services
Other
3 stars 6 forks source link

Remove InstaGENI FOAM aggregates #514

Closed tcmitchell closed 8 years ago

tcmitchell commented 8 years ago

Per the GPO Ops/Infra group, remove all the InstaGENI FOAM aggregates.

Remove InstaGENI FOAM aggregates from data/sr/aggdata.csv, make corresponding changes in data/Makefile.am, and remove related certificates in data/sr/certs.

To delete existing InstaGENI FOAM aggregates in a live service registry:

begin;

-- delete associated attributes first
delete from service_registry_attribute
  where service_id in (select id from service_registry
                       where service_type = 0
                         and short_name like '%-ig-of');

-- delete the SSL certificates
delete from service_registry
  where service_type = 7 and short_name like '%-ig-of';

-- delete the aggregates
delete from service_registry
  where service_type = 0 and short_name like '%-ig-of';

-- verify none left
select * from service_registry where short_name like '%-ig-of';

commit;
tcmitchell commented 8 years ago

Closed by #515