odoo-13-docker-compose
odoo-13-docker-compose copied to clipboard
How to change database name, database user name and password?
Hi, Nice work, thank you. For security reasons, I want to change database name, database user name and password, at least the password, but I fail to do so.
I did modify both docker-compose and odoo.conf, cf here.
But I get ERROR: relation "ir_module_module" does not exist at character 53
:
odoo-db-1 | Success. You can now start the database server using:
odoo-db-1 |
odoo-db-1 | pg_ctl -D /var/lib/postgresql/data -l logfile start
odoo-db-1 |
odoo-db-1 | waiting for server to start....2022-09-19 10:57:54.843 UTC [52] LOG: starting PostgreSQL 14.5 (Debian 14.5-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
odoo-db-1 | 2022-09-19 10:57:55.169 UTC [52] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
odoo-db-1 | 2022-09-19 10:57:55.649 UTC [53] LOG: database system was shut down at 2022-09-19 10:57:14 UTC
odoo-db-1 | 2022-09-19 10:57:55.800 UTC [52] LOG: database system is ready to accept connections
odoo-db-1 | done
odoo-db-1 | server started
odoo-db-1 |
odoo-db-1 | /usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*
odoo-db-1 |
odoo-db-1 | waiting for server to shut down...2022-09-19 10:57:56.200 UTC [52] LOG: received fast shutdown request
odoo-db-1 | .2022-09-19 10:57:56.347 UTC [52] LOG: aborting any active transactions
odoo-db-1 | 2022-09-19 10:57:56.353 UTC [52] LOG: background worker "logical replication launcher" (PID 59) exited with exit code 1
odoo-db-1 | 2022-09-19 10:57:56.355 UTC [54] LOG: shutting down
odoo-db-1 | 2022-09-19 10:57:57.147 UTC [52] LOG: database system is shut down
odoo-db-1 | done
odoo-db-1 | server stopped
odoo-db-1 |
odoo-db-1 | PostgreSQL init process complete; ready for start up.
odoo-db-1 |
odoo-db-1 | 2022-09-19 10:57:57.595 UTC [1] LOG: starting PostgreSQL 14.5 (Debian 14.5-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
odoo-db-1 | 2022-09-19 10:57:57.595 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
odoo-db-1 | 2022-09-19 10:57:57.595 UTC [1] LOG: listening on IPv6 address "::", port 5432
odoo-db-1 | 2022-09-19 10:57:58.068 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
odoo-db-1 | 2022-09-19 10:57:58.226 UTC [64] LOG: database system was shut down at 2022-09-19 10:57:56 UTC
odoo-db-1 | 2022-09-19 10:57:58.227 UTC [65] FATAL: the database system is starting up
odoo-db-1 | 2022-09-19 10:57:58.322 UTC [1] LOG: database system is ready to accept connections
odoo-web-1 | Running as user 'root' is a security risk.
odoo-db-1 | 2022-09-19 10:59:01.661 UTC [84] ERROR: relation "ir_module_module" does not exist at character 53
odoo-db-1 | 2022-09-19 10:59:01.661 UTC [84] STATEMENT:
odoo-db-1 | SELECT latest_version
odoo-db-1 | FROM ir_module_module
odoo-db-1 | WHERE name='base'
Even when I change only the password with ASCII characters such as 123.
What do I miss? How could I achieve this please?