{"id":2973,"date":"2020-07-27T19:06:53","date_gmt":"2020-07-27T16:06:53","guid":{"rendered":"http:\/\/surgery.moscow\/smos\/?p=2973"},"modified":"2020-07-27T19:28:50","modified_gmt":"2020-07-27T16:28:50","slug":"postgresql-dump-pg_dump-1c","status":"publish","type":"post","link":"https:\/\/surgery.moscow\/smos\/2020\/07\/27\/postgresql-dump-pg_dump-1c\/","title":{"rendered":"PostgreSQL dump :pg_dump 1c"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u0440\u0435\u0437\u0435\u0440\u0432\u043d\u0430\u044f \u043a\u043e\u043f\u0438\u044f \u0434\u043b\u044f \u0431\u0430\u0437 postgreSQL \u0441 \u043f\u0440\u0438\u043c\u0435\u043d\u0435\u043d\u0438\u0435\u043c \u0443\u0442\u0438\u043b\u0438\u0442\u044b pg_dump<br>\u0421\u043e\u0437\u0434\u0430\u0435\u043c \u0444\u0430\u0439\u043b <strong>pg_backup.sh <\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-<br>!\/bin\/sh<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">PATH=\/etc:\/bin:\/sbin:\/usr\/bin:\/usr\/sbin:\/usr\/local\/bin:\/usr\/local\/sbin<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">PGPASSWORD=&#187;passwd_for_the_db_user&#187;<br>export PGPASSWORD<br>path_to_backup=\/home\/sv\/pg_dump<br>db_user=postgres<br>database=db_1c<br>host=127.0.0.1<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">find $path_to_backup ( -name &#171;<em>-1[^5].<\/em>&#187; -o -name &#171;<em>-[023]?.<\/em>&#187; ) -ctime +91 -delete<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">pg_dump -Fc &#8212;host=$host &#8212;username=$db_user &#8212;dbname=$database | gzip &gt; $path_to_backup\/pg_dump_$(date &#171;+%Y-%m-%d&#187;).sql.gz<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">unset PGPASSWORD<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">___________________________________<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><br>\u0434\u0435\u043b\u0430\u0435\u043c \u0444\u0430\u0439\u043b \u0438\u0441\u043f\u043e\u043b\u043d\u044f\u0435\u043c\u044b\u043c<br><strong>chmod +x<\/strong>  pg_backup.sh<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u0443\u0441\u0442\u0430\u043d\u0430\u0432\u043b\u0438\u0432\u0430\u0435\u043c \u0432\u0440\u0435\u043c\u044f \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u044f:<br><strong>crontab -e<\/strong><br>0 0 * * * \/home\/sv\/pg_dum<strong>p\/pg_backup.sh<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0440\u0435\u0437\u0435\u0440\u0432\u043d\u0430\u044f \u043a\u043e\u043f\u0438\u044f \u0434\u043b\u044f \u0431\u0430\u0437 postgreSQL \u0441 \u043f\u0440\u0438\u043c\u0435\u043d\u0435\u043d\u0438\u0435\u043c \u0443\u0442\u0438\u043b\u0438\u0442\u044b pg_dump\u0421\u043e\u0437\u0434\u0430\u0435\u043c \u0444\u0430\u0439\u043b pg_backup.sh &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-!\/bin\/sh PATH=\/etc:\/bin:\/sbin:\/usr\/bin:\/usr\/sbin:\/usr\/local\/bin:\/usr\/local\/sbin PGPASSWORD=&#187;passwd_for_the_db_user&#187;export PGPASSWORDpath_to_backup=\/home\/sv\/pg_dumpdb_user=postgresdatabase=db_1chost=127.0.0.1 find $path_to_backup ( -name &#171;-1[^5].&#187;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12,22],"tags":[],"class_list":["post-2973","post","type-post","status-publish","format-standard","hentry","category-internet","category-technology"],"_links":{"self":[{"href":"https:\/\/surgery.moscow\/smos\/wp-json\/wp\/v2\/posts\/2973","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/surgery.moscow\/smos\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/surgery.moscow\/smos\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/surgery.moscow\/smos\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/surgery.moscow\/smos\/wp-json\/wp\/v2\/comments?post=2973"}],"version-history":[{"count":4,"href":"https:\/\/surgery.moscow\/smos\/wp-json\/wp\/v2\/posts\/2973\/revisions"}],"predecessor-version":[{"id":2977,"href":"https:\/\/surgery.moscow\/smos\/wp-json\/wp\/v2\/posts\/2973\/revisions\/2977"}],"wp:attachment":[{"href":"https:\/\/surgery.moscow\/smos\/wp-json\/wp\/v2\/media?parent=2973"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/surgery.moscow\/smos\/wp-json\/wp\/v2\/categories?post=2973"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/surgery.moscow\/smos\/wp-json\/wp\/v2\/tags?post=2973"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}