Respaldos Automáticos de Base de Datos ProstgreSQL y Envìo de Notificaciones Vìa Mail.
Fecha
2010-10-11
Autores
Título de la revista
ISSN de la revista
Título del volumen
Editor
Universidad de Guayaquil. Facultad de Ciencias Matematicas y Fisicas. Carrera de Ingeniería en Sistemas Computacionales. Carrera de Ingeniería en Networking y Telecomunicaciones.
Resumen
En un esquema global la tecnología tiende a incrementar la cobertura de los servicios
que a una empresa se le ofrece, sobre bases de datos más amplias y con costos
reducidos.
Actualmente las bases de datos han ayudado al manejo de estructuras de datos más
robusto.
Las empresas en su afán de incrementar la automatización y reducir tiempo de
respuesta a soluciones y costo, demandan procesos óptimos que permitan explotar al
máximo los beneficios de las bases de datos cualquiera que sea, en el campo de la
administración y seguridad empresarial, en nuestro medio contamos con
herramientas capaces de optimizar el entorno del administrador y dar mejores
soluciones a la misma.
Uno de los inconvenientes en el ámbito administrativo de base de datos es que no se
cuenta con procesos que proporcionen un seguimiento completo del manejo de
respaldo y recuperación, en este trabajo propongo realizar procesos de respaldos
automáticos en sistemas operativos Windows y Linux, y notificar al administrador
vía mail de los sucesos de dichos respaldos en PostgreSQL y a su vez el
administrador pueda consultar el historial de dicho sucesos por mail.
Nowadays tendencies of global technology are expand their services, this is taken by enterprise to offer new and better data base products with improved options and reduced costs. Data bases have become a very helpful and powerful tool to handle complex data structures. Organizations in order to achive their goals always are trying to reduce times of response and searching solutions to reduce costs, they want succesful processes that allow them obtain the highest benefits using data bases tools, tough in administratives and security departments. In our field we have tools capable to optimize the administrator's environment and bring solutions to itself. one problem we find inside data bases's administrative environment, that is we do not count with process to define a complete structure of checking on backup's and restore process, which for i have taken this alternative to develop those process named automatic backups on operative systems like Windows and Linux. This process involve to send a notification e-mail with all process and logs about PostgreSQL backups also these administrator can request every log of incidents sending by e-mail.
Nowadays tendencies of global technology are expand their services, this is taken by enterprise to offer new and better data base products with improved options and reduced costs. Data bases have become a very helpful and powerful tool to handle complex data structures. Organizations in order to achive their goals always are trying to reduce times of response and searching solutions to reduce costs, they want succesful processes that allow them obtain the highest benefits using data bases tools, tough in administratives and security departments. In our field we have tools capable to optimize the administrator's environment and bring solutions to itself. one problem we find inside data bases's administrative environment, that is we do not count with process to define a complete structure of checking on backup's and restore process, which for i have taken this alternative to develop those process named automatic backups on operative systems like Windows and Linux. This process involve to send a notification e-mail with all process and logs about PostgreSQL backups also these administrator can request every log of incidents sending by e-mail.
Descripción
Adobe
Palabras clave
RESPALDOS AUTOMÁTICOS, NOTIFICACIONES, MAIL, POSTGRESQL