simple summary steps
0. turn off all websites traffic, and restart the postgres
1. backup source file
2. backup filestore
3. backup database via psql
let's rock the job!!!
1.
BACKUP SOURCE FILE
make zip file under Odoo folder
2. BACKUP filestore
the location usually here ".local/share/Odoo/filestore"
3. BACKUP Database
DATABASE BACKUP
pg_dump esti > esti_o10_jul_4_18.out
DATABASE RESTORE
psql
create database esti owner odoo;
postgres@weskadung:/home/febru/backup_esti$ psql -f esti_o10_jul_4_18.out esti
postgres=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-------------+----------+----------+-------------+-------------+-----------------------
esti | odoo | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
..show all:.
.
simple summary steps
0. turn off all websites traffic, and restart the postgres
1. backup source file
2. backup filestore
3. backup database via psql
let's rock the job!!!
1.
BACKUP SOURCE FILE
make zip file under Odoo folder
2. BACKUP filestore
the location usually here ".local/share/Odoo/filestore"
3. BACKUP Database
DATABASE BACKUP
pg_dump esti > esti_o10_jul_4_18.out
DATABASE RESTORE
psql
create database esti owner odoo;
postgres@weskadung:/home/febru/backup_esti$ psql -f esti_o10_jul_4_18.out esti
postgres=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-------------+----------+----------+-------------+-------------+-----------------------
esti | odoo | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
No comments:
Post a Comment