blocks|key|1424713|text|通过使用此模块，您可以定期备份数据库。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1424714|配置/+(v7)|offset|length|1424715|您也可以测试这个模块。|1424716|ept/+(v6，它可以合并到v7)|1424717|在您的示例中，您可以添加按钮来执行将由调度器执行的函数。|1424718|entityMap|0|LINK|mutability|MUTABLE|url|https://www.odoo.com/apps/modules/7.0/crontab_config/|1|https://www.odoo.com/apps/modules/6.1/db_backup_ept/^0|0|0|3|0|0|0|0|4|1|0|0^^$0|@$1|2|3|4|5|6|7|V|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|W|8|@]|9|@$D|X|E|Y|1|Z]]|A|$]]|$1|F|3|G|5|6|7|10|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|11|8|@]|9|@$D|12|E|13|1|14]]|A|$]]|$1|J|3|K|5|6|7|15|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|16|8|@]|9|@]|A|$]]]|M|$N|$5|O|P|Q|A|$R|S]]|T|$5|O|P|Q|A|$R|U]]]]

By using this module you can backup your database periodically 

<a href="https://www.odoo.com/apps/modules/7.0/crontab_config/" rel="noreferrer">https://www.odoo.com/apps/modules/7.0/crontab_config/</a> (v7)

you can also test this module 

<a href="https://www.odoo.com/apps/modules/6.1/db_backup_ept/" rel="noreferrer">https://www.odoo.com/apps/modules/6.1/db_backup_ept/</a> (v6 it can be miggrated to v7) 

in your case you can add button to execute the function that will be executed by the schedular.

blocks|key|117330|text|您可以使用CURL下载完整的备份(资产%2B+DB)，这种方法比pg_dump更快。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|117331|curl+-X+POST+\
-F+"master_pwd=${ADMIN_PASSWORD}"+\
-F+"name=${ODOO_DATABASE}"+\
-F+"backup_format=zip"+\
-o+${BACKUP_DIR}/${ODOO_DATABASE}.$(date+%2B%25F-%25T).zip+\
${HOST}/web/database/backup|code-block|syntax|javascript|117332|如果你愿意的话，你可以在一个定制的(你自己的)+Odoo插件里面包装。希望这能有所帮助。|117333|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

You can use the CURL to download the full backup (assets + DB), this method is comparatively faster than pg_dump. 

<pre><code>curl -X POST \
-F "master_pwd=${ADMIN_PASSWORD}" \
-F "name=${ODOO_DATABASE}" \
-F "backup_format=zip" \
-o ${BACKUP_DIR}/${ODOO_DATABASE}.$(date +%F-%T).zip \
${HOST}/web/database/backup
</code></pre>

You can wrap inside a custom (your own) Odoo add-on if you wish to. Hope this helps.

blocks|key|1418248|text|您可以从odoo中的“数据库管理”中获取数据库备份。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1418249|在浏览器中键入以下链接，|1418250|http://localhost:8069/web/database/manager|offset|length|1418251|只需在上面的链接中替换您的ip和端口，您将获得用于数据库管理的屏幕，您可以执行以下与数据库相关的操作|1418252|创建|unordered-list-item|1418253|复制|1418254|丢弃|1418255|备份|1418256|密码|1418257|恢复|1418258|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|0|16|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|13|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|14|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|15|8|@]|9|@$F|16|G|17|1|18]]|A|$]]|$1|H|3|I|5|6|7|19|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|1A|8|@]|9|@]|A|$]]|$1|M|3|N|5|L|7|1B|8|@]|9|@]|A|$]]|$1|O|3|P|5|L|7|1C|8|@]|9|@]|A|$]]|$1|Q|3|R|5|L|7|1D|8|@]|9|@]|A|$]]|$1|S|3|T|5|L|7|1E|8|@]|9|@]|A|$]]|$1|U|3|V|5|L|7|1F|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|1G|8|@]|9|@]|A|$]]]|X|$Y|$5|Z|10|11|A|$12|E]]]]

You can take database backup from "Database Management" in odoo..

type following link in browser,

<a href="http://localhost:8069/web/database/manager" rel="nofollow noreferrer">http://localhost:8069/web/database/manager</a>

just replace your ip and port in aboves link, you will get screen for database management, you can perform following operations related to database 

<ul>
<li>Create</li>
<li>Duplicate</li>
<li>Drop</li>
<li>Backup </li>
<li>Password</li>
<li>Restore</li>
</ul>

blocks|key|1418312|text|在某个地方添加一个按钮，然后调用一个像这样的控制器。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1418313|@http.route('/backup/download',+auth="user",+type='http')
++++++++def+backup(self,+**kw):
++++++++++++ts+=+datetime.datetime.utcnow().strftime("%25Y-%25m-%25d_%25H-%25M-%25S")
++++++++++++filename+=+"%25s_%25s.zip"+%25+(request.env.cr.dbname,+ts)
++++++++++++headers+=+[
++++++++++++++++('Content-Type',+'application/octet-stream;+charset=binary'),
++++++++++++++++('Content-Disposition',+content_disposition(filename)),
++++++++++++]
++++++++++++dump_stream+=+db.dump_db(request.env.cr.dbname,+None)
++++++++++++response+=+werkzeug.wrappers.Response(dump_stream,+headers=headers,+direct_passthrough=True)
++++++++++++return+response|code-block|syntax|javascript|1418314|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Add a button somewhere and call a controller like this one.

<pre><code>@http.route('/backup/download', auth="user", type='http')
 def backup(self, **kw):
 ts = datetime.datetime.utcnow().strftime("%Y-%m-%d_%H-%M-%S")
 filename = "%s_%s.zip" % (request.env.cr.dbname, ts)
 headers = [
 ('Content-Type', 'application/octet-stream; charset=binary'),
 ('Content-Disposition', content_disposition(filename)),
 ]
 dump_stream = db.dump_db(request.env.cr.dbname, None)
 response = werkzeug.wrappers.Response(dump_stream, headers=headers, direct_passthrough=True)
 return response
</code></pre>

blocks|key|117151|text|您可以使用专用浏览器会话从登录屏幕访问数据库菜单，并在那里执行备份表单(您需要知道主密码才能访问服务器配置文件中定义的主密码)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|117152|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

You can use a private browser session to access the Database menu, from the login screen, and perform the the backup form there (you need to know the master password to access that, defined in the server configuration file).

blocks|key|1418243|text|转到your_odoo_instance/web/database/manager，在那里您可以看到所有已安装的数据库：|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|1418244|Odoo的数据库管理器-备份|1418245|您将需要为此任务定义主密码。如果您不记得它，请查看服务器中的odoo.conf文件并检查“admin_passwd”条目。|1418246|entityMap|0|LINK|mutability|MUTABLE|url|http://i.stack.imgur.com/Bz5bn.png^0|2|13|0|0|E|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@$9|S|A|T|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|U|8|@]|D|@$9|V|A|W|1|X]]|E|$]]|$1|H|3|I|5|6|7|Y|8|@]|D|@]|E|$]]|$1|J|3|-4|5|6|7|Z|8|@]|D|@]|E|$]]]|K|$L|$5|M|N|O|E|$P|Q]]]]

Go to your_odoo_instance/web/database/manager where you can see all your installed databases:

<a href="http://i.stack.imgur.com/Bz5bn.png" rel="nofollow">Odoo's Database Manager - Backup</a>

You will need your defined master password for this task. If you can't remember it, have a look at your odoo.conf file in your server and check the 'admin_passwd' entry.

blocks|key|1418322|text|有很多方法可以转储ODOO的数据库。您也可以从ODOO商店下载应用程序来自动完成此操作。在这里，我可以建议一个插件，它将根据您的设置、月份、日、小时进行此数据库自动备份。这是一种非常可靠和高效的方法，该模块可以在不影响odoo进程的情况下处理大型数据库。ODOO数据库自动备份|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1418323|entityMap|0|LINK|mutability|MUTABLE|url|https://apps.odoo.com/apps/modules/13.0/auto_backup_odoo/^0|3J|B|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

There are a lot of ways to dump the database of ODOO. You can download apps from the ODOO store for doing this automatically also. Here I can suggest an addon that will do this DATABASE AUTO Backup according to your settings Month, Day, Hour basis. This is a highly reliable and efficient way where this module can handle large databases without effecting odoo processes.
<a href="https://apps.odoo.com/apps/modules/13.0/auto_backup_odoo/" rel="nofollow noreferrer">ODOO DATABASE AUTOMATIC BACKUP</a>

blocks|key|117419|text|使用此模块进行自动备份|type|unstyled|depth|inlineStyleRanges|entityRanges|data|117420|主动开发模式。Go+Settings+>常规设置>数据库备份，设置要保存数据库的数据库名称和路径。|117421|后备/|offset|length|117422|117423|entityMap|0|LINK|mutability|MUTABLE|url|https://apps.odoo.com/apps/modules/11.0/db_backup/|1|https://apps.odoo.com/apps/modules/14.0/yodoo_easy_backup/^0|0|0|0|3|0|0|0|3|1|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|U|8|@]|9|@$F|V|G|W|1|X]]|A|$]]|$1|H|3|E|5|6|7|Y|8|@]|9|@$F|Z|G|10|1|11]]|A|$]]|$1|I|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|J|$K|$5|L|M|N|A|$O|P]]|Q|$5|L|M|N|A|$O|R]]]]

Use This Module For Automatic Backup
Active developer mode.
Go Settings &gt; General Settings &gt; Database Backup
Set your database name and path where you want to save your database.
<a href="https://apps.odoo.com/apps/modules/11.0/db_backup/" rel="nofollow noreferrer">https://apps.odoo.com/apps/modules/11.0/db_backup/</a>
<a href="https://apps.odoo.com/apps/modules/14.0/yodoo_easy_backup/" rel="nofollow noreferrer">https://apps.odoo.com/apps/modules/14.0/yodoo_easy_backup/</a>

blocks|key|1932798|text|开始前的考虑|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1932799|http://your_odoo_example.com/web/database/manager+URL上可见的备份按钮将Filestore和数据库都打包在一个压缩的*.zip文件上，可以通过相同的URL解压缩和恢复。|offset|length|style|CODE|1932800|同样重要的是，要生成Odoo的完整备份，需要三个基本部分：|1932801|文件系统(通常是GIT+)|ordered-list-item|1932802|数据库(如前面所述，可以通过Odoo数据库管理器完成)|1932803|FileStore+(如前面所述，可以通过Odoo数据库管理器完成)|1932804|如果没有对Filestore的备份和恢复，就有可能得到错误，使Odoo不能正常工作，或者，如果日志中充斥着附件错误，至少会使日志无法读取。|1932805|建议您停止当前和目标数据库位置上的Odoo，PostgreSQL将抱怨数据库仍在被访问。|1932806|要求：|1932807|访问psql命令|unordered-list-item|1932808|Odoo数据库的用户和密码|1932809|用户和密码方面的信息最有可能出现在odoo.conf文件中，假设它位于最常用的路径/etc/odoo/odoo.conf上，很容易用以下方法检索：|1932810|grep+'db_password\%7Cdb_user\%7Cdb_name'+/etc/odoo/odoo.conf|code-block|syntax|javascript|1932811|测试对psql控制台的访问，并执行db_user、db_name和db_password的结果值：|1932812|psql+-U+db_user+-d+db_name|1932813|它要么直接登录，要么询问密码，结果应该如下所示：|1932814|❯+psql+db_user+-d+db_name
Password+for+user+db_user:
psql+(11.13)
Type+"help"+for+help.

db_name=#|1932815|获取错误消息很可能意味着PostgreSQL将需要在pg_hba.conf和/或postgres.conf文件上进行额外的配置，它本身也将是一个主题。|1932816|bash命令|1932817|有了所有这些信息，如果访问psql一切顺利，我们已经准备好通过bash找到解决方案，|1932818|通过psql命令执行，其中一个命令生成数据库转储，最好是压缩文件，以便在需要下载时更容易传输，这是其中一个选项的简单版本：
pg_dump+-U+db_user+-d+db_name+bzip2+>backup_name-DDMMYY.sql.bz2|1932819|但是，要恢复数据库转储，请执行一个类似的命令，该命令将从*.sql.bz2文件中还原它，但是，首先需要将其创建为一个空目标数据库，其中包括：
createdb+-U+db_user+db_name
请记住，如果您以前已还原了数据库，并且希望使用相同的名称，则需要删除不再使用的数据库，因为您可以使用：
-U+db_user+target_db_name
确保！，您没有删除要备份的原始数据库。|BOLD|1932820|一旦您拥有了恢复备份的空目标数据库，您将需要运行一个命令，该命令将解压缩转储，然后将其写入空目标数据库：
bzcat备份_name-DDMMYY.sql.bz2\+psql+-U+db_user+-d+target_db_name
这应该足够让数据库重新启动并运行|1932821|最后，将数据库所有者设置为目标数据库位置的用户：
psql+-U+db_user+-d+target_db_name+-c+"ALTER+DATABASE+\"target_db_name\“OWNER+TO+target_db_user”|1932822|bash脚本|1932823|要真正简化在.bashrc+PATH上通过vim或nano创建可执行命令的过程，无论当前正在处理的目录是什么，一个适用于标准Debian/Ubuntu发行版的示例如下：|1932824|sudo+nano+/usr/local/bin/your_command_name|1932825|假设Odoo和PostgreSQL的服务名称分别是，odoo和PostgreSQL+--这是bash脚本实现任务的一个选项：|1932826|#!/bin/bash


##+Variables
#+Name+of+Local+Database+to+Drop+and+Recreate
target_db_name="replace_with_your_db_name"

#+Local+Credentials
db_user="replace_with_your_db_user"
db_password="replace_with_your_db_password"
target_db_user="replace_with_your_targer_db_user"


##+Database+Backup+Files+selection
#+Set+all+the+files+in+an+array+named+$files
files=(+/replace_with_your/path_to/database_backups/*.sql.bz2+)
shopt+-s+extglob

#+Build+the+string+to+use+for+the+case+options
string="@(${files[0]}"
#+Add+file+names+to+the+string
for((i=1;i<${#files[@]};i%2B%2B))
do
++++string%2B="%7C${files[$i]}"
done
#+Add+the+rest+of+the+syntax+to+$string+resulting+in+something+like+@(file1%7Cfile2%7Cfile3%7C...%7CfileN)
string%2B=")"

#+Case+for+Database+Backup+*.sql.bz2+File
select+file+in+"${files[@]}"+"quit"
do
++++case+$file+in
++++##+If+the+choice+is+one+of+the+files+(if+it+matches+$string)
++++$string)
++++##+PostgreSQL+commands
++++#+Stops+Odoo+Server+Service
++++systemctl+stop+odoo

++++#+Starts+PostgreSQL+Service
++++systemctl+restart+PostgreSQL

++++#+Drop+target_db_name
++++PGPASSWORD=$db_password+psql+-U+$db_user+-c+"DROP+DATABASE+\"$target_db_name\""

++++#+Creates+Empty+target_db_name
++++PGPASSWORD=$db_password+psql+-U+$db_user+-c+"CREATE+DATABASE+\"$target_db_name\""

++++#+Generates+Target+Database+from+dump+file
++++bzcat+$file+%7C+PGPASSWORD=$db_password+psql+-U+$db_user+$target_db_name

++++#+New+Database+gets+psql+User+by+Default+as+Owner,+must+change+to+Local+Database+instance+owner
++++PGPASSWORD=$db_password+psql+-U+$db_user+-d+$target_db_name+-c+"ALTER+DATABASE+\"$target_db_name\"+OWNER+TO+$taregt_db_owner"

++++#+Starts+PostgreSQL+Service
++++systemctl+restart+PostgreSQL

++++#+Starts+Odoo+Server+Service
++++systemctl+start+odoo
++++;;
++++"quit")
++++++++##+Exit
++++++++echo
++++++++echo
++++++++exit
++++++++;;
++++*)
++++++++file=""
++++++++echo+"Please+choose+a+number+from+1+to+$((${#files[@]}%2B1))"
++++++++;;
++++esac
done|1932827|bash脚本需要sudo执行，因为它涉及停止和启动守护进程服务：|1932828|sudo+your_command_name|1932829|关于db_name和db_password的bash脚本|1932830|有更好的方法可以做到这一点，例如，没有必要在bash脚本上设置bash，可以通过将其设置为环境变量或通过加密的机密文件以及db_user传递，我确信还有其他主题将涵盖这些主题，但这应该可以开始。|1932831|我希望这能帮上忙。|1932832|entityMap^0|0|0|1D|2C|5|0|0|0|0|0|0|0|0|2|4|0|0|15|J|0|0|3|4|0|0|0|0|Q|B|14|D|0|0|4|0|D|4|0|2|4|0|S|9|4X|3|0|0|0|0|4|0|6|7|E|4|0|0|1A|4|0|0|0|4|0|0|M|4|0|M|4|V|4|0|0^^$0|@$1|2|3|4|5|6|7|2H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|2I|8|@$D|2J|E|2K|F|G]|$D|2L|E|2M|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|2N|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|2O|8|@]|9|@]|A|$]]|$1|M|3|N|5|L|7|2P|8|@]|9|@]|A|$]]|$1|O|3|P|5|L|7|2Q|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|2R|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|2S|8|@]|9|@]|A|$]]|$1|U|3|V|5|6|7|2T|8|@]|9|@]|A|$]]|$1|W|3|X|5|Y|7|2U|8|@$D|2V|E|2W|F|G]]|9|@]|A|$]]|$1|Z|3|10|5|Y|7|2X|8|@]|9|@]|A|$]]|$1|11|3|12|5|6|7|2Y|8|@$D|2Z|E|30|F|G]]|9|@]|A|$]]|$1|13|3|14|5|15|7|31|8|@]|9|@]|A|$16|17]]|$1|18|3|19|5|6|7|32|8|@$D|33|E|34|F|G]]|9|@]|A|$]]|$1|1A|3|1B|5|15|7|35|8|@]|9|@]|A|$16|17]]|$1|1C|3|1D|5|6|7|36|8|@]|9|@]|A|$]]|$1|1E|3|1F|5|15|7|37|8|@]|9|@]|A|$16|17]]|$1|1G|3|1H|5|6|7|38|8|@$D|39|E|3A|F|G]|$D|3B|E|3C|F|G]]|9|@]|A|$]]|$1|1I|3|1J|5|6|7|3D|8|@$D|3E|E|3F|F|G]]|9|@]|A|$]]|$1|1K|3|1L|5|6|7|3G|8|@$D|3H|E|3I|F|G]]|9|@]|A|$]]|$1|1M|3|1N|5|L|7|3J|8|@$D|3K|E|3L|F|G]]|9|@]|A|$]]|$1|1O|3|1P|5|L|7|3M|8|@$D|3N|E|3O|F|G]|$D|3P|E|3Q|F|1Q]]|9|@]|A|$]]|$1|1R|3|1S|5|L|7|3R|8|@]|9|@]|A|$]]|$1|1T|3|1U|5|L|7|3S|8|@]|9|@]|A|$]]|$1|1V|3|1W|5|6|7|3T|8|@$D|3U|E|3V|F|G]]|9|@]|A|$]]|$1|1X|3|1Y|5|6|7|3W|8|@$D|3X|E|3Y|F|G]|$D|3Z|E|40|F|G]]|9|@]|A|$]]|$1|1Z|3|20|5|15|7|41|8|@]|9|@]|A|$16|17]]|$1|21|3|22|5|6|7|42|8|@$D|43|E|44|F|G]]|9|@]|A|$]]|$1|23|3|24|5|15|7|45|8|@]|9|@]|A|$16|17]]|$1|25|3|26|5|6|7|46|8|@$D|47|E|48|F|G]]|9|@]|A|$]]|$1|27|3|28|5|15|7|49|8|@]|9|@]|A|$16|17]]|$1|29|3|2A|5|6|7|4A|8|@$D|4B|E|4C|F|G]]|9|@]|A|$]]|$1|2B|3|2C|5|6|7|4D|8|@$D|4E|E|4F|F|G]|$D|4G|E|4H|F|G]]|9|@]|A|$]]|$1|2D|3|2E|5|6|7|4I|8|@]|9|@]|A|$]]|$1|2F|3|-4|5|6|7|4J|8|@]|9|@]|A|$]]]|2G|$]]

<h1>Considerations before starting</h1>
The Backup button visible on the <code>http://your_odoo_example.com/web/database/manager</code> URL, packages both the Filestore and the Database on a compressed <code>*.zip</code> file, that the Odoo Database Manager through the same URL can decompress and restore.
It's also important to know that to generate a full backup of Odoo three essential parts are needed:
<ol>
<li>Filesystem (Usually a GIT Repo)</li>
<li>Database (Can be done through the Odoo Database Manager as stated before)</li>
<li>FileStore (Can be done through the Odoo Database Manager as stated before)</li>
</ol>
Without a backup and restore of the Filestore, there's a chance of getting errors and having Odoo not work well, or at least make the log unreadable if it's flooded with attachment errors.
It's recommended that you stop the Odoo Services on both current and target Database locations, PostgreSQL will complain about the Database still being accessed.
<h2>Requirements:</h2>
<ul>
<li>Access to the <code>psql</code> command</li>
<li>The user and password to your Odoo database</li>
</ul>
The information on both user and password is most likely on the odoo.conf file, assuming it is on the most used path <code>/etc/odoo/odoo.conf</code> it's easy to retrieve with:
<pre><code>grep 'db_password\|db_user\|db_name' /etc/odoo/odoo.conf
</code></pre>
Test access to the <code>psql</code> console with the resulting values of db_user, db_name and db_password executing:
<pre><code>psql -U db_user -d db_name
</code></pre>
it should either log in directly or ask for a password, the result should be something like this:
<pre><code>❯ psql db_user -d db_name
Password for user db_user:
psql (11.13)
Type &quot;help&quot; for help.

db_name=#
</code></pre>
Getting an error message most likely means PostgreSQL will need additional configuration on the <code>pg_hba.conf</code> and/or <code>postgres.conf</code> files, it'll be a topic on its own to also cover it here.
<h1>The <code>bash</code> commands</h1>
With all that information and if everything went good accessing <code>psql</code>, we are ready for a solution to do it through bash,
<ol>
<li>Execute via <code>psql</code> commands, one to generate a Database dump,
preferably one that will also compress the file for easier transport
if you need to download, this is a simple version of one of the
options:
<pre><code>pg_dump -U db_user -d db_name | bzip2 &gt;
backup_name-DDMMYYY.sql.bz2
</code></pre>
</li>
<li>To restore the Database dump execute a similar command that will
restore it from the <code>*.sql.bz2</code> file, however, it needs to first
be created as an empty target Database, with:
<pre><code>createdb -U db_user db_name
</code></pre>
Have in mind that if you have restored the Database before, and you
want to use the same name, you'll need to drop the Database you are
not going to use anymore, for that you can use:
<pre><code>dropdb -U db_user target_db_name
</code></pre>
MAKE SURE! you're not dropping the original Database you intend to backup.
</li>
<li>Once you have the empty target Database to restore the backup you'll
need to run a command that will decompress the dump and then write
it on the empty target Database:
<pre><code>bzcat backup_name-DDMMYYY.sql.bz2 | psql -U db_user -d target_db_name
</code></pre>
That should be good enough to get your Database back up and running
</li>
<li>Finally set the owner of the Database to the user of the target Database location:
<pre><code>psql -U db_user -d target_db_name -c &quot;ALTER DATABASE \&quot;target_db_name\&quot; OWNER TO target_db_user&quot;
</code></pre>
</li>
</ol>
<h1>The <code>bash</code> script</h1>
To really streamline the process create via vim or nano at the <code>.bashrc</code> <code>PATH</code> an executable command to use regardless of the current directory being worked on, an example that will work for a Standard Debian/Ubuntu Linux distribution is:
<pre><code>sudo nano /usr/local/bin/your_command_name
</code></pre>
Assuming the Service names for both Odoo and PostgreSQL are respectively, odoo and PostgreSQL this is an option for a <code>bash</code> script to achieve the task:
<pre><code>#!/bin/bash


## Variables
# Name of Local Database to Drop and Recreate
target_db_name=&quot;replace_with_your_db_name&quot;

# Local Credentials
db_user=&quot;replace_with_your_db_user&quot;
db_password=&quot;replace_with_your_db_password&quot;
target_db_user=&quot;replace_with_your_targer_db_user&quot;


## Database Backup Files selection
# Set all the files in an array named $files
files=( /replace_with_your/path_to/database_backups/*.sql.bz2 )
shopt -s extglob

# Build the string to use for the case options
string=&quot;@(${files[0]}&quot;
# Add file names to the string
for((i=1;i&lt;${#files[@]};i++))
do
 string+=&quot;|${files[$i]}&quot;
done
# Add the rest of the syntax to $string resulting in something like @(file1|file2|file3|...|fileN)
string+=&quot;)&quot;

# Case for Database Backup *.sql.bz2 File
select file in &quot;${files[@]}&quot; &quot;quit&quot;
do
 case $file in
 ## If the choice is one of the files (if it matches $string)
 $string)
 ## PostgreSQL commands
 # Stops Odoo Server Service
 systemctl stop odoo

 # Starts PostgreSQL Service
 systemctl restart PostgreSQL

 # Drop target_db_name
 PGPASSWORD=$db_password psql -U $db_user -c &quot;DROP DATABASE \&quot;$target_db_name\&quot;&quot;

 # Creates Empty target_db_name
 PGPASSWORD=$db_password psql -U $db_user -c &quot;CREATE DATABASE \&quot;$target_db_name\&quot;&quot;

 # Generates Target Database from dump file
 bzcat $file | PGPASSWORD=$db_password psql -U $db_user $target_db_name

 # New Database gets psql User by Default as Owner, must change to Local Database instance owner
 PGPASSWORD=$db_password psql -U $db_user -d $target_db_name -c &quot;ALTER DATABASE \&quot;$target_db_name\&quot; OWNER TO $taregt_db_owner&quot;

 # Starts PostgreSQL Service
 systemctl restart PostgreSQL

 # Starts Odoo Server Service
 systemctl start odoo
 ;;
 &quot;quit&quot;)
 ## Exit
 echo
 echo
 exit
 ;;
 *)
 file=&quot;&quot;
 echo &quot;Please choose a number from 1 to $((${#files[@]}+1))&quot;
 ;;
 esac
done
</code></pre>
The <code>bash</code> script will require sudo execution since it involves stopping and starting daemon services:
<pre><code>sudo your_command_name
</code></pre>
<h2>About the db_name and db_password on the <code>bash</code> script</h2>
There are better ways to do this, f example, it's not necessary to set the db_password on the <code>bash</code> script, it can be passed by setting it as an environment variable or through a encrypted secrets file along with the db_user, I'm sure there are other topics that will cover them but this should get things started.
I hope this helps someone.

blocks|key|117287|text|对于备份，您可以转到这个链接http://localhost:8069/web/database/manager。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|117288|您可以从那里创建一个备份。|unordered-list-item|117289|您也可以还原先前存在的备份。|117290|Important-+-在此之前，只需为数据库设置主密码，以避免将来的后果。|117291|​|117292|📷|atomic|117293|如果要在登录时更改特定模型或字段，请执行以下操作。您可以通过Odoo提供的export/import操作来完成它。从本地导出数据之后，可以在服务器上导入数据，因此必须对其进行验证。|117294|117295|117296|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://developer.qcloudimg.com/http-save/yehe-900000/20ec5d7a5f285fa0b854892c840001d3.png|imageAlt|1|https://developer.qcloudimg.com/http-save/yehe-900000/8634cc20c0db7921dadae4e58b4ee8ae.png^0|E|16|0|0|0|0|9|0|0|0|1|0|0|11|D|0|0|1|1|0|0^^$0|@$1|2|3|4|5|6|7|16|8|@$9|17|A|18|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|19|8|@]|D|@]|E|$]]|$1|I|3|J|5|H|7|1A|8|@]|D|@]|E|$]]|$1|K|3|L|5|6|7|1B|8|@$9|1C|A|1D|B|C]]|D|@]|E|$]]|$1|M|3|N|5|6|7|1E|8|@]|D|@]|E|$]]|$1|O|3|P|5|Q|7|1F|8|@]|D|@$9|1G|A|1H|1|1I]]|E|$]]|$1|R|3|S|5|6|7|1J|8|@$9|1K|A|1L|B|C]]|D|@]|E|$]]|$1|T|3|P|5|Q|7|1M|8|@]|D|@$9|1N|A|1O|1|1P]]|E|$]]|$1|U|3|N|5|6|7|1Q|8|@]|D|@]|E|$]]|$1|V|3|-4|5|6|7|1R|8|@]|D|@]|E|$]]]|W|$X|$5|Y|Z|10|E|$11|12|13|-4]]|14|$5|Y|Z|10|E|$11|15|13|-4]]]]

For backup, you can go to this link <code>http://localhost:8069/web/database/manager</code>. 

<ul>
<li>You can create a backup from there.</li>
<li>You can restore your pre existing backup also.</li>
</ul>

<code>Important</code>- Before that just set your master password for your Database to avoid consequences in future.

<a href="https://i.stack.imgur.com/aBDFT.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/aBDFT.png" alt="enter image description here"></a>
If you want to change particular models or fields while logged in. You can do it by <code>export/import</code> action provided by Odoo. After exporting data from local you can import it on your server for that you have to validate it.
<a href="https://i.stack.imgur.com/CPY7p.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/CPY7p.png" alt="enter image description here"></a>

I need to backup the current db while logged into odoo. I should be able to do it using a button, so that suppose I click on the button, it works the same way as odoo default backup in manage databases, but I should be able to do it from within while logged in.

Is there any way to achieve this? I do know that this is possible from outside odoo using bash but thats not what I want.

Backup Odoo db from within odoo

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云AI代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

功能1上新10个字符

功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符。

功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符。

功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符

功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符

功能4上新

文章&问答评论现已支持表情

全新交互，全新视觉，新增快捷键、悬浮工具栏、高亮块等功能并同时优化现有功能，全面提升创作效率和体验

社区富文本编辑器全新改版！诚邀体验～ 

精选全网热门MCP server，让你的AI更好用 🚀

💥开发者 MCP广场重磅上线！

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

登录到odoo时，我需要备份当前数据库。我应该能够使用一个按钮来完成这个任务，所以假设我点击了这个按钮，它的工作方式就像管理数据库中的odoo默认备份一样，但是我应该能够在登录时从内部进行备份。有办法做到这一点吗？我知道这在odoo之外使用bash是可能的，但这不是我想要的。

问从Odoo内部备份odoo db
EN

回答 10

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问从Odoo内部备份odoo dbEN

回答 10

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问从Odoo内部备份odoo db
EN