{"id":2003,"date":"2019-02-12T17:20:42","date_gmt":"2019-02-12T10:20:42","guid":{"rendered":"https:\/\/www.linuxid.net\/post\/?p=2003"},"modified":"2025-03-28T04:36:12","modified_gmt":"2025-03-27T21:36:12","slug":"tutorial-setup-backup-otomatis-database-odoo","status":"publish","type":"post","link":"https:\/\/www.linuxid.net\/post\/tutorial-setup-backup-otomatis-database-odoo\/","title":{"rendered":"Tutorial Setup Backup Otomatis Database Odoo"},"content":{"rendered":"

Dalam tutorial ini kami akan memandu Anda melalui proses membuat backup secara harian otomatis dari database Odoo. Odoo adalah sistem ERP open-source paling populer yang ditulis dengan Python dan menggunakan PostgreSQL sebagai database\u00a0 back-end.<\/p>\n

Odoo menyimpan datanya dalam database PostgreSQL. Dengan backup database secara teratur akan melindungi Anda dari resiko kehilangan data yang berpotensi bencana dan sangat penting bagi siapa pun dan semua orang yang memiliki instalasi Odoo.<\/p>\n

Odoo database management interface<\/h2>\n

Interface\u00a0database management Odoo menyediakan alat untuk backup, duplikasi, menghapus, membuat, dan memulihkan database.<\/p>\n

Membuat backup menggunakan database management interface adalah hal yang tidak perlu dipikirkan lagi. Cukup buka browser Anda dan arahkan ke http:\/\/server_ip:8069\/web\/database\/manager<\/code><\/em><\/p>\n

Anda akan disajikan layar berikut:<\/p>\n

\"database<\/a><\/p>\n

Klik pada Backup<\/code>\u00a0dan popup baru akan ditampilkan.<\/p>\n

Masukkan database Odoo Master Password Anda dan buat cadangan dengan mengklik tombol Backup<\/code>\u00a0biru.<\/p>\n

Buat Back up Database dari Baris Perintah<\/h2>\n

Sekarang kita tahu cara membuat backup melalui Odoo database management interface, bagaimana kita bisa menggunakan alat yang sama untuk membuat cadangan dari baris perintah? Jawabannya sederhana.\u00a0Gunakan wget<\/code> <\/a>atau curl<\/code><\/a>. Kedua tools ini dapat mengirim data dengan POST yang dapat kita gunakan untuk meneruskan variabel yang diperlukan ke tools database Odoo.<\/p>\n

Dalam contoh di bawah ini, Kata password kami adalah G4NT1_PA$$W0RD<\/code> dan kita akan membuat file bakc up yang bernama\u00a0back_up_filename.zip<\/code> dari database bernama DB_NAME<\/code> yang akan disimpan di direktori backup_dir<\/code>.<\/p>\n

curl -X POST -F 'master_pwd=G4NT1_PA$$W0RD<\/span>' -F 'name=DB_NAME<\/span>' -F 'backup_format=zip' -o \/backup_dir<\/span>\/back_up_filename.zip<\/span> http:\/\/localhost:8069\/web\/database\/backup<\/pre>\n
Jika Anda lebih suka menggunakan wget<\/code> daripada curl<\/code>, Anda dapat menggunakan perintah berikut:<\/p>\n
wget --post-data 'master_pwd=G4NT1_PA$$W0RD<\/span>&name=DB_NAME<\/span>&backup_format=zip' -O \/backup_dir<\/span>\/back_up_filename.zip<\/span> http:\/\/localhost:8069\/web\/database\/backup<\/pre>\n
Jika Anda ingin membuat backup dari lokasi remote (bukan di localhost), Anda perlu memasukkan URL ke instance Odoo Anda. Dalam hal ini disarankan untuk menggunakan HTTPS karena Anda tidak ingin kata sandi Anda dikirimkan melalui Internet sebagai teks biasa.<\/p>\n
Siapkan Backup Odoo Otomatis<\/h2>\n
Untuk mengotomatiskan proses pencadangan dan mencadangkan basis data Odoo kami secara berkala, kami dapat membuat cron job<\/a>.<\/p>\n
Katakanlah kita ingin membuat backup database Odoo setiap hari pukul 01:30 pagi dan menyimpan 7 cadangan terbaru.<\/p>\n
Kita akan membuat script bash sederhana yang dapat Anda beri nama sesuai keinginan:<\/p>\n
nano ~\/backup_odoo.sh<\/pre>\n
#!\/bin\/bash
\n
\n# vars
\nBACKUP_DIR=~\/odoo_backups
\nODOO_DATABASE=N4m4_D4t@b4s3
\nADMIN_PASSWORD=G4NT1_PA$$W0RD
\n
\n# create a backup directory
\nmkdir -p ${BACKUP_DIR}
\n
\n# create a backup
\ncurl -X POST \\
\n    -F \"master_pwd=${ADMIN_PASSWORD}\" \\
\n    -F \"name=${ODOO_DATABASE}\" \\
\n    -F \"backup_format=zip\" \\
\n    -o ${BACKUP_DIR}\/${ODOO_DATABASE}.$(date +%F).zip \\
\n    http:\/\/localhost:8069\/web\/database\/backup
\n
\n
\n# delete old backups
\nfind ${BACKUP_DIR} -type f -mtime +7 -name \"${ODOO_DATABASE}.*.zip\" -delete<\/pre>\n
Jadikan script dapat dieksekusi dengan chmod<\/code><\/a>:<\/p>\n
sudo chmod +x ~\/backup_odoo.sh<\/pre>\n
Jangan lupa mengubah variabel BACKUP_DIR<\/code>, ODOO_DATABASE<\/code>, dan G4NT1_PA$$W0RD<\/code>\u00a0sesuai kebutuhan Anda.
Langkah terakhir adalah membuat cron job baru yang akan berjalan setiap hari pukul 01:30 pagi:<\/p>\n
crontab -e<\/pre>\n
30 1 * * * \/home\/<yourusername>\/backup_odoo.sh
\n<\/pre>\n
Jangan lupa untuk mengatur nama dan jalur yang benar ke skrip script.<\/p>\n
Anda dapat memodifikasi skrip dan menerapkan solusi backup yang lebih kuat seperti menggunakan penyimpanan backup secara remote, atau menyimpan backup secara mingguan, bulanan, dsb.<\/p>\n
Restore Database Odoo<\/h2>\n
Untuk memulihkan cadangan basis data menggunakan antarmuka manajemen basis data, buka browser Anda dan arahkan ke http:\/\/server_ip:8069\/web\/database\/manager<\/code>.<\/p>\n
Klik pada tombol\u00a0Restore Database<\/code>\u00a0dan pop up baru berikut akan muncul<\/p>\n
\"database<\/a><\/p>\n
Masukkan database Odoo Master Password Anda, pilih File backup, masukkan Nama Database baru dan pulihkan database dengan mengklik tombol Continue<\/code>\u00a0biru.<\/p>\n
Sebelum restore database, Anda harus menghapus database atau menggunakan nama database lain. Untuk ambil aman, silahkan membuat database<\/a> baru dengan nama yang berbeda.<\/p>\n
Bergantung pada ukuran database dan kecepatan Internet Anda, proses pemulihan mungkin memakan waktu.<\/p>\n
Kami juga dapat mengembalikan database dari baris perintah:<\/p>\n
curl -F 'master_pwd=G4NT1_PA$$W0RD' -F backup_file=@\/opt\/odoo\/odoo_backups\/db1.2018-04-14.zip -F 'copy=true' -F 'name=db3' http:\/\/localhost:8069\/web\/database\/restore<\/pre>\n
Tentu saja Anda perlu menyesuaikan perintah dengan Master password Odoo Anda, jalur ke backup database dan nama backup.<\/p>\n
Jika proses restore berhasil, hasilnya akan terlihat seperti ini:<\/p>\n
!DOCTYPE HTML PUBLIC \"-\/\/W3C\/\/DTD HTML 3.2 Final\/\/EN\">
\n<title>Redirecting...<\/title>
\n<h1>Redirecting...<\/h1>
\n<p>You should be redirected automatically to target URL: <a href=\"https:\/\/www.linuxid.net\/web\/database\/manager\">\/web\/database\/manager<\/a>.  If not click the link.
\n<\/pre>\n
Kesimpulan<\/h2>\n
Tutorial ini memandu Anda membuat backups harian secara otomatis dari database Odoo Anda menggunakan cronjob.<\/p>\n","protected":false},"excerpt":{"rendered":"
Dalam tutorial ini kami akan memandu Anda melalui proses membuat backup secara harian otomatis dari…<\/p>\n","protected":false},"author":2,"featured_media":1471,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[107],"tags":[41,184,185,166],"class_list":["post-2003","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-other","tag-mysql","tag-odoo","tag-postgresql","tag-sql"],"yoast_head":"\nTutorial Setup Backup Otomatis Database Odoo - Linuxid<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/linuxid.net\/post\/tutorial-setup-backup-otomatis-database-odoo\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Tutorial Setup Backup Otomatis Database Odoo - Linuxid\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini kami akan memandu Anda melalui proses membuat backup secara harian otomatis dari…\" \/>\n<meta property=\"og:url\" content=\"https:\/\/linuxid.net\/post\/tutorial-setup-backup-otomatis-database-odoo\/\" \/>\n<meta property=\"og:site_name\" content=\"Linuxid\" \/>\n<meta property=\"article:published_time\" content=\"2019-02-12T10:20:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-27T21:36:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Konfigurasi-Odoo-dengan-Nginx-sebagai-Reverse-Proxy.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"530\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"xsand\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"xsand\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/linuxid.net\/post\/tutorial-setup-backup-otomatis-database-odoo\/\",\"url\":\"https:\/\/linuxid.net\/post\/tutorial-setup-backup-otomatis-database-odoo\/\",\"name\":\"Tutorial Setup Backup Otomatis Database Odoo - Linuxid\",\"isPartOf\":{\"@id\":\"https:\/\/linuxid.net\/post\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/linuxid.net\/post\/tutorial-setup-backup-otomatis-database-odoo\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/linuxid.net\/post\/tutorial-setup-backup-otomatis-database-odoo\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Konfigurasi-Odoo-dengan-Nginx-sebagai-Reverse-Proxy.jpg\",\"datePublished\":\"2019-02-12T10:20:42+00:00\",\"dateModified\":\"2025-03-27T21:36:12+00:00\",\"author\":{\"@id\":\"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79\"},\"breadcrumb\":{\"@id\":\"https:\/\/linuxid.net\/post\/tutorial-setup-backup-otomatis-database-odoo\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/linuxid.net\/post\/tutorial-setup-backup-otomatis-database-odoo\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/linuxid.net\/post\/tutorial-setup-backup-otomatis-database-odoo\/#primaryimage\",\"url\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Konfigurasi-Odoo-dengan-Nginx-sebagai-Reverse-Proxy.jpg\",\"contentUrl\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Konfigurasi-Odoo-dengan-Nginx-sebagai-Reverse-Proxy.jpg\",\"width\":1000,\"height\":530},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/linuxid.net\/post\/tutorial-setup-backup-otomatis-database-odoo\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Beranda\",\"item\":\"https:\/\/linuxid.net\/post\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tutorial Setup Backup Otomatis Database Odoo\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/linuxid.net\/post\/#website\",\"url\":\"https:\/\/linuxid.net\/post\/\",\"name\":\"Linuxid\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/linuxid.net\/post\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79\",\"name\":\"xsand\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/linuxid.net\/post\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/cc8513768e15fa0758099a0ba5b898f3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/cc8513768e15fa0758099a0ba5b898f3?s=96&d=mm&r=g\",\"caption\":\"xsand\"},\"url\":\"https:\/\/www.linuxid.net\/post\/author\/xsand\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Tutorial Setup Backup Otomatis Database Odoo - Linuxid","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/linuxid.net\/post\/tutorial-setup-backup-otomatis-database-odoo\/","og_locale":"id_ID","og_type":"article","og_title":"Tutorial Setup Backup Otomatis Database Odoo - Linuxid","og_description":"Dalam tutorial ini kami akan memandu Anda melalui proses membuat backup secara harian otomatis dari…","og_url":"https:\/\/linuxid.net\/post\/tutorial-setup-backup-otomatis-database-odoo\/","og_site_name":"Linuxid","article_published_time":"2019-02-12T10:20:42+00:00","article_modified_time":"2025-03-27T21:36:12+00:00","og_image":[{"width":1000,"height":530,"url":"https:\/\/linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Konfigurasi-Odoo-dengan-Nginx-sebagai-Reverse-Proxy.jpg","type":"image\/jpeg"}],"author":"xsand","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"xsand","Estimasi waktu membaca":"4 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/linuxid.net\/post\/tutorial-setup-backup-otomatis-database-odoo\/","url":"https:\/\/linuxid.net\/post\/tutorial-setup-backup-otomatis-database-odoo\/","name":"Tutorial Setup Backup Otomatis Database Odoo - Linuxid","isPartOf":{"@id":"https:\/\/linuxid.net\/post\/#website"},"primaryImageOfPage":{"@id":"https:\/\/linuxid.net\/post\/tutorial-setup-backup-otomatis-database-odoo\/#primaryimage"},"image":{"@id":"https:\/\/linuxid.net\/post\/tutorial-setup-backup-otomatis-database-odoo\/#primaryimage"},"thumbnailUrl":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Konfigurasi-Odoo-dengan-Nginx-sebagai-Reverse-Proxy.jpg","datePublished":"2019-02-12T10:20:42+00:00","dateModified":"2025-03-27T21:36:12+00:00","author":{"@id":"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79"},"breadcrumb":{"@id":"https:\/\/linuxid.net\/post\/tutorial-setup-backup-otomatis-database-odoo\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/linuxid.net\/post\/tutorial-setup-backup-otomatis-database-odoo\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/linuxid.net\/post\/tutorial-setup-backup-otomatis-database-odoo\/#primaryimage","url":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Konfigurasi-Odoo-dengan-Nginx-sebagai-Reverse-Proxy.jpg","contentUrl":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Konfigurasi-Odoo-dengan-Nginx-sebagai-Reverse-Proxy.jpg","width":1000,"height":530},{"@type":"BreadcrumbList","@id":"https:\/\/linuxid.net\/post\/tutorial-setup-backup-otomatis-database-odoo\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Beranda","item":"https:\/\/linuxid.net\/post\/"},{"@type":"ListItem","position":2,"name":"Tutorial Setup Backup Otomatis Database Odoo"}]},{"@type":"WebSite","@id":"https:\/\/linuxid.net\/post\/#website","url":"https:\/\/linuxid.net\/post\/","name":"Linuxid","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/linuxid.net\/post\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79","name":"xsand","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/linuxid.net\/post\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/cc8513768e15fa0758099a0ba5b898f3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/cc8513768e15fa0758099a0ba5b898f3?s=96&d=mm&r=g","caption":"xsand"},"url":"https:\/\/www.linuxid.net\/post\/author\/xsand\/"}]}},"_links":{"self":[{"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts\/2003","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/comments?post=2003"}],"version-history":[{"count":1,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts\/2003\/revisions"}],"predecessor-version":[{"id":2456,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts\/2003\/revisions\/2456"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/media\/1471"}],"wp:attachment":[{"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/media?parent=2003"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/categories?post=2003"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/tags?post=2003"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
Anda dapat menemukan informasi lebih lanjut tentang cara mengkonfigurasi Odoo dengan Nginx sebagai reverse-proxy di sini<\/a>.<\/p>\n