{"id":8031,"date":"2025-06-15T23:24:00","date_gmt":"2025-06-15T16:24:00","guid":{"rendered":"https:\/\/longvan.net\/cong-dong\/?p=8031"},"modified":"2025-06-17T15:02:18","modified_gmt":"2025-06-17T08:02:18","slug":"huong-dan-restore-du-lieu-postgresql-bang-bussiness-backup-tren-linux","status":"publish","type":"post","link":"https:\/\/longvan.net\/cong-dong\/huong-dan-restore-du-lieu-postgresql-bang-bussiness-backup-tren-linux\/","title":{"rendered":"H\u01b0\u1edbng D\u1eabn Restore D\u1eef Li\u1ec7u Postgresql B\u1eb1ng Bussiness Backup Tr\u00ean linux"},"content":{"rendered":"<p>Sau \u0111\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn thao t\u00e1c restore backup c\u1ee7a PostgreSql tr\u00ean server linux<\/p>\n<p><strong>B\u01b0\u1edbc 1 : Ki\u1ec3m tra c\u00e1c b\u1ea3n backup hi\u1ec7n c\u00f3 :<\/strong><\/p>\n<ul>\n<li>Ki\u1ec3m tra tr\u00ean trang qu\u1ea3n l\u00fd Businessbk.longvan.net\n<ul>\n<li>Login v\u00e0o trang businessbk.longvan.net<\/li>\n<li>V\u00e0o m\u1ee5c\u00a0<strong>User &gt; Report &gt; Backup Report for This User\u00a0<\/strong><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-8032 aligncenter\" src=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/06\/Screenshot_51-1024x253.png\" alt=\"\" width=\"1024\" height=\"253\" srcset=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/06\/Screenshot_51-1024x253.png 1024w, https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/06\/Screenshot_51-300x74.png 300w, https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/06\/Screenshot_51-768x190.png 768w, https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/06\/Screenshot_51-1536x380.png 1536w, https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/06\/Screenshot_51.png 1590w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/li>\n<li>ch\u1ecdn b\u1ea3n backup c\u1ea7n mu\u1ed1n thao t\u00e1c restore.<\/li>\n<li>L\u01b0u \u00fd ch\u00ednh x\u00e1c ng\u00e0y gi\u1edd \u0111\u1ec3 s\u1eed d\u1ee5ng cho vi\u1ec7c c\u1ea5u h\u00ecnh file restore<\/li>\n<li>V\u00ed d\u1ee5: Th\u1eddi gian b\u1ea3n backup nh\u01b0 h\u00ecnh s\u1ebd c\u00f3 \u0111\u1ecbnh d\u1ea1ng 2025-06-15-21-04-27<img loading=\"lazy\" decoding=\"async\" class=\" wp-image-8033 aligncenter\" src=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/06\/Screenshot_52.png\" alt=\"\" width=\"586\" height=\"426\" srcset=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/06\/Screenshot_52.png 741w, https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/06\/Screenshot_52-300x218.png 300w\" sizes=\"auto, (max-width: 586px) 100vw, 586px\" \/><\/li>\n<li><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-8034 aligncenter\" src=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/06\/Screenshot_53.png\" alt=\"\" width=\"591\" height=\"197\" srcset=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/06\/Screenshot_53.png 591w, https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/06\/Screenshot_53-300x100.png 300w\" sizes=\"auto, (max-width: 591px) 100vw, 591px\" \/><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><strong>B\u01b0\u1edbc 2: C\u1ea5u h\u00ecnh file restore Restore.sh<\/strong><\/p>\n<ul>\n<li>M\u1edf file c\u1ea5u h\u00ecnh Restore.\n<ul>\n<li># nano \/usr\/local\/obm\/bin\/Restore.sh<\/li>\n<\/ul>\n<\/li>\n<li>T\u00f9y ch\u1ec9nh c\u00e1c th\u00f4ng s\u1ed1 c\u1ea5u h\u00ecnh nh\u01b0 sau:\n<ul>\n<li>BACKUP_SET=&#8221;PostgreSQL Backup linux&#8221; # nh\u1eadp t\u00ean backup set<\/li>\n<li>DESTINATION=&#8221;&#8221;<\/li>\n<li>RESTORE_TO=&#8221;&#8221; # nh\u1eadp \u0111\u01b0\u1eddng d\u1eabn folder \u0111\u00e3 backup , \u0110\u1ec3 tr\u1ed1ng \u0111\u1ec3 kh\u00f4i ph\u1ee5c v\u1ec1 v\u1ecb tr\u00ed g\u1ed1c<\/li>\n<li>RESTORE_FROM=&#8221;PostgreSQL&#8221; # nh\u1eadp \u0111\u01b0\u1eddng d\u1eabn folder nh\u1eadn d\u1eef li\u1ec7u restore<\/li>\n<li>POINT_IN_TIME=&#8221;2025-06-15-21-04-27&#8243; # nh\u1eadp b\u1ea3n backup point, ho\u1eb7c m\u1eb7c \u0111\u1ecbnh l\u00e0 Current (b\u1ea3n m\u1edbi)<\/li>\n<li>RESTORE_PERMISSION=&#8221;Y&#8221; # ch\u1ecdn Y \u0111\u1ec3 restore lu\u00f4n c\u1ea3 ph\u00e2n quy\u1ec1n c\u1ee7a file restore<\/li>\n<li>TEMP_DIR=&#8221;\/tmp&#8221; #n\u01a1i l\u01b0u tr\u1eef t\u1ea1m th\u1eddi c\u00e1c t\u1ec7p trong qu\u00e1 tr\u00ecnh kh\u00f4i ph\u1ee5c<\/li>\n<li>VERIFY_CHKSUM=&#8221;Y&#8221; #ki\u1ec3m tra \u0111\u1ed9 to\u00e0n v\u1eb9n d\u1eef li\u1ec7u trong qu\u00e1 tr\u00ecnh kh\u00f4i ph\u1ee5c<img loading=\"lazy\" decoding=\"async\" class=\" wp-image-8035 aligncenter\" src=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/06\/Screenshot_54.png\" alt=\"\" width=\"525\" height=\"745\" srcset=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/06\/Screenshot_54.png 656w, https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/06\/Screenshot_54-211x300.png 211w\" sizes=\"auto, (max-width: 525px) 100vw, 525px\" \/><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><strong>B\u01b0\u1edbc 3: Th\u1ef1c hi\u1ec7n restore d\u1eef li\u1ec7u.<\/strong><\/p>\n<ul>\n<li>Th\u1ef1c hi\u1ec7n restore v\u1edbi file restore v\u1eeba c\u1ea5u h\u00ecnh\n<ul>\n<li># <em>cd \/usr\/local\/obm\/bin<\/em><\/li>\n<li># <em>.\/Restore.sh<\/em><\/li>\n<\/ul>\n<\/li>\n<li>Ch\u1edd \u0111\u1ee3i qu\u00e1 tr\u00ecnh restore ti\u1ebfn h\u00e0nh, th\u1eddi gian ph\u1ee5 thu\u1ed9c v\u00e0o dung l\u01b0\u1ee3ng d\u1eef li\u1ec7u c\u1ea7n restore.\n<ul>\n<li>Sau khi Restore xong s\u1ebd hi\u1ec7n d\u00f2ng nh\u01b0 sau:<img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-8037 aligncenter\" src=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/06\/Screenshot_55.png\" alt=\"\" width=\"984\" height=\"181\" srcset=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/06\/Screenshot_55.png 984w, https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/06\/Screenshot_55-300x55.png 300w, https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/06\/Screenshot_55-768x141.png 768w\" sizes=\"auto, (max-width: 984px) 100vw, 984px\" \/><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><strong>B\u01b0\u1edbc 4: Ki\u1ec3m tra l\u1ea1i d\u1eef li\u1ec7u.<\/strong><\/p>\n<ul>\n<li>Ki\u1ec3m tra tr\u1ef1c ti\u1ebfp l\u1ea1i d\u1eef li\u1ec7u xem \u0111\u00e3 restore \u0111\u1ea7y \u0111\u1ee7 ch\u01b0a\n<ul>\n<li>Ho\u1eb7c truy c\u1eadp trang businessbk.longvan.net V\u00e0o m\u1ee5c\u00a0<strong>User &gt; Report &gt;Restore<\/strong><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-8038 aligncenter\" src=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/06\/Screenshot_56-1024x216.png\" alt=\"\" width=\"1024\" height=\"216\" srcset=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/06\/Screenshot_56-1024x216.png 1024w, https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/06\/Screenshot_56-300x63.png 300w, https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/06\/Screenshot_56-768x162.png 768w, https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/06\/Screenshot_56.png 1464w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady, Long V\u00e2n \u0111\u00e3 ho\u00e0n th\u00e0nh h\u01b0\u1edbng d\u1eabn thao t\u00e1c restore d\u1eef li\u1ec7u PostgreSQL server \u0111\u1ed1i v\u1edbi d\u1ecbch v\u1ee5 Bussiness Backup. Ch\u00fac Qu\u00fd kh\u00e1ch th\u00e0nh c\u00f4ng!<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" id=\"image-hover-icon\" style=\"position: absolute;width: 25px;height: 25px;cursor: pointer;left: 219.4px;top: 171px;opacity: 0.7\" src=\"\/\/pbhpcbdjngblklnibanbkgkogjmbjeoe\/src\/public\/images\/128px.png\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sau \u0111\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn thao t\u00e1c restore backup c\u1ee7a PostgreSql tr\u00ean server linux B\u01b0\u1edbc 1 : Ki\u1ec3m tra c\u00e1c b\u1ea3n backup hi\u1ec7n c\u00f3 : Ki\u1ec3m tra tr\u00ean trang qu\u1ea3n l\u00fd Businessbk.longvan.net Login v\u00e0o trang businessbk.longvan.net V\u00e0o m\u1ee5c\u00a0User &gt; Report &gt; Backup Report for This User\u00a0 ch\u1ecdn b\u1ea3n backup c\u1ea7n mu\u1ed1n thao t\u00e1c restore. L\u01b0u [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_oasis_is_in_workflow":0,"_oasis_original":0,"footnotes":""},"categories":[18],"tags":[],"class_list":["post-8031","post","type-post","status-publish","format-standard","hentry","category-bussiness-backup"],"_links":{"self":[{"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/posts\/8031","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/comments?post=8031"}],"version-history":[{"count":4,"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/posts\/8031\/revisions"}],"predecessor-version":[{"id":8051,"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/posts\/8031\/revisions\/8051"}],"wp:attachment":[{"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/media?parent=8031"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/categories?post=8031"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/tags?post=8031"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}