Restore Database .dump by Terminal
Ini digunakan untuk merestore database di Odoo
1. eka@eka-ThinkPad-T430:~$ sudo su postgres
2. postgres@eka-ThinkPad-T430:/home/eka$ psql
psql (9.3.16)
Type "help" for help.
3. postgres=# create database database_baru owner odoo9c_new;
CREATE DATABASE
4. postgres=# \q
5. postgres@eka-ThinkPad-T430:/home/eka$ exit
exit
6. eka@eka-ThinkPad-T430:~$ sudo su odoo9c_new -s /bin/bash
7. odoo9c_new@eka-ThinkPad-T430:/home/eka$ pg_restore -Fc -d database_baru database_yang_mau_direstore.dump
tunggu sampai selesai restore, tandanya adalah udah bisa ngetik command lagi :D
1. eka@eka-ThinkPad-T430:~$ sudo su postgres
2. postgres@eka-ThinkPad-T430:/home/eka$ psql
psql (9.3.16)
Type "help" for help.
3. postgres=# create database database_baru owner odoo9c_new;
CREATE DATABASE
4. postgres=# \q
5. postgres@eka-ThinkPad-T430:/home/eka$ exit
exit
6. eka@eka-ThinkPad-T430:~$ sudo su odoo9c_new -s /bin/bash
7. odoo9c_new@eka-ThinkPad-T430:/home/eka$ pg_restore -Fc -d database_baru database_yang_mau_direstore.dump
tunggu sampai selesai restore, tandanya adalah udah bisa ngetik command lagi :D
Komentar
Posting Komentar