This question has been flagged
4 Replies
16548 Views

Hi all,


I have setup an Odoo instance on AWS.
 
Postgres is setup on a different server from the odoo instance.

I can create a new database but I cannot see it on the /web/database/backup page. I know it's created because when I try to run the command again, I get the already exists error.


I keep getting Database restore error. Command 'psql' not found when I try to test if a restore for an old database works.

I can't even backup the default database as that gives me a Postgres error too.

So the connection and my config seems to kinda work but not fully. How do I get the psql commands to work?

Avatar
Discard
Best Answer
add this into conf file if you are using window.
pg_path= C:\Program Files\PostgreSQL\10\bin


Avatar
Discard

Thank you, I can resolve my error. Just a little bit note: we need to upgrade module base (if have) :D

Best Answer

Please check this link, it might be a good help !

https://github.com/Yenthe666/InstallScript/issues/178

Avatar
Discard
Best Answer

Please see this video https://youtu.be/J91jfMIJV2Y

Avatar
Discard
Author Best Answer

If anyone stumbles upon this in the future, I solved this by installing postgresql on the same EC2 instance as the odoo app.

Avatar
Discard