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.