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

DOUA Yanis

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 )

rehan

Auteur

how about the filestore?

DOUA Yanis

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

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!

Maak vandaag nog een account aan om te profiteren van exclusieve functies en deel uit te maken van onze geweldige community!

Aanmelden

Gerelateerde posts	Antwoorden	Weergaven
Database Restoration Error in V14 (unaccent_schema) postgresql restoredb v14 psycopg2.errors UndefinedFunction	0 nov. 23	6149
What version of PostgreSQL Odoo 14 uses ? and can we use the latest version of PostgreSQL (13) ? Opgelost postgresql v14	1 nov. 23	26044
Issue while migrating to Odoo SH \| Odoo 14 postgresql v14 Odoo.sh	0 mei 23	2133
Odoo error after restore Database Opgelost community restoredb v14	1 dec. 24	3906
After moving to new version of postgres database backup failed. database postgresql v14	1 mei 22	4645

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!