Hello, my name is Jason.
I install Odoo with https://github.com/Verisage/docker-nginx-letsencrypt-odoo
For those familiar with this https://github.com/odoo/odoo/issues/40077
What I've done
part of my docker-compose.yml
db:
restart: always
image: postgres:12
environment:
- POSTGRES_DB=database
- POSTGRES_PASSWORD=password
- POSTGRES_USER=username
- PGDATA=/var/lib/postgresql/data/pgdata
volumes:
- odoo-db-data:/var/lib/postgresql/data/pgdata
1. Unable to delete the data using PostgreSQL
docker exec -it docker-nginx-letsencrypt-odoo_db_1 psql -U username -W database
UPDATE website_visitor SET active=true;
DELETE FROM website_visitor;
Output:
postgres=# DELETE FROM website_visitor;
ERROR: relation "website_visitor" does not exist
LINE 1: DELETE FROM website_visitor;
2. I've backup the database.
The scary part, should I flush the docker and reinstall it? Would everything be okay? Currently, I am unable to login to my account. I do not have the money yet to pay for an Odoo engineer, so I do everything on my own. I just use it to send RfQ to be professional with my supplier.
