{"id":1692,"date":"2018-08-18T00:22:12","date_gmt":"2018-08-18T05:22:12","guid":{"rendered":"http:\/\/creativapixel.com\/?p=1692"},"modified":"2018-08-18T00:34:38","modified_gmt":"2018-08-18T05:34:38","slug":"backup-postgresql-con-cronjob-en-cpanel-hosting","status":"publish","type":"post","link":"https:\/\/creativapixel.com\/blog\/backup-postgresql-con-cronjob-en-cpanel-hosting\/","title":{"rendered":"Backup PostgreSQL con cronjob en cpanel hosting"},"content":{"rendered":"<p>Tambi\u00e9n es importante si usamos postgresql en nuestro hosting realizar nuestras respectivos backups. Para eso ingresamos al cpanel y nos vamos a crear una tarea programada.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1693\" src=\"http:\/\/creativapixel.com\/wp-content\/uploads\/2018\/08\/cronjob-postgresql.png\" alt=\"\" width=\"694\" height=\"618\" srcset=\"https:\/\/creativapixel.com\/blog\/wp-content\/uploads\/2018\/08\/cronjob-postgresql.png 694w, https:\/\/creativapixel.com\/blog\/wp-content\/uploads\/2018\/08\/cronjob-postgresql-300x267.png 300w\" sizes=\"auto, (max-width: 694px) 100vw, 694px\" \/><\/p>\n<p>Esta tarea programada ejecutar\u00e1 un archivo .sh a las 6am que contendr\u00e1 el c\u00f3digo que realizar\u00e1 el backup de nuestra bd en postgresql.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">export PGUSER='usuario'\r\nexport PGPASSWORD='clave'\r\nFECHA_ACTUAL=`date +%Y-%m-%d`\r\nHORA_ACTUAL=`date +%H:%M`\r\nARCH_RESP=$FECHA_ACTUAL-$HORA_ACTUAL\r\npg_dump -Fc NombreBD &gt; \/home\/ruta\/backup_$ARCH_RESP.backup\r\nunset PGUSER\r\nunset PGPASSWORD<\/pre>\n<p>De esta manera tendremos una respaldo y dormiremos tranquilos \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tambi\u00e9n es importante si usamos postgresql en nuestro hosting realizar nuestras respectivos backups. Para eso ingresamos al cpanel y nos vamos a crear una tarea programada. Esta tarea programada ejecutar\u00e1 &#8230;<\/p>\n","protected":false},"author":1,"featured_media":1696,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[39,23,32],"tags":[],"class_list":["post-1692","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cpanel","category-postgresql","category-seguridad"],"_links":{"self":[{"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/posts\/1692","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=1692"}],"version-history":[{"count":1,"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/posts\/1692\/revisions"}],"predecessor-version":[{"id":1694,"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/posts\/1692\/revisions\/1694"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/media\/1696"}],"wp:attachment":[{"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/media?parent=1692"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/categories?post=1692"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/tags?post=1692"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}