To remove the bogus SAS switch entries

Reading Time: < 1 minute

To remove the bogus SAS switch entries from the system catalogs :

1) Shut down NPS: nzstop

2) Connect to postgres database:

Chance are this will not work:

> /nz/kit/sbin/postgres -P -D /nz/data –O system

Try this 1st:

> /nz/kit/sbin/postgres -D /nz/data system –P

3) Delete bad entries, and exit postgres:

delete from _t_hwcomp where hw_hwid=1200;
delete from _t_hwcomp where hw_hwid=1201;
delete from _t_hwcomp where hw_hwid=1202;
delete from _t_hwcomp where hw_hwid=1203;

Issue ctrl-d to exit from single user postgres

4) Start NPS: nzstart

What to read next?