Hello, how can I back up odoo database from server and restore it to my personal computer using pgadmin?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project
- MRP
This question has been flagged
1
Reply
3636
Views
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
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?
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
2
May 21
|
2989 | ||
|
3
Mar 15
|
9240 | ||
|
0
Mar 24
|
1899 | ||
|
1
Mar 24
|
9375 | ||
|
4
Dec 17
|
5922 |
