Reuse of SGI O2
1. Introduction
PostgreSQL provides a utility called pg_dump to create a full backup of the database.
# pg_dump web filename.bkp
This command backs up the web database to filename.bkp. This is all that is required to regenerate the complete database and its table structure and the data.
5. SHIFT ALLOWANCE CALCULATION SYSTEM
To put the database deployed on SGI O2 to test, we developed a small application to calculate shift allowance of the shift personnel manning the 24X7 shift in the data centre.
The application was written in classic asp and used the database setup above using ODBC to connect to it.
The shift personnel had to login to the system and mark the shift he was performing. (morning, evening or night)
At the end of a shift schedule, a complete report can be obtained by three mouse clicks for the all the operations personnel which results in saving a lot of time and effort compared to manually making an excel sheet.
Fig: Consolidated statement of shifts performed by personnel of CS(H/w)-GEOPIC
6. ICECAST STREAMING SERVER4
A streaming server is a server which streams music and audio content over a network. The setup below shows how streaming server works:-
The ICES player, icecast2 and Apache webserver all run on a single O2. The client on the network can connect to the webserver on port 8000 using a web-browser. This opens the icecast interface and clicking on a playlist can listen to streaming music over the network
This plays in standard media players like vlc or winamp.
Fig: ICECAST2 interface
7. Conclusion
It has been our endeavor to illustrate that old workstations can be reused for scaled down and custom applications. These applications run smoothly within the available limited computing resources. Besides, these workstations can be used very effectively for imparting training on linux and its applications to students.