Skip ke Konten
Menu
Pertanyaan ini telah diberikan tanda
1 Balas
6485 Tampilan

hello guys i have problem to restore 4 gb db (in zip) to my odoo14 in docker, it always got timed out, how can i restore it? thanks

Avatar
Buang

I have no problems with a database of 3.9 GB on a Docker deployment.

Penulis

Can i know how to do it, dunno when i use this command cat your_dump.sql | docker exec -i your-db-container psql -U postgres, it didnt work on me, its stuck after i enter that command and no process

Jawaban Terbai

Try this method 

copy your_dump.sql to docker container ( sudo docker cp your_dump.sql db_docker_name:/your_dump.sql )

then use ( sudo docker exec -it --user postgres db_docker_name /bin/bash ) to get in the container

now you can restore the db by using ( psql your_database_name < your_dump.sql )


Avatar
Buang
Penulis

how about the filestore?

all the attachments generated and documents are located in the Odoo filestore per database. Normally it's located in the Odoo running user path

~/.local/share/Odoo/filestore

But you could have a different place for that setted in the config file as data_dir of your Odoo

data_dir = /var/lib/odoo

So if you copy the content of /var/lib/odoo maybe you are having some permissions issues, set the owner for the odoo user again for the copied files just to be sure that Odoo could read it
Just use the ( docker cp ) command to copy your filestore folder on the DB container

Post Terkait Replies Tampilan Aktivitas
0
Nov 23
5457
1
Nov 23
24210
0
Mei 23
1382
1
Des 24
3257
1
Mei 22
3745