Ir al contenido
Menú
Se marcó esta pregunta

Hello, how can I back up odoo database from server and restore it to my personal computer using pgadmin? 

Avatar
Descartar
Mejor respuesta

Hi,

In the current case, you can directly restore the database from the UI or use terminals


If you restore the dump dile try this code in your terminal


$sudo su postgres

$createdb -O [Owner] [database_name]

$psql [database_name]



dump:

$sudo su postgres

$createdb -O [Owner] [database_name]

$pgrestore -d [database_name] [dumpfile_name].dump


for more reference you can refer to the Blog : 

https://www.cybrosys.com/blog/how-to-restore-a-database-in-odoo-15-erp



automatic datarestore-

https://www.cybrosys.com/blog/how-to-setup-automatic-database-backup-in-odoo-15


Hope it helps

Avatar
Descartar
Autor

The reason of using pgadmin is because:
1. Im bad at code
2. my odoo server is error and no one know how to resolve it.
So, if i use pgadmin, i just need to right-click the database, create backup using .tar file, right?

Publicaciones relacionadas Respuestas Vistas Actividad
2
may 21
2224
3
mar 15
8124
0
mar 24
1133
1
mar 24
7591
4
dic 17
4996