operations:db_ncedc:db_switch
How to switch the application database
- SeismiQuery: [Oracle]
- Log on quake as dcmgr and go to /home/dcmgr/DBswitch/
- Run switch2dcucb.csh or switch2publicdb.csh
- [To change nightly calendars building, Update the DB_CONNECT variable in the /home/httpd/sq-cgi-bin/calendars/SeismiQuery.csh file].
- FDSN Event WS (EGS) & FDSN Station WS (xml): [Oracle]
- Log on slip & transform as dcmgr and go to /home/tomcat/local/
- Run switch2dcucb.csh or switch2publicdb.csh
- FDSN Event WS (NCSS, DD) & EventData WS: [PostgreSQL]
- Log on slip & transform as dcmgr and go to /home/tomcat/local/
- Run switch2aqmsbkpp.csh or switch2aqmsncpp.csh
- Configuration files: [Oracle]
- Log on hum as root and go to /root/DBswitch/
- Run switch2dcucb.csh or switch2publicdb.csh
- Configuration files: [PostgreSQL]
- Log on hum as root and go to /root/DBswitch/
- Run switch2aqmsbkpp.csh or switch2aqmsncpp.csh
- /share/apps/bin/dbselect.conf: [PostgreSQL]
- Is used by dbselect, Web Catalog Search, Cross-Section Map & Hypoinverse Catalog Generation.
- /share/apps/bin/connect.properties: [Oracle]
- Is used by avail_wf.
- /share/apps/bin/connect.properties.egs: [Oracle]
- Is used by EGS Web Catalog Search.
- /share/apps/lib/dbsetup.pl: [Oracle]
operations/db_ncedc/db_switch.txt · Last modified: 2024/05/15 13:34 by stephane