Jul 4, 2018

moving odoo 10 from site to other site


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 | 

.

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