{"id":1558,"date":"2017-11-13T02:17:20","date_gmt":"2017-11-13T07:17:20","guid":{"rendered":"http:\/\/creativapixel.com\/?p=1558"},"modified":"2017-11-13T11:35:48","modified_gmt":"2017-11-13T16:35:48","slug":"backup-automatico-de-postgresql-en-centos","status":"publish","type":"post","link":"https:\/\/creativapixel.com\/blog\/backup-automatico-de-postgresql-en-centos\/","title":{"rendered":"Backup autom\u00e1tico de PostgreSQL en CentOS"},"content":{"rendered":"<p>Todo sistema inform\u00e1tico debe contar por seguridad con un sistema de backups autom\u00e1ticos que nos permitan respaldar la informaci\u00f3n en caso de alg\u00fan da\u00f1o en el sistema operativo o hardware. En este caso realizare el ejemplo es un backup autom\u00e1tico de postgresql usando CRON como tareas programadas.<\/p>\n<p>Ya en otro post explicare como enviar este backup a otra pc o servidor para completar la seguridad. Primero modificaremos postgresql para que pueda realizar cambios localmente modificar<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">nano \/var\/lib\/pgsql\/9.4\/data\/pg_hba.conf<\/pre>\n<p>si no ubican el archivo pueden usar<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">locate pg_hba.conf<\/pre>\n<p>editar la linea para el acceso local<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">local     all     all     md5<\/pre>\n<p>creamos nuestro archivo backup.sh con permisos 777 en la ruta \/home\/admin\/backup y agregamos las siguientes lineas:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">export PGUSER='postgres'\r\nexport PGPASSWORD='pgsql123'\r\nFECHA_ACTUAL=`date +%Y-%m-%d`\r\nHORA_ACTUAL=`date +%H:%M`\r\nARCH_RESP=$FECHA_ACTUAL-$HORA_ACTUAL\r\npg_dump\u00a0-Fc\u00a0bdmuni\u00a0&gt;\u00a0\/home\/admin\/backup\/backup_$ARCH_RESP.backup\r\nunset PGUSER\r\nunset PGPASSWORD<\/pre>\n<p>Podemos agregar otra linea para eliminar backups de mas de 2 dias para ahorrar espacio<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">find \/home\/admin\/backup\/ -name '*.backup' -mtime +2 -exec rm -f {};<\/pre>\n<p>guardamos y salimos de backup.sh<\/p>\n<p>Ahora agregamos la tarea programada en CRON:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">crontab -e<\/pre>\n<p>Agregamos las l\u00ednea:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">0 13 * * * \/home\/admin\/backup\/backup.sh<\/pre>\n<p>Esta l\u00ednea permite hacer un backup a las 13 hs con 00 minutos todos los dias de todos los meses de todos los a\u00f1os.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Todo sistema inform\u00e1tico debe contar por seguridad con un sistema de backups autom\u00e1ticos que nos permitan respaldar la informaci\u00f3n en caso de alg\u00fan da\u00f1o en el sistema operativo o hardware. &#8230;<\/p>\n","protected":false},"author":1,"featured_media":1560,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17,23,32],"tags":[33,34],"class_list":["post-1558","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-centos","category-postgresql","category-seguridad","tag-backup-postgresql","tag-centos"],"_links":{"self":[{"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/posts\/1558","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/comments?post=1558"}],"version-history":[{"count":4,"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/posts\/1558\/revisions"}],"predecessor-version":[{"id":1563,"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/posts\/1558\/revisions\/1563"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/media\/1560"}],"wp:attachment":[{"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/media?parent=1558"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/categories?post=1558"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/tags?post=1558"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}