Hi, I restored new dump in my odoo by PSQL. Database created in PG admin and tables created. But database not showing in frontent.
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Comptabilité
- Inventaire
- PoS
- Projet
- MRP
Cette question a été signalée
2
Réponses
4334
Vues
Hi,
You can solve this issue by refer the following link
I have to do in command line ?
Create database database_name;
ALTER USER your_user WITH SUPERUSER;
psql database_name < dump.sql
ALTER DATABASE database_name OWNER TO your_user;
yes
i think in your case you have to do that last code for setting the owner
Actually I used this command to create database psql -h ip -d database name -U openpg -f D:\backup\dump.sql
can you use the above code for making backup, i think it will work smoothly
I changed Owner of the database in PG admin and my issue solved. Thanks every one...
Hi Dhivya,
Check Owner of you database, this is may the problem.
Regards,
Silvestar
Can you explain the steps to restore? So that I can identify in which step i did mistake.
Vous appréciez la discussion ? Ne vous contentez pas de lire, rejoignez-nous !
Créez un compte dès aujourd'hui pour profiter de fonctionnalités exclusives et échanger avec notre formidable communauté !
S'inscrire